protected void radLocation_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (radLocation.SelectedIndex > 0)
{
SMHR_TRAINING_ROOM _obj_Smhr_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ROOMS_LOCATION_ID = Convert.ToInt32(radLocation.SelectedValue);
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.OPERATION = operation.Select2;
radTrainingRoom.DataSource = BLL.get_TrainingRooms(_obj_Smhr_Room);
radTrainingRoom.DataTextField = "ROOMS_NAME";
radTrainingRoom.DataValueField = "ROOMS_ID";
radTrainingRoom.DataBind();
radTrainingRoom.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
else
{
radTrainingRoom.Items.Clear();
radTrainingRoom.ClearSelection();
radTrainingRoom.Text = string.Empty;
}
}
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");
}
}
public void LoadGrid()
{
try
{
_obj_Smhr_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.OPERATION = operation.Select;
DataTable DT = BLL.get_TrainingRooms(_obj_Smhr_Room);
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_TrainingRooms", 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_Room = new SMHR_TRAINING_ROOM();
_obj_Smhr_Room.ROOMID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_Room.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Room.OPERATION = operation.Get;
DataTable dt = BLL.get_TrainingRooms(_obj_Smhr_Room);
if (dt.Rows.Count != 0)
{
radRoomName.Enabled = false;
lblTrainingRoomsId.Text = dt.Rows[0]["ROOMS_ID"].ToString();
radRoomName.Text = dt.Rows[0]["ROOMS_NAME"].ToString();
radRoomStrength.Text = dt.Rows[0]["ROOMS_STRENGTH"].ToString();
LoadCombos();
radLocation.SelectedIndex = radLocation.FindItemIndexByValue(dt.Rows[0]["ROOMS_LOCATIONID"].ToString());
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["ROOMS_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_TrainingRooms", 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");
}
}
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");
}
}
