public void LoadGrid()
{
try
{
SMHR_WORKINGHOURS _obj_Smhr_WorkingHours = new SMHR_WORKINGHOURS();
if (Convert.ToString(Request.QueryString["ID"]) == null)
{
_obj_Smhr_WorkingHours.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
DataTable DT = BLL.get_WorkingHours(_obj_Smhr_WorkingHours);
Rg_WHours.DataSource = DT;
clearControls();
}
else
{
_obj_Smhr_WorkingHours.OPERATION = operation.Empty;
_obj_Smhr_WorkingHours.WRKHRS_BUSINESSUNIT_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["ID"]));
Rg_WHours.DataSource = BLL.get_WorkingHours(_obj_Smhr_WorkingHours);
clearControls();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_workinghours", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_WORKINGHOURS _obj_Smhr_WorkingHours = new SMHR_WORKINGHOURS();
_obj_Smhr_WorkingHours.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
_obj_Smhr_WorkingHours.WRKHRS_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_WHoursBunitID.SelectedItem.Value);
_obj_Smhr_WorkingHours.WRKHRS_DAY_ID = Convert.ToInt32(rcmb_WHoursDay.SelectedItem.Value);
_obj_Smhr_WorkingHours.WRKHRS_NOOFHOURS = Convert.ToInt32(rntxt_WhoursHours.Text);
_obj_Smhr_WorkingHours.WRKHRS_STARTTIME = Convert.ToString(Convert.ToDateTime(rtp_WhoursStartTime.SelectedDate).TimeOfDay);
_obj_Smhr_WorkingHours.WRKHRS_ENDTIME = Convert.ToString(Convert.ToDateTime(rtp_WhoursEndTime.SelectedDate).TimeOfDay);
_obj_Smhr_WorkingHours.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_WorkingHours.CREATEDDATE = DateTime.Now;
_obj_Smhr_WorkingHours.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_WorkingHours.LASTMDFDATE = DateTime.Now;
if (Convert.ToInt32(rntxt_WhoursHours.Text) > 0 && rtp_WhoursStartTime.SelectedDate != null && rtp_WhoursEndTime.SelectedDate != null)
{
//if (rtp_WhoursStartTime.SelectedDate != null && rtp_WhoursEndTime.SelectedDate != null)
//{
if (rtp_WhoursStartTime.SelectedDate > rtp_WhoursEndTime.SelectedDate)
{
BLL.ShowMessage(this, "End Time cannot be less than Start Time");
return;
}
else
{
DateTime EndTime = Convert.ToDateTime(rtp_WhoursEndTime.SelectedDate);
DateTime StartTime = Convert.ToDateTime(rtp_WhoursStartTime.SelectedDate);
TimeSpan span = EndTime - StartTime;
int hrs = span.Hours;
if (hrs != Convert.ToInt32(rntxt_WhoursHours.Text))
{
BLL.ShowMessage(this, "Working hours must match with No. of Hours");
return;
}
}
//}
}
switch (((Button)sender).ID.ToUpper())
{
case "BTN_EDIT":
_obj_Smhr_WorkingHours.WRKHRS_ID = Convert.ToInt32(lbl_WHoursID.Text);
_obj_Smhr_WorkingHours.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_WorkingHours(_obj_Smhr_WorkingHours).Rows[0]["Count"]) != "1")
{
BLL.ShowMessage(this, "Working Hours for this day to this Business Unit Already Exists");
return;
}
_obj_Smhr_WorkingHours.OPERATION = operation.Update;
if (BLL.set_WorkingHours(_obj_Smhr_WorkingHours))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_WorkingHours.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_WorkingHours(_obj_Smhr_WorkingHours).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Working Hours for this day to this Business Unit Already Exists");
return;
}
_obj_Smhr_WorkingHours.OPERATION = operation.Insert;
if (BLL.set_WorkingHours(_obj_Smhr_WorkingHours))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_WH_page.SelectedIndex = 0;
LoadGrid();
Rg_WHours.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_workinghours", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
