public void LoadGrid()
{
try
{
SMHR_COURSESCHEDULE _obj_Smhr_CourseSchedule = new SMHR_COURSESCHEDULE();
_obj_Smhr_CourseSchedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_CourseSchedule.OPERATION = operation.Select;
DataTable DT = BLL.get_CourseSchedule(_obj_Smhr_CourseSchedule);
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_CourseSchedule", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_CourseName_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (string.Compare(rcmb_CourseName.SelectedItem.Text, "Select", true) != 0)
{
SMHR_COURSESCHEDULE _obj_Smhr_TrgRqst = new SMHR_COURSESCHEDULE();
_obj_Smhr_TrgRqst.OPERATION = operation.Course;
_obj_Smhr_TrgRqst.COURSESCHEDULE_COURSEID = Convert.ToInt32(rcmb_CourseName.SelectedValue);
_obj_Smhr_TrgRqst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);//YYY
rcmb_CourseSchedule.DataSource = BLL.get_CourseSchedule(_obj_Smhr_TrgRqst);
rcmb_CourseSchedule.DataValueField = "CourseSchedule_ID";
rcmb_CourseSchedule.DataTextField = "CourseSchedule_Name";
rcmb_CourseSchedule.DataBind();
rcmb_CourseSchedule.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
SMHR_CHAPTERS _obj_Chapter = new SMHR_CHAPTERS();
_obj_Chapter.OPERATION = operation.Select1;
_obj_Chapter.CHARPTER_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Chapter.CHAPTER_COURSE_ID = Convert.ToInt32(rcmb_CourseName.SelectedValue);
radChapters.DataSource = BLL.get_Chapter(_obj_Chapter);
radChapters.DataTextField = "CHAPTER_NAME";
radChapters.DataValueField = "CHAPTER_ID";
radChapters.DataBind();
radChapters.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_TrainingFeedBack", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_Course_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_Course.SelectedIndex > 0)
{
SMHR_COURSESCHEDULE oSMHR_COURSESCHEDULE = new SMHR_COURSESCHEDULE();
oSMHR_COURSESCHEDULE.OPERATION = operation.Course3;
oSMHR_COURSESCHEDULE.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
oSMHR_COURSESCHEDULE.COURSESCHEDULE_COURSEID = Convert.ToInt32(rcmb_Course.SelectedItem.Value);
rcmb_batch.DataSource = BLL.get_CourseSchedule(oSMHR_COURSESCHEDULE);
rcmb_batch.DataTextField = "CourseSchedule_Name";
rcmb_batch.DataValueField = "CourseSchedule_ID";
rcmb_batch.DataBind();
rcmb_batch.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
else
{
rcmb_batch.ClearSelection();
rcmb_batch.Items.Clear();
rcmb_batch.Text = string.Empty;
}
}
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 BindBatches()
{
try
{
if (Request.QueryString.HasKeys())
{
SMHR_COURSESCHEDULE _obj_Smhr_CourseSchedule = new SMHR_COURSESCHEDULE();
_obj_Smhr_CourseSchedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_COURSEID = Convert.ToInt32(radCourse.SelectedValue);
_obj_Smhr_CourseSchedule.CREATEDBY = Convert.ToInt32(Request.QueryString["EMP_ID"]);
_obj_Smhr_CourseSchedule.OPERATION = operation.Select2;
DataTable DT = BLL.get_CourseSchedule(_obj_Smhr_CourseSchedule);
if (DT.Rows.Count != 0)
{
RGBatcheDetails.DataSource = DT;
}
else
{
DataTable dt1 = new DataTable();
RGBatcheDetails.DataSource = dt1;
}
RGBatcheDetails.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "TrainingRequestPopup", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void radCourse_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
clearControls();
RadGrid1.Visible = false;
RG_Assessments.Visible = false;
if (string.Compare(rc_Course.SelectedItem.Text, "Select", true) != 0)
{
SMHR_COURSESCHEDULE _obj_Smhr_TrgRqst = new SMHR_COURSESCHEDULE();
_obj_Smhr_TrgRqst.OPERATION = operation.Select3;
_obj_Smhr_TrgRqst.COURSESCHEDULE_COURSEID = Convert.ToInt32(rc_Course.SelectedValue);
_obj_Smhr_TrgRqst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);//YYY
rc_CourseSchedule.DataSource = BLL.get_CourseSchedule(_obj_Smhr_TrgRqst);
rc_CourseSchedule.DataValueField = "CourseSchedule_ID";
rc_CourseSchedule.DataTextField = "CourseSchedule_Name";
rc_CourseSchedule.DataBind();
rc_CourseSchedule.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_Assessment", 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;
radBatchDetail.Enabled = false;
clearControls();
LoadCombos();
SMHR_COURSESCHEDULE _obj_Smhr_CourseSchedule = new SMHR_COURSESCHEDULE();
_obj_Smhr_CourseSchedule.COURSESCHEDULEID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_CourseSchedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_CourseSchedule.OPERATION = operation.Get;
DataTable dt = BLL.get_CourseSchedule(_obj_Smhr_CourseSchedule);
if (dt.Rows.Count != 0)
{
radStartdate.MinDate = new DateTime();
radEndDate.MinDate = new DateTime();
LoadCombos();
lblCourseScheduleID.Text = dt.Rows[0]["CourseSchedule_ID"].ToString();
radBatchDetail.Text = dt.Rows[0]["CourseSchedule_Name"].ToString();
radCourse.SelectedIndex = radCourse.FindItemIndexByValue(dt.Rows[0]["CourseSchedule_CourseID"].ToString());
radCourse_SelectedIndexChanged(null, null);
radCourseType.SelectedIndex = radCourseType.FindItemIndexByValue(dt.Rows[0]["CourseSchedule_CourseTypeID"].ToString());
radLocation.SelectedIndex = radLocation.FindItemIndexByValue(dt.Rows[0]["CourseSchedule_LocationID"].ToString());
radLocation_SelectedIndexChanged(null, null);
radTrainingRoom.SelectedIndex = radTrainingRoom.FindItemIndexByValue(dt.Rows[0]["CourseSchedule_RoomID"].ToString());
radTrainingRoom.Enabled = false;
radLocation.Enabled = false;
radTrainers.SelectedIndex = radTrainers.FindItemIndexByValue(dt.Rows[0]["CourseSchedule_TrainerID"].ToString());
radSessions.Text = dt.Rows[0]["CourseSchedule_NoOfSessions"].ToString();
radSeats.Text = dt.Rows[0]["CourseSchedule_NoOfSeats"].ToString();
radStartdate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["CourseSchedule_StartDate"]);
radStartTime.SelectedDate = Convert.ToDateTime(dt.Rows[0]["CourseSchedule_SatartTime"]);
radEndDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["CourseSchedule_EndDate"]);
radEndTime.SelectedDate = Convert.ToDateTime(dt.Rows[0]["CourseSchedule_EndTime"]);
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["CourseSchedule_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_CourseSchedule", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rc_CourseSchedule_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rc_CourseSchedule.SelectedIndex > 0)
{
rc_Days.SelectedIndex = -1;
rc_Days.Items.Clear();
Btn_cancel.Visible = false;
btn_submit.Visible = false;
RG_TrainingApproval.Visible = false;
SMHR_COURSESCHEDULE _obj_Smhr_TrgRqst = new SMHR_COURSESCHEDULE();
_obj_Smhr_TrgRqst.OPERATION = operation.Select4;
_obj_Smhr_TrgRqst.COURSESCHEDULEID = Convert.ToInt32(rc_CourseSchedule.SelectedValue);
DataTable dt = BLL.get_CourseSchedule(_obj_Smhr_TrgRqst);
int noOfDays = Convert.ToInt32(dt.Rows[0]["CourseSchedule_NoOfSessions"]);
if (noOfDays > 0)
{
List <Days> lstDays = new List <Days>();
Days d = new Days();
d.DayID = 0; d.DayName = "Select";
lstDays.Add(d);
for (int i = 1; i <= noOfDays; i++)
{
d = new Days();
d.DayID = i;
d.DayName = "Day " + i.ToString();
lstDays.Add(d);
}
rc_Days.DataSource = lstDays.ToArray();
rc_Days.DataValueField = "DayID";
rc_Days.DataTextField = "DayName";
rc_Days.DataBind();
}
}
else
{
rc_Days.Items.Clear();
RG_TrainingApproval.Visible = false;
Btn_cancel.Visible = false;
btn_submit.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AttendanceDetails", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadComboSchedule()
{
try
{
SMHR_COURSESCHEDULE _obj_Smhr_TrgRqst = new SMHR_COURSESCHEDULE();
_obj_Smhr_TrgRqst.OPERATION = operation.Select3;
_obj_Smhr_TrgRqst.COURSESCHEDULE_COURSEID = Convert.ToInt32(rcmb_CC.SelectedValue);
_obj_Smhr_TrgRqst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);//YYY
rfc_rcmb_CS.DataSource = BLL.get_CourseSchedule(_obj_Smhr_TrgRqst);
rfc_rcmb_CS.DataValueField = "CourseSchedule_ID";
rfc_rcmb_CS.DataTextField = "CourseSchedule_Name";
rfc_rcmb_CS.DataBind();
rfc_rcmb_CS.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_offline Assessments", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_Location_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
SMHR_COURSESCHEDULE _obj_Course = new SMHR_COURSESCHEDULE();
_obj_Course.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //Convert.ToInt32(Session["ORG_ID"]);
_obj_Course.COURSESCHEDULE_LOCATIONID = Convert.ToInt32(rcmb_Location.SelectedValue);
DataTable dt_Course = BLL.get_CourseProc(_obj_Course);
rcmb_Course.DataSource = dt_Course;
rcmb_Course.DataValueField = "COURSE_ID";
rcmb_Course.DataTextField = "COURSE_NAME";
rcmb_Course.DataBind();
rcmb_Course.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_batch.Items.Clear();
rcmb_batch.Text = string.Empty;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LocatinoWiseTrainingProgram", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
DateTime startDate = radStartdate.SelectedDate.Value.Date;
DateTime endDate = radEndDate.SelectedDate.Value.Date;
double NumberOfDays = endDate.AddDays(1).Subtract(startDate).TotalDays;
if (Convert.ToInt32(radSessions.Text) > Convert.ToInt32(NumberOfDays))
{
BLL.ShowMessage(this, "Please Check Number Of Days should be between Start Date and End Date");
return;
}
SMHR_COURSESCHEDULE _obj_Smhr_CourseSchedule = new SMHR_COURSESCHEDULE();
_obj_Smhr_CourseSchedule.COURSESCHEDULE_COURSEID = Convert.ToInt32(radCourse.SelectedValue);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_COURSETYPEID = Convert.ToInt32(radCourseType.SelectedValue);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_LOCATIONID = Convert.ToInt32(radLocation.SelectedValue);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_ROOMID = Convert.ToInt32(radTrainingRoom.SelectedValue);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_TRAINERID = Convert.ToInt32(radTrainers.SelectedValue);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_NOOFSESSIONS = Convert.ToInt32(radSessions.Text);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_NOOFSEATS = Convert.ToInt32(radSeats.Text);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_STARTDATE = Convert.ToDateTime(radStartdate.SelectedDate);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_SATARTTIME = Convert.ToDateTime(radStartTime.SelectedDate);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_ENDDATE = Convert.ToDateTime(radEndDate.SelectedDate);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_ENDTIME = Convert.ToDateTime(radEndTime.SelectedDate);
_obj_Smhr_CourseSchedule.COURSESCHEDULE_NAME = radBatchDetail.Text;
_obj_Smhr_CourseSchedule.COURSESCHEDULE_STATUS = rad_IsActive.Checked;
_obj_Smhr_CourseSchedule.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_CourseSchedule.CREATEDDATE = DateTime.Now;
_obj_Smhr_CourseSchedule.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_CourseSchedule.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_CourseSchedule.LASTMDFDATE = DateTime.Now;
SMHR_TRAINING_ROOM _obj_Smhr_Room; DataTable dtRooms;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SAVE":
_obj_Smhr_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.ROOMID = Convert.ToInt32(radTrainingRoom.SelectedValue);
_obj_Smhr_Room.SMHR_COURSESCHEDULE = new SMHR_COURSESCHEDULE();
_obj_Smhr_Room.SMHR_COURSESCHEDULE.COURSESCHEDULE_STARTDATE = (DateTime)radStartdate.SelectedDate;
_obj_Smhr_Room.SMHR_COURSESCHEDULE.COURSESCHEDULE_SATARTTIME = (DateTime)radStartTime.SelectedDate;
_obj_Smhr_Room.OPERATION = operation.Select1;
dtRooms = BLL.get_TrainingRooms(_obj_Smhr_Room);
if (Convert.ToBoolean(dtRooms.Rows[0]["Status"]))
{
int roomStrength = Convert.ToInt32(dtRooms.Rows[0]["ROOMS_STRENGTH"]);
if (Convert.ToInt32(radSeats.Text) > roomStrength)
{
BLL.ShowMessage(this, "Number of Seats should be less than or equal to " + Convert.ToString(roomStrength));
return;
}
}
else
{
BLL.ShowMessage(this, "Selected Training Room is Already Allocated");
return;
}
_obj_Smhr_CourseSchedule.COURSESCHEDULE_COURSEID = Convert.ToInt32(radCourse.SelectedValue);
_obj_Smhr_CourseSchedule.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_CourseSchedule(_obj_Smhr_CourseSchedule).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Course Schedule Name Already Exists");
return;
}
_obj_Smhr_CourseSchedule.OPERATION = operation.Insert;
if (BLL.set_CourseSchedule(_obj_Smhr_CourseSchedule))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_UPDATE":
_obj_Smhr_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.ROOMID = Convert.ToInt32(radTrainingRoom.SelectedValue);
_obj_Smhr_Room.SMHR_COURSESCHEDULE = new SMHR_COURSESCHEDULE();
_obj_Smhr_Room.SMHR_COURSESCHEDULE.COURSESCHEDULE_STARTDATE = (DateTime)radStartdate.SelectedDate;
_obj_Smhr_Room.SMHR_COURSESCHEDULE.COURSESCHEDULE_SATARTTIME = (DateTime)radStartTime.SelectedDate;
_obj_Smhr_Room.OPERATION = operation.Select1;
dtRooms = BLL.get_TrainingRooms(_obj_Smhr_Room);
int roomStrength1 = Convert.ToInt32(dtRooms.Rows[0]["ROOMS_STRENGTH"]);
if (Convert.ToInt32(radSeats.Text) > roomStrength1)
{
BLL.ShowMessage(this, "Number of Seats should be less than or equal to " + Convert.ToString(roomStrength1));
return;
}
_obj_Smhr_CourseSchedule.COURSESCHEDULEID = Convert.ToInt32(lblCourseScheduleID.Text);
if (Convert.ToBoolean(rad_IsActive.Checked) == false)
{
SMHR_COURSESCHEDULE _obj_CourseSchedule = new SMHR_COURSESCHEDULE();
_obj_CourseSchedule.OPERATION = operation.MODE;
_obj_CourseSchedule.COURSESCHEDULEID = Convert.ToInt32(lblCourseScheduleID.Text);
DataTable dt = BLL.get_CourseSchedule(_obj_CourseSchedule);
if (!Convert.ToBoolean(dt.Rows[0]["Status"]))
{
BLL.ShowMessage(this, "Cannot make inactive");
rad_IsActive.Checked = true;
return;
}
}
_obj_Smhr_CourseSchedule.OPERATION = operation.Update;
if (BLL.set_CourseSchedule(_obj_Smhr_CourseSchedule))
{
BLL.ShowMessage(this, "Information Updated 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_CourseSchedule", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// save click methods
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Course = new SMHR_COURSE();
_obj_Smhr_Course.COURSE_NAME = BLL.ReplaceQuote(rtxt_CourseName.Text);
_obj_Smhr_Course.COURSE_DESC = BLL.ReplaceQuote(rtxt_CourseDesc.Text);
_obj_Smhr_Course.COURSE_CATEGORYID = rcmb_CC.SelectedItem.Value;
_obj_Smhr_Course.COURSE_DURATION = Convert.ToInt32(radCourseDuration.Text);
_obj_Smhr_Course.COURSE_STATUS = rad_IsActive.Checked;
_obj_Smhr_Course.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Course.CREATEDDATE = DateTime.Now;
_obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Course.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Course.LASTMDFDATE = DateTime.Now;
_obj_Smhr_Course.COURSE_DESIGNEDFOR = rtxt_CDS.Text;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
if (rad_IsActive.Checked == false && rad_IsActive.Checked == Convert.ToBoolean(hdnStatus.Value))
{
BLL.ShowMessage(this, "There is no data to update");
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
return;
}
if (rad_IsActive.Checked)
{
_obj_Smhr_Course.OPERATION = operation.Select1;
if (!Convert.ToBoolean(BLL.get_Course(_obj_Smhr_Course).Rows[0]["HR_MASTER_STATUS"]))
{
BLL.ShowMessage(this, "Please Change Course Category Status to Active for this Course");
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
return;
}
}
else
{
SMHR_COURSESCHEDULE _obj_CS = new SMHR_COURSESCHEDULE();
_obj_CS.OPERATION = operation.Online;
_obj_CS.COURSESCHEDULE_COURSEID = Convert.ToInt32(lbl_CourseId.Text);
_obj_CS.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// _obj_CS.COURSESCHEDULE_STATUS=rad_IsActive.Checked;
DataTable dtc = BLL.get_CourseSchedule(_obj_CS);
if (!Convert.ToBoolean(dtc.Rows[0]["Status"]))
{
BLL.ShowMessage(this, Convert.ToString(dtc.Rows[0]["ErrorMessage"]));
rad_IsActive.Checked = true;
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
return;
}
}
//if (Convert.ToBoolean(rad_IsActive.Checked) == false)
//{
// SMHR_TRAINERPROFILE _obj_Trainer = new SMHR_TRAINERPROFILE();
// _obj_Trainer.TRAINER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
// _obj_Trainer.Trainer_CourseCategory = Convert.ToInt32(lbl_CourseId.Text);
// _obj_Trainer.OPERATION = operation.Scale;
// DataTable dt = BLL.get_TrainingProfile(_obj_Trainer);
// if (!Convert.ToBoolean(dt.Rows[0]["Status"]))
// {
// BLL.ShowMessage(this, "Cannot make inactive");
// rad_IsActive.Checked = true;
// return;
// }
//}
_obj_Smhr_Course.COURSE_ID = Convert.ToInt32(lbl_CourseId.Text);
_obj_Smhr_Course.OPERATION = operation.Update;
if (BLL.set_Course(_obj_Smhr_Course))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Course.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Course(_obj_Smhr_Course).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Course with this Name Already Exists");
return;
}
_obj_Smhr_Course.OPERATION = operation.Insert;
if (BLL.set_Course(_obj_Smhr_Course))
{
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_Course", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
string ErrorMesage = string.Empty;
if (ValiadteQualification(out ErrorMesage))
{
SMHR_TRAINERPROFILE _obj_smhr_Trainerprofile = new SMHR_TRAINERPROFILE();
_obj_smhr_Trainerprofile.Trainer_ServiceProvider = Convert.ToInt32(rc_ServiceProvider.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_CourseCategory = Convert.ToInt32(rc_CourseCategory.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_FirstName = txt_FirstName.Text;
_obj_smhr_Trainerprofile.Trainer_MiddleName = txt_MiddleName.Text;
_obj_smhr_Trainerprofile.Trainer_LastName = txt_LastName.Text;
_obj_smhr_Trainerprofile.Trainer_Address1 = txt_Address1.Text;
_obj_smhr_Trainerprofile.Trainer_Address2 = txt_Address2.Text;
_obj_smhr_Trainerprofile.Trainer_Age = Convert.ToInt32(txt_Age.Text);
_obj_smhr_Trainerprofile.Trainer_CountryID = Convert.ToInt32(rc_Country.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_CountyID = Convert.ToInt32(rc_County.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_TownID = Convert.ToInt32(rc_Town.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_MoblieNo = Convert.ToString(txt_mobileNo.Text);
_obj_smhr_Trainerprofile.Trainer_LandlineNo = Convert.ToString(txt_LandLineNo.Text);
_obj_smhr_Trainerprofile.Trainer_EmailID = Convert.ToString(txt_Email.Text);
_obj_smhr_Trainerprofile.Trainer_DOB = txt_DOB.SelectedDate.Value;
_obj_smhr_Trainerprofile.Trainer_Status = rad_IsActive.Checked;
_obj_smhr_Trainerprofile.Trainer_Qualification = Convert.ToInt32(rc_Qualification.SelectedItem.Value);
_obj_smhr_Trainerprofile.Trainer_Institute = Convert.ToString(txt_Institute.Text);
_obj_smhr_Trainerprofile.Trainer_Percentage = Convert.ToString(txt_Percentage.Text);
_obj_smhr_Trainerprofile.Trainer_YearOfPass = Convert.ToString(txt_YeaofPass.Text);
_obj_smhr_Trainerprofile.TRAINER_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_smhr_Trainerprofile.TRAINER_CREATEDDATE = DateTime.Now;
_obj_smhr_Trainerprofile.TRAINER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Trainerprofile.TRAINER_MODIFYEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_smhr_Trainerprofile.TRAINER_MODIIFYEDDATE = DateTime.Now;
_obj_smhr_Trainerprofile.Trainer_ZipCode = Convert.ToString(txt_ZipCode.Text);
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.Offline;
_obj_CS.COURSESCHEDULE_TRAINERID = Convert.ToInt32(ld_ID.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_Trainerprofile.Trainer_TrainerProfile_ID = Convert.ToInt32(ld_ID.Text);
_obj_smhr_Trainerprofile.OPERATION = operation.Update;
if (BLL.set_TrainingProfile(_obj_smhr_Trainerprofile))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_smhr_Trainerprofile.OPERATION = operation.CountEmailID;
if (Convert.ToInt32(BLL.get_TrainingProfile(_obj_smhr_Trainerprofile).Rows[0][0]) > 0)
{
BLL.ShowMessage(this, "Email ID Already Exists.Please Enter another Email ID");
return;
}
else
{
_obj_smhr_Trainerprofile.OPERATION = operation.Insert;
if (BLL.set_TrainingProfile(_obj_smhr_Trainerprofile))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
}
default:
break;
}
LoadGrid();
Rm_CY_page.SelectedIndex = 0;
Rg_Countries.DataBind();
}
else
{
BLL.ShowMessage(this, ErrorMesage);
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "TrainerProfile", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_TRAINING_ROOM _obj_Smhr_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ROOMNAME = radRoomName.Text;
_obj_Smhr_Room.ROOMSTRENGTH = Convert.ToInt32(radRoomStrength.Text);
_obj_Smhr_Room.ROOMS_LOCATION_ID = Convert.ToInt32(radLocation.SelectedValue);
_obj_Smhr_Room.ROOM_STATUS = rad_IsActive.Checked;
_obj_Smhr_Room.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Room.CREATEDDATE = DateTime.Now;
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Room.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.Chk;
_obj_CS.COURSESCHEDULE_ROOMID = Convert.ToInt32(lblTrainingRoomsId.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_Room.OPERATION = operation.Update;
_obj_Smhr_Room.ROOMID = Convert.ToInt32(lblTrainingRoomsId.Text);
if (BLL.set_TrainingRooms(_obj_Smhr_Room))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Room.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_TrainingRooms(_obj_Smhr_Room).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Room with this Name Already Exists");
return;
}
_obj_Smhr_Room.OPERATION = operation.Insert;
if (BLL.set_TrainingRooms(_obj_Smhr_Room))
{
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_TrainingRooms", 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");
}
}
