protected void Button2_submit_Click(object sender, EventArgs e) { DateTime t2 = Convert.ToDateTime("04:59:59 PM"); DateTime t1 = Convert.ToDateTime(TextBox_timeAndDay.Text); if (TimeSpan.Compare(t1.TimeOfDay, t2.TimeOfDay) == 1) //forward to warden { int i = Data_Access.apply_sameDayLeave(Session["sap_id"].ToString(), t1.Date.ToString(), TextBox_reason_sameDay.Text, t1.TimeOfDay.ToString()); if (i == 0) { Label_sameDay_result.Text = "You have already applied for same day leave"; Label_sameDay_result.Visible = true; } else { Label_sameDay_result.Text = "Successfully Applied for Leave"; Label_sameDay_result.Visible = true; } } else { String mentor_email; String i = Data_Access.Apply_Leave(Session["sap_id"].ToString(), t1.Date.ToString(), t1.Date.ToString(), TextBox_reason_sameDay.Text, out mentor_email, 1); Label_sameDay_result.Text = i; Label_sameDay_result.Visible = true; Data_Access.MailSend(mentor_email, "Same Day Leave", "Same day leave has been posted, you may take your action before 4:00 PM"); } }
protected void Button1_Click(object sender, EventArgs e) { int days_holiday = 0; //number of days having holiday List <DateTime> date_range = GetDateRange(Convert.ToDateTime(TextBox_date_from.Text), Convert.ToDateTime(TextBox_date_to.Text).Date); int days_leave = date_range.Count; // total number of days leave applied for foreach (DateTime item in date_range) { if (item.DayOfWeek == DayOfWeek.Sunday) { days_holiday++; } else { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand cmd = new SqlCommand("select date from academic_leave where date='" + item.ToString("yyyy-MM-dd") + "'", con); object c = cmd.ExecuteScalar(); if (c != null) { days_holiday++; } con.Close(); } } Label_result.Visible = true; String mentor_email = ""; if ((days_leave - days_holiday) != 0) { Label_result.Text = Data_Access.Apply_Leave(Session["sap_id"].ToString(), TextBox_date_from.Text, TextBox_date_to.Text, TextBox_reason.Text, out mentor_email, days_leave - days_holiday); } else { Label_result.Text = Data_Access.Apply_Leave(Session["sap_id"].ToString(), TextBox_date_from.Text, TextBox_date_to.Text, TextBox_reason.Text, out mentor_email, days_holiday); } Data_Access.MailSend(mentor_email, "Mentor Leave Notification", "New leave has been posted"); }