protected void lnk_Apply_Command(object sender, CommandEventArgs e)
{
try
{
SMHR_TRAINING_REQUST _obj_Smhr_TrainigRequest = new SMHR_TRAINING_REQUST();
_obj_Smhr_TrainigRequest.TRAINING_BATCHID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_TrainigRequest.TRAINING_RAISEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_TrainigRequest.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_TrainigRequest.CREATEDDATE = DateTime.Now;
_obj_Smhr_TrainigRequest.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrainigRequest.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_TrainigRequest.LASTMDFDATE = DateTime.Now;
_obj_Smhr_TrainigRequest.OPERATION = operation.Insert;
if (BLL.set_TrainigRequest(_obj_Smhr_TrainigRequest))
{
BLL.ShowMessage(this, "Information Saved Successfully");
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
Rg_Course.DataBind();
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
}
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");
}
}
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
{
if (((Button)sender).ID.ToUpper() == "BTN_UPDATE")
{
if (Convert.ToString(rad_IsActive.Checked) == "True")
{
if (fileupload_upload.FileName == "")
{
BLL.ShowMessage(this, "Please Select a File to Upload");
return;
}
}
}
SMHR_TRAINING_OFFLINEASSESSMENTS _obj_SMHR_Offlineassesments = new SMHR_TRAINING_OFFLINEASSESSMENTS();
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSEID = Convert.ToInt32(rcmb_CC.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSESCHEDULEID = Convert.ToInt32(rfc_rcmb_CS.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_NAME = rtxt_AssessmentName.Text;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_UPLOADEDDOC = fileupload_upload.FileName;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_CREATEDDATE = DateTime.Now;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_MODYFIEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_MODYFIEDDATE = DateTime.Now;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_STATUS = rad_IsActive.Checked;
if (fileupload_upload.HasFile)
{
string pdfName = rtxt_AssessmentName.Text + "_" + Guid.NewGuid().ToString() + "_FBIO" + fileupload_upload.FileName;
string strPath = "~/EmpUploads/" + pdfName;
fileupload_upload.PostedFile.SaveAs(Server.MapPath("~/EmpUploads/") + pdfName);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_UPLOADEDDOC = strPath;
}
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ID = Convert.ToInt32(lbl_OfflineassementId.Text);
_obj_SMHR_Offlineassesments.OPERATION = operation.Check;
_obj_SMHR_Offlineassesments.OPERATION = operation.Update;
if (BLL.set_OfflineAssessment(_obj_SMHR_Offlineassesments))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_SMHR_Offlineassesments.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_OfflineAssessment(_obj_SMHR_Offlineassesments).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Assessment Name with this Name Already Exists");
return;
}
_obj_SMHR_Offlineassesments.OPERATION = operation.Insert;
if (BLL.set_OfflineAssessment(_obj_SMHR_Offlineassesments))
{
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_offline Assessments", 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
{
SMHR_CHAPTERS _obj_Smhr_Chapter = new SMHR_CHAPTERS();
_obj_Smhr_Chapter.CHAPTER_NAME = rtxt_ChapterName.Text;
_obj_Smhr_Chapter.CHAPTER_DESCRIPTION = rtxt_ChapterDesc.Text;
_obj_Smhr_Chapter.CHAPTER_COURSE_ID = Convert.ToInt32(rcmb_CN.SelectedValue);
_obj_Smhr_Chapter.CHARPTER_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Chapter.CHAPTER_STATUS = rad_IsActive.Checked;
_obj_Smhr_Chapter.CHAPTER_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Chapter.CHAPTER_CREATEDDATE = DateTime.Now;
_obj_Smhr_Chapter.CHARPTER_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Chapter.CHAPTER_LASTMDFDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Chapter.CHAPTER_LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Chapter.CHAPTER_ID = Convert.ToInt32(lbl_ChapterId.Text);
_obj_Smhr_Chapter.OPERATION = operation.Update;
if (Convert.ToBoolean(rad_IsActive.Checked) == false)
{
//SMHR_COURSESCHEDULE _obj_CourseSchedule = new SMHR_COURSESCHEDULE();
//_obj_CourseSchedule.OPERATION = operation.Check2;
//_obj_CourseSchedule.COURSESCHEDULEID = Convert.ToInt32(lblCourseScheduleID.Text);
SMHR_TRAINING_ONLINEASSESSMENT _obj_Online = new SMHR_TRAINING_ONLINEASSESSMENT();
_obj_Online.OPERATION = operation.Check2;
_obj_Online.TRAINING_ASSESSMENT_CHAPTER_ID = Convert.ToInt32(lbl_ChapterId.Text);
DataTable dt = BLL.get_OnlineAssessment(_obj_Online);
if (Convert.ToString(dt.Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Cannot make inactive");
rad_IsActive.Checked = true;
return;
}
}
if (BLL.set_Chapter(_obj_Smhr_Chapter))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Chapter.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Chapter(_obj_Smhr_Chapter).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Chapter with this Name Already Exists");
return;
}
_obj_Smhr_Chapter.OPERATION = operation.Insert;
if (BLL.set_Chapter(_obj_Smhr_Chapter))
{
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_Chapters", 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
{
if ((rlb_skills.Items.Count != 0))
{
Label Label1 = new Label();
StringBuilder sb = new StringBuilder();
IList <RadListBoxItem> collection = rlb_skills.CheckedItems;
foreach (RadListBoxItem item in collection)
{
if (sb.Length == 0)
{
sb.Append(item.Value);
}
else
{
sb.Append("," + item.Value);
}
}
Label1.Text = sb.ToString();
_obj_Smhr_Course = new SMHR_COURSE();
if (Label1.Text == "")
{
_obj_Smhr_Course.COURSE_SKILL_WID = Convert.ToString(0);
}
else
{
_obj_Smhr_Course.COURSE_SKILL_WID = Convert.ToString(Label1.Text);
}
_obj_Smhr_Course.COURSE_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value);
_obj_Smhr_Course.COURSE_NAME = BLL.ReplaceQuote(rtxt_CourseName.Text.ToUpper());
_obj_Smhr_Course.COURSE_DESC = BLL.ReplaceQuote(rtxt_CourseDesc.Text);
_obj_Smhr_Course.COURSE_CATEGORYID = rcmb_CC.SelectedItem.Value;
_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;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Course.COURSE_ID = Convert.ToInt32(lbl_CourseId.Text);
_obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Course.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Course(_obj_Smhr_Course).Rows[0]["Count"]) != "1")
{
BLL.ShowMessage(this, "Course with this Name Already Exists");
return;
}
_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;
_obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
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();
}
else
{
BLL.ShowMessage(this, "Select Skills");
return;
}
}
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
{
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");
}
}
