protected void lnk_Delete_Command(object sender, CommandEventArgs e)
{
try
{
_obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
lbl_HID = Convert.ToString(e.CommandArgument);
DataTable dt = new DataTable();
_obj_Smhr_Holiday.OPERATION = operation.Delete;
if (BLL.set_HolidayMaster(_obj_Smhr_Holiday))
{
BLL.ShowMessage(this, "Row deleted Successfully");
}
else
{
BLL.ShowMessage(this, "Row Could Not be Deleted");
}
LoadMainGrid();
Rg_HolidayCalendar.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
LoadCombos();
btn_Save.Visible = false;
_obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
lbl_HID = Convert.ToString(e.CommandArgument);
DataTable dt = new DataTable();
dt = BLL.get_HolidayMaster(_obj_Smhr_Holiday);
rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["HOLMST_BUSINESSUNITID"]));
// rcmb_BusinessUnit.SelectedIndex = Convert.ToInt32(dt.Rows[0]["HOLMST_BUSINESSUNITID"]);
rtxt_HCCode.Text = Convert.ToString(dt.Rows[0]["HOLMST_CODE"]);
rtxt_HCDesc.Text = Convert.ToString(dt.Rows[0]["HOLMST_DESCRIPTION"]);
rdtp_HCDATE.SelectedDate = Convert.ToDateTime(dt.Rows[0]["HOLMST_DATE"]);
rtxt_HCCode.Enabled = false;
Rm_HolidayCalendar_page.SelectedIndex = 1;
//code for security
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Edit.Visible = false;
}
else
{
btn_Edit.Visible = true;
}
//if (Convert.ToString(Request.QueryString["ID"]) == null)
//{
// rcmb_BusinessUnit.Enabled = true;
//}
//else
//{
rcmb_BusinessUnit.Enabled = false;
//}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadMainGrid()
{
try
{
if (Convert.ToString(Request.QueryString["ID"]) == null)
{
_obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
Rg_HolidayCalendar.DataSource = BLL.get_HolidayMaster(_obj_Smhr_Holiday);
for (int h = 0; h <= Rg_HolidayCalendar.Items.Count - 1; h++)
{
LinkButton lnk_Delete = new LinkButton();
lnk_Delete = Rg_HolidayCalendar.Items[h].FindControl("lnk_Delete") as LinkButton;
lnk_Delete.Visible = false;
}
Rm_HolidayCalendar_page.SelectedIndex = 0;
}
else
{
_obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.OPERATION = operation.Empty;
_obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(Convert.ToString(Request.QueryString["ID"]));
_obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
Rg_HolidayCalendar.DataSource = BLL.get_HolidayMaster(_obj_Smhr_Holiday);
for (int h = 0; h <= Rg_HolidayCalendar.Items.Count - 1; h++)
{
LinkButton lnk_Delete = new LinkButton();
lnk_Delete = Rg_HolidayCalendar.Items[h].FindControl("lnk_Delete") as LinkButton;
lnk_Delete.Visible = false;
}
Rm_HolidayCalendar_page.SelectedIndex = 0;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/*protected void rntb_Hours_TextChanged(object sender, EventArgs e)
* {
* try
* {
* decimal hrs = 0, mins = 0, val = 0, final = 0;
* string weekDay = string.Empty;
*
* if (rdtp_OTDt.SelectedDate != null)
* {
* weekDay = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString();
*
* if (weekDay == "Saturday" || weekDay == "Sunday")
* val = 2;
* else
* val = Convert.ToDecimal(1.5);
*
* if (rtbOTHrs.Text != string.Empty || rntb_Mins.Text != string.Empty)
* {
* if (rtbOTHrs.Text != string.Empty)
* hrs = Convert.ToDecimal(rtbOTHrs.Text) * 60; //to convert hours into minutes
* if (rntb_Mins.Text != string.Empty)
* mins = Convert.ToDecimal(rntb_Mins.Text);
*
* final = (hrs + mins) * val;
*
* if (final > 0)
* {
* rtbOTHrs.Text = Convert.ToString(final / 60).Substring(0, 2);
* rtbOTMins.Text = Convert.ToString(final % 60);
* }
* }
* else
* {
* if (rtbOTHrs.Text != string.Empty && rntb_Mins.Text != string.Empty)
* rtbOTHrs.Text = rntb_Mins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
* }
* }
* else
* {
* BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours");
* rtbOTHrs.Text = rntb_Mins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
* rdtp_OTDt.Focus();
* return;
* }
* }
* catch (Exception ex)
* {
* throw ex;
* }
* }*/
protected void rtbActHrs_TextChanged(object sender, EventArgs e)
{
try
{
decimal hrs = 0, mins = 0, val = 0, final = 0, hldyval = 0, hldyfinal = 0;
string weekDay = string.Empty;
string holiday = string.Empty;
int maxHrs = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["maxHrs"]);
int maxMins = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["maxMins"]);
SMHR_HOLIDAY _obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.OPERATION = operation.chkholiday;
_obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_Smhr_Holiday.HOLMST_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate);
if (rdtp_OTDt.SelectedDate == null)
{
BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours");
rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
rdtp_OTDt.Focus();
return;
}
DataTable dthld = new DataTable();
dthld = BLL.get_HolidayMaster(_obj_Smhr_Holiday);
if (Convert.ToInt32(dthld.Rows[0]["HOLMST_DATE"]) > 0)
{
if (rdtp_OTDt.SelectedDate != null)
{
holiday = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString();
if (holiday == "Saturday" || holiday == "Sunday")
{
hldyval = 2;
}
else
{
hldyval = Convert.ToInt32(2);
}
if (rtbActHrs.Text != string.Empty || rtbActMins.Text != string.Empty)
{
if (rtbActHrs.Text != string.Empty)
{
if (Convert.ToInt32(rtbActHrs.Text) > 12)
{
rtbActHrs.Text = maxHrs.ToString();
}
}
if (rtbActMins.Text != string.Empty)
{
if (Convert.ToInt32(rtbActMins.Text) > 59)
{
rtbActMins.Text = maxMins.ToString();
}
}
if (rtbActHrs.Text != string.Empty)
{
hrs = Convert.ToDecimal(rtbActHrs.Text) * 60; //to convert hours into minutes
}
if (rtbActMins.Text != string.Empty)
{
mins = Convert.ToDecimal(rtbActMins.Text);
}
hldyfinal = (hrs + mins) * hldyval;
if (hldyval > 0)
{
if (Convert.ToString(hldyfinal / 60).Contains('.'))
{
rtbOTHrs.Text = Convert.ToString(hldyfinal / 60).Substring(0, Convert.ToString(hldyfinal / 60).IndexOf('.'));
}
else
{
rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(hldyfinal / 60));
}
rtbOTMins.Text = Convert.ToString(Convert.ToInt32((hldyfinal % 60) + Convert.ToDecimal(0.1)));
}
}
else
{
if (rtbActHrs.Text == string.Empty && rtbActMins.Text == string.Empty)
{
rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
}
}
}
}
else if (rdtp_OTDt.SelectedDate != null)
{
weekDay = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString();
if (weekDay == "Saturday" || weekDay == "Sunday")
{
val = 2;
}
else
{
val = Convert.ToDecimal(1.5);
}
if (rtbActHrs.Text != string.Empty || rtbActMins.Text != string.Empty)
{
if (rtbActHrs.Text != string.Empty)
{
if (Convert.ToInt32(rtbActHrs.Text) > 12)
{
rtbActHrs.Text = maxHrs.ToString();
}
}
if (rtbActMins.Text != string.Empty)
{
if (Convert.ToInt32(rtbActMins.Text) > 59)
{
rtbActMins.Text = maxMins.ToString();
}
}
if (rtbActHrs.Text != string.Empty)
{
hrs = Convert.ToDecimal(rtbActHrs.Text) * 60; //to convert hours into minutes
}
if (rtbActMins.Text != string.Empty)
{
mins = Convert.ToDecimal(rtbActMins.Text);
}
final = (hrs + mins) * val;
//hldyfinal = (hrs + mins) * hldyval;
//if (hldyval>0)
//{
// if (Convert.ToString(hldyfinal / 60).Contains('.'))
// rtbOTHrs.Text = Convert.ToString(hldyfinal / 60).Substring(0, Convert.ToString(hldyfinal / 60).IndexOf('.'));
// else
// rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(hldyfinal / 60));
// rtbOTMins.Text = Convert.ToString(Convert.ToInt32((hldyfinal % 60) + Convert.ToDecimal(0.1)));
//}
if (final > 0)
{
if (Convert.ToString(final / 60).Contains('.'))
{
rtbOTHrs.Text = Convert.ToString(final / 60).Substring(0, Convert.ToString(final / 60).IndexOf('.'));
}
else
{
rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(final / 60));
}
rtbOTMins.Text = Convert.ToString(Convert.ToInt32((final % 60) + Convert.ToDecimal(0.1)));
}
}
else
{
if (rtbActHrs.Text == string.Empty && rtbActMins.Text == string.Empty)
{
rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
}
}
}
else
{
BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours");
rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty;
rdtp_OTDt.Focus();
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcRM", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Holiday = new SMHR_HOLIDAY();
_obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
_obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
_obj_Smhr_Holiday.HOLMST_CODE = Convert.ToString(rtxt_HCCode.Text);
if (_obj_Smhr_Holiday.HOLMST_CODE.Contains("'"))
{
_obj_Smhr_Holiday.HOLMST_CODE = _obj_Smhr_Holiday.HOLMST_CODE.Replace("'", "''");
}
_obj_Smhr_Holiday.HOLMST_DESCRIPTION = Convert.ToString(rtxt_HCDesc.Text);
if (_obj_Smhr_Holiday.HOLMST_DESCRIPTION.Contains("'"))
{
_obj_Smhr_Holiday.HOLMST_DESCRIPTION = _obj_Smhr_Holiday.HOLMST_DESCRIPTION.Replace("'", "''");
}
_obj_Smhr_Holiday.HOLMST_DATE = Convert.ToDateTime(rdtp_HCDATE.SelectedDate);
_obj_Smhr_Holiday.HOLMST_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Holiday.HOLMST_CREATEDDATE = DateTime.Now;
_obj_Smhr_Holiday.HOLMST_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Holiday.HOLMST_LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SAVE":
_obj_Smhr_Holiday.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_HolidayMaster(_obj_Smhr_Holiday).Rows[0][0]) != "0")
{
BLL.ShowMessage(this, "This Holiday Name Is Already Exists");
rtxt_HCCode.Text = String.Empty;
return;
}
_obj_Smhr_Holiday.OPERATION = operation.Insert;
if (BLL.set_HolidayMaster(_obj_Smhr_Holiday))
{
BLL.ShowMessage(this, "Information Saved Successfully");
Rm_HolidayCalendar_page.SelectedIndex = 0;
LoadMainGrid();
Rg_HolidayCalendar.DataBind();
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_EDIT":
_obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(lbl_HID);
_obj_Smhr_Holiday.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_HolidayMaster(_obj_Smhr_Holiday).Rows[0][0]) != "1")
{
BLL.ShowMessage(this, "This Holiday Name Is Already Exists");
rtxt_HCCode.Text = String.Empty;
return;
}
_obj_Smhr_Holiday.OPERATION = operation.Update;
if (BLL.set_HolidayMaster(_obj_Smhr_Holiday))
{
BLL.ShowMessage(this, "Information Updated Successfully");
Rm_HolidayCalendar_page.SelectedIndex = 0;
LoadMainGrid();
Rg_HolidayCalendar.DataBind();
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
