public void LoadGrid()
{
try
{
if (Request.QueryString.HasKeys())
{
SMHR_TRAINING_REQUST _obj_smhr_training_requst = new SMHR_TRAINING_REQUST();
_obj_smhr_training_requst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_training_requst.TRAINING_RAISEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_training_requst.TRAINING_RAISEDBY = Convert.ToInt32(Request.QueryString["EMP_ID"]);
_obj_smhr_training_requst.OPERATION = operation.Select;
DataTable DT = BLL.get_TrainigRequest(_obj_smhr_training_requst);
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("'", "''"), "TrainingRequestPopup", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/*added by anusha 21/05/2015*/
private void BindBatchesDatasource()
{
try
{
SMHR_TRAINING_REQUST _obj_Smhr_TrgRqst = new SMHR_TRAINING_REQUST();
_obj_Smhr_TrgRqst.OPERATION = operation.Get;
//_obj_Smhr_TrgRqst.TRAINING_COURSEID = Convert.ToInt32(radCourse.SelectedValue);
_obj_Smhr_TrgRqst.TRAINING_APPROVEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_TrgRqst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);//YYY
DataTable DT = BLL.get_TrainigRequest(_obj_Smhr_TrgRqst);
if (DT.Rows.Count != 0)
{
RG_TrainingApproval.DataSource = DT;
// RG_TrainingApproval.DataBind();
}
else
{
DataTable DT1 = new DataTable();
RG_TrainingApproval.DataSource = DT1;
// RG_TrainingApproval.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
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");
}
}
//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"]);
// 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"));
// }
// 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 lnk_Apply_Command(object sender, CommandEventArgs e)
{
try
{
SMHR_TRAINING_REQUST _obj_Smhr_TrgRqst = new SMHR_TRAINING_REQUST();
_obj_Smhr_TrgRqst.TRAINING_REQUST_ID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_TrgRqst.OPERATION = operation.Update;
_obj_Smhr_TrgRqst.TRAINING_APPROVEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_TrgRqst.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_TrgRqst.LASTMDFDATE = DateTime.Now;
switch (((LinkButton)sender).ID.ToUpper())
{
case "LNK_APPLY":
_obj_Smhr_TrgRqst.TRAINING_ISAPPROVED = 1;
_obj_Smhr_TrgRqst.OPERATION = operation.Check;
if (string.Compare(Convert.ToString(BLL.get_TrainigRequest(_obj_Smhr_TrgRqst).Rows[0][0]), "1", true) == 0)
{
BLL.ShowMessage(this, "There is No Vacancy for this Training");
return;
}
_obj_Smhr_TrgRqst.OPERATION = operation.Update;
if (BLL.set_TrainigRequest(_obj_Smhr_TrgRqst))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "LNK_REJECT":
_obj_Smhr_TrgRqst.TRAINING_ISAPPROVED = 2;
if (BLL.set_TrainigRequest(_obj_Smhr_TrgRqst))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
BindBatches();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rc_Days_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
Btn_cancel.Visible = true;
btn_submit.Visible = true;
RG_TrainingApproval.Visible = true;
try
{
SMHR_TRAINING_REQUST _obj_Smhr_TrgRqst = new SMHR_TRAINING_REQUST();
_obj_Smhr_TrgRqst.OPERATION = operation.Select2;
_obj_Smhr_TrgRqst.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrgRqst.TRAINING_BATCHID = Convert.ToInt32(rc_CourseSchedule.SelectedValue);
_obj_Smhr_TrgRqst.TRAINING_ATTENDANCE_DAYS = Convert.ToInt32(rc_Days.SelectedValue);
DataTable DT = BLL.get_TrainigRequest(_obj_Smhr_TrgRqst);
if (DT.Rows.Count != 0)
{
RG_TrainingApproval.DataSource = DT;
}
else
{
DataTable dt1 = new DataTable();
RG_TrainingApproval.DataSource = dt1;
}
RG_TrainingApproval.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");
}
}
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");
}
}
