protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
lbl_CourseHeader.Visible = false;
// rcmb_CC.Enabled = false;
clearControls();
LoadCombos();
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.LocationID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Get;
DataTable dt = BLL.get_TrainingLocation(_obj_Smhr_Location);
if (dt.Rows.Count != 0)
{
Rm_Course_page.SelectedIndex = 1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingRequest", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadGrid()
{
try
{
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Select;
DataTable DT = BLL.get_TrainingLocation(_obj_Smhr_Location);
if (DT.Rows.Count != 0)
{
Rg_Course.DataSource = DT;
}
else
{
DataTable dt1 = new DataTable();
Rg_Course.DataSource = dt1;
}
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
// lbl_CourseHeader.Visible = false;
// rcmb_CC.Enabled = false;
clearControls();
LoadCombos();
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.LocationID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Get;
DataTable dt = BLL.get_TrainingLocation(_obj_Smhr_Location);
if (dt.Rows.Count != 0)
{
radLocation.Enabled = false;
lblLocationId.Text = dt.Rows[0]["Location_ID"].ToString();
radLocation.Text = dt.Rows[0]["Location_Name"].ToString();
rtxt_StreetName.Text = dt.Rows[0]["Location_StreetName"].ToString();
LoadCombos();
radCountry.SelectedIndex = radCountry.FindItemIndexByValue(dt.Rows[0]["Location_CountryID"].ToString());
radCountry_SelectedIndexChanged(null, null);
radCounty.SelectedIndex = radCounty.FindItemIndexByValue(dt.Rows[0]["Location_CountyID"].ToString());
radCounty_SelectedIndexChanged(null, null);
radTown.SelectedIndex = radTown.FindItemIndexByValue(dt.Rows[0]["Location_TownID"].ToString());
radContactName.Text = dt.Rows[0]["Location_ContactPerson"].ToString();
radContactNo.Text = dt.Rows[0]["Location_ContactNo"].ToString();
radEmailID.Text = dt.Rows[0]["Location_EmailID"].ToString();
radAlternateContact1.Text = dt.Rows[0]["Location_AlternateContactNo"].ToString();
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["Location_Status"]);
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_Course_page.SelectedIndex = 1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
SMHR_TRAINING_LOCATION _obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Select2;
radLocation.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location);
radLocation.DataValueField = "Location_ID";
radLocation.DataTextField = "Location_Name";
radLocation.DataBind();
radLocation.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingRooms", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Period.OPERATION = operation.Select;
obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(obj_smhr_Period);
//DataTable dt_Details = BLL.get_PeriodHeaderDetails_Calendar(obj_smhr_Period);
rcmb_Period.DataSource = dt_Details;
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Select1;
rcmb_Location.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location);
rcmb_Location.DataTextField = "Location_Name";
rcmb_Location.DataValueField = "Location_ID";
rcmb_Location.DataBind();
rcmb_Location.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
if (string.Compare(Control, "EmployeeAttendance", true) == 0)
{
SMHR_COURSE _obj_Course = new SMHR_COURSE();
_obj_Course.OPERATION = operation.Select2;
_obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); //Convert.ToInt32(Session["ORG_ID"]);
rcmb_Course.DataSource = BLL.get_Course(_obj_Course);
rcmb_Course.DataTextField = "COURSE_NAME";
rcmb_Course.DataValueField = "COURSE_ID";
rcmb_Course.DataBind();
rcmb_Course.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LocationWiseTrainingProgram", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
SMHR_COURSE _obj_Course = new SMHR_COURSE();
_obj_Course.OPERATION = operation.Select2;
_obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); //Convert.ToInt32(Session["ORG_ID"]);
radCourse.DataSource = BLL.get_Course(_obj_Course);
radCourse.DataTextField = "COURSE_NAME";
radCourse.DataValueField = "COURSE_ID";
radCourse.DataBind();
radCourse.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
_obj_Smhr_Masters = new SMHR_MASTERS();
_obj_Smhr_Masters.MASTER_TYPE = "COURSETYPE";
_obj_Smhr_Masters.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
radCourseType.DataSource = BLL.get_MasterRecords(_obj_Smhr_Masters);
radCourseType.DataTextField = "HR_MASTER_CODE";
radCourseType.DataValueField = "HR_MASTER_ID";
radCourseType.DataBind();
radCourseType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Select1;
radLocation.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location);
radLocation.DataTextField = "Location_Name";
radLocation.DataValueField = "Location_ID";
radLocation.DataBind();
radLocation.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CourseSchedule", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.LocationName = radLocation.Text;
_obj_Smhr_Location.Location_StreetName = rtxt_StreetName.Text;
_obj_Smhr_Location.Location_CountryID = Convert.ToInt32(radCountry.SelectedValue);
_obj_Smhr_Location.Location_CountyID = Convert.ToInt32(radCounty.SelectedValue);
_obj_Smhr_Location.Location_TownID = Convert.ToInt32(radTown.SelectedValue);
_obj_Smhr_Location.Location_ContactPerson = radContactName.Text;
_obj_Smhr_Location.Location_EmailID = radEmailID.Text;
_obj_Smhr_Location.Location_ContactNo = radContactNo.Text;
_obj_Smhr_Location.Location_AlternateContactNo = radAlternateContact1.Text;
_obj_Smhr_Location.Location_Status = rad_IsActive.Checked;
_obj_Smhr_Location.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Location.CREATEDDATE = DateTime.Now;
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Location.LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
if (Convert.ToBoolean(rad_IsActive.Checked) == false)
{
SMHR_COURSESCHEDULE _obj_CS = new SMHR_COURSESCHEDULE();
_obj_CS.OPERATION = operation.Scale;
_obj_CS.COURSESCHEDULE_LOCATIONID = Convert.ToInt32(lblLocationId.Text);
_obj_CS.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtc = BLL.get_CourseSchedule(_obj_CS);
if (!Convert.ToBoolean(dtc.Rows[0]["Status"]))
{
BLL.ShowMessage(this, "Cannot make inactive");
rad_IsActive.Checked = true;
return;
}
}
_obj_Smhr_Location.OPERATION = operation.Update;
_obj_Smhr_Location.LocationID = Convert.ToInt32(lblLocationId.Text);
if (BLL.set_TrainingLocation(_obj_Smhr_Location))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Location.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_TrainingLocation(_obj_Smhr_Location).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Location with this Name Already Exists");
return;
}
_obj_Smhr_Location.OPERATION = operation.Insert;
if (BLL.set_TrainingLocation(_obj_Smhr_Location))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
Rg_Course.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
