compare two date from two table in sqlserver

Manish Solanki

11y1k

Hello Everyone

I have two table..

1. Holiday

-HolidayId

-Description

-HolidayDate

- Status

2. EmployeeLeaves

- LeaveId

-EmployeeId

-RequestedDate

-LeaveReason

-LeaveFrom

-LeaveTo

-LeaveStatus

now when employee apply for the leave that time the HolidayDate will be compare with leaveFrom and LeaveTo date.

suppose sir, 11/11/2015 is holiday this is allready in Holiday table. now when employee apply for the same date for leave that time it will alert message is printed "you can not apply for this day this is already holiday".I want this kind of output.

can please help for this for procedure and apply in aspx page.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupali Shinde11y ago
Hi Manish,

Table Name - Holiday
Column - HolidayDate
DateType - Date

using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Server=...;Database=...;Trusted_Connection=true";
conn.Open();
DateTime TodayDate = DateTime.Today;
// Create the command
SqlCommand cmd = new SqlCommand("SELECT * FROM Holiday WHERE HolidayDate = '" + TodayDate.ToString("yyyy-MM-dd") + "'", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
//DataTable firstTable = dataSet.Tables[0];
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
DateTime CurrentDate = Convert.ToDateTime(dr["HolidayDate"]);
int result = DateTime.Compare(TodayDate, CurrentDate);
string relationship = "";
if (result < 0)
relationship = "is earlier than";
else if (result == 0)
relationship = "is the same time as";
else
relationship = "is later than";
}

}

If it works out, Please Accept this as Answer
+1
Manish Solanki11y ago
Hello sir,
can you give me some code so i can get some hint.
0
Jignesh Trivedi11y ago
Hi,
when you want to this message?
At the time of date selection or on apply leave button
also share your screen inputs...
0