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");
}
