protected void LoadTrainers()
{
try
{
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.OPERATION = operation.Select;
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(rcmb_ScheduleName.SelectedValue);
DataTable dttrainers = BLL.get_TrainerDetails(_obj_Smhr_Trner);
ReptFeedBack_AllTrainer.DataSource = dttrainers;
ReptFeedBack_AllTrainer.DataBind();
for (int i = 0; i < ReptFeedBack_AllTrainer.Items.Count; i++)
{
Label lblTrainerName = ReptFeedBack_AllTrainer.Items[i].FindControl("lbl_Trainer") as Label;
lblTrainerName.Visible = true;
_obj_SMHR_FEEDBACK_QUESTIONS = new SMHR_FEEDBACK_QUESTIONS();
DataTable DT1 = new DataTable();
_obj_SMHR_FEEDBACK_QUESTIONS.OPERATION = operation.TRAINER;
_obj_SMHR_FEEDBACK_QUESTIONS.FEEDBACKQUESTS_QUESTION = "";
_obj_SMHR_FEEDBACK_QUESTIONS.FEEDBACKQUESTS_STATUS = "Active";
DT1 = BLL.get_FeedbackQuestions(_obj_SMHR_FEEDBACK_QUESTIONS);
if (DT1.Rows.Count != 0)
{
Repeater repttrainer = ReptFeedBack_AllTrainer.Items[i].FindControl("ReptFeedBack_Trainer") as Repeater;
repttrainer.DataSource = DT1;
repttrainer.DataBind();
PopulateOptions3(DT1, i);
//lbl_Trainer.Visible = true;
}
}
if (ReptFeedBack_Couseller.Items.Count == 0 && ReptFeedBack_Course.Items.Count == 0 && ReptFeedBack_Admin.Items.Count == 0)
{
BLL.ShowMessage(this, "No Feedback Question Defined.");
Rm_Feedbackrespns_Page.SelectedIndex = 0;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingResponse", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// page load methods
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
SMHR_TRAINEE _obj_Smhr_TrnEE = new SMHR_TRAINEE();
Page.Validate();
if (!Page.IsPostBack)
{
#region pageload
//_obj_Smhr_Trner.Mode = 10;
//_obj_Smhr_Trner.TRAINERDETAILS_EMPLOYEEID = Convert.ToInt32(Session["EMP_ID"]);
//DataTable dt1 = BLL.get_TRAINer(_obj_Smhr_Trner);
//if (dt1.Rows.Count != 0)
//{
// _obj_Smhr_Trner.Mode = 11;
// _obj_Smhr_Trner.TRAINERDETAILS_EMPLOYEEID = Convert.ToInt32(Session["EMP_ID"]);
// //_obj_Smhr_Trner.TRAINERDETAILS_EMPLOYEEID = 62;
// DataTable dttrg = BLL.get_TRAINer(_obj_Smhr_Trner);
// if (dttrg.Rows.Count != 0)
// {
// Rcmb_Trg.DataSource = dttrg;
// Rcmb_Trg.DataValueField = "TR_ID";
// Rcmb_Trg.DataTextField = "TR_TITLE";
// Rcmb_Trg.DataBind();
// Rcmb_Trg.Items.Insert(0, new RadComboBoxItem("Select"));
// Rg_SaveTrgFeedback.Visible = false;
// btn_save_trgfeedbacques.Visible = false;
// }
// else
// {
// DataTable dt22 = new DataTable();
// Rcmb_Trg.DataSource = dt22;
// Rcmb_Trg.DataBind();
// Rcmb_Trg.Items.Insert(0, new RadComboBoxItem("Select"));
// Rg_SaveTrgFeedback.Visible = false;
// btn_save_trgfeedbacques.Visible = false;
// }
//}
//else
//{
// _obj_Smhr_TrnEE.Mode = 7;
// _obj_Smhr_TrnEE.TRAINEE_EMPID = Convert.ToInt32(Session["EMP_ID"]);
// DataTable dttrg1 = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
// if (dttrg1.Rows.Count != 0)
// {
// Rcmb_Trg.DataSource = dttrg1;
// Rcmb_Trg.DataValueField = "TR_ID";
// Rcmb_Trg.DataTextField = "TR_TITLE";
// Rcmb_Trg.DataBind();
// Rcmb_Trg.Items.Insert(0, new RadComboBoxItem("Select"));
// Rg_SaveTrgFeedback.Visible = false;
// btn_save_trgfeedbacques.Visible = false;
// }
// else
// {
// DataTable dt22 = new DataTable();
// Rcmb_Trg.DataSource = dt22;
// Rcmb_Trg.DataBind();
// Rcmb_Trg.Items.Insert(0, new RadComboBoxItem("Select"));
// Rg_SaveTrgFeedback.Visible = false;
// btn_save_trgfeedbacques.Visible = false;
// }
//}
Session.Remove("WRITEFACILITY");
SMHR_LOGININFO _obj_Smhr_LoginInfo = new SMHR_LOGININFO();
_obj_Smhr_LoginInfo.OPERATION = operation.Empty1;
_obj_Smhr_LoginInfo.LOGIN_USERNAME = Convert.ToString(Session["USERNAME"]).Trim();
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_LoginInfo.LOGIN_PASS_CODE = Convert.ToString("FEEDBACK");
DataTable dtformdtls = BLL.get_LoginInfo(_obj_Smhr_LoginInfo);
if (dtformdtls.Rows.Count != 0)
{
if ((Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_READ"]) == true) && (Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_WRITE"]) == true))
{
Session["WRITEFACILITY"] = 1;//WHICH MEANS READ AND WRITE
}
else if ((Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_READ"]) == true) && (Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_WRITE"]) == false))
{
Session["WRITEFACILITY"] = 2;//WHICH MEANS READ NO WRITE
}
else if ((Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_READ"]) == false) && (Convert.ToBoolean(dtformdtls.Rows[0]["TYPSEC_WRITE"]) == false))
{
Session["WRITEFACILITY"] = 3;//WHICH MEANS NO READ AND NO WRITE
}
}
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
lbl_starttime.Visible = false;
rtp_starttime.Visible = false;
lbl_endtime.Visible = false;
rtp_endtime.Visible = false;
Lbl_Trg.Visible = false;
Rcmb_Trg.Visible = false;
lbl_Employee.Visible = false;
Rcm_Employee.Visible = false;
expertise_id.Visible = false;
LBL_DATE.Visible = true;
rdtp_strtdate.Visible = true;
CHGEXPERTID.Visible = false;
Rg_SaveTrgFeedback.Visible = false;
btn_save_trgfeedbacques.Visible = false;
}
else
{
lbl_starttime.Visible = false;
rtp_starttime.Visible = false;
lbl_endtime.Visible = false;
rtp_endtime.Visible = false;
Lbl_Trg.Visible = false;
Rcmb_Trg.Visible = false;
lbl_Employee.Visible = false;
Rcm_Employee.Visible = false;
expertise_id.Visible = false;
LBL_DATE.Visible = true;
rdtp_strtdate.Visible = true;
CHGEXPERTID.Visible = false;
Rg_SaveTrgFeedback.Visible = false;
btn_save_trgfeedbacques.Visible = false;
}
#endregion
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_SaveTrgfeedbackquestion", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// when trg changed based if trainee trainer will come for trainer trainee will come
/// </summary>
/// <param name="o"></param>
/// <param name="e"></param>
protected void Rcmb_Trg_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (Rcmb_Trg.SelectedItem.Text != "Select")
{
SMHR_TRAINEE _obj_Smhr_TrnEE = new SMHR_TRAINEE();
_obj_Smhr_TrnEE.Mode = 14;//YYY
_obj_Smhr_TrnEE.TRAINEE_EMPID = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtemp15 = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
//if employee is trainee then
if (dtemp15.Rows.Count != 0)
{
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
_obj_Smhr_Trner.Mode = 15;//YYY
_obj_Smhr_Trner.TRAINERDETAILS_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
//if trg is internal trg then
DataTable dttrgexist = BLL.get_TRAINer(_obj_Smhr_Trner);
if (Convert.ToInt32(dttrgexist.Rows[0]["emp_id"]) != 0)
{
Rcm_Employee.DataSource = dttrgexist;
Rcm_Employee.DataValueField = "emp_id";
Rcm_Employee.DataTextField = "EMPLOYEE_NAME";
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
_obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
_obj_Smhr_Trner.Mode = 16;//YYY
_obj_Smhr_Trner.TRAINERDETAILS_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
//if trg of external trg
DataTable dttrgexist22 = BLL.get_TRAINer(_obj_Smhr_Trner);
if (dttrgexist22.Rows[0]["TRAINERDETAILS_EMPLOYEENAME"] != string.Empty)
{
Rcm_Employee.DataSource = dttrgexist22;
Rcm_Employee.DataValueField = "TRAINERDETAILS_EMPLOYEENAME";
Rcm_Employee.DataTextField = "TRAINERDETAILS_EMPLOYEENAME";
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{//if trg of external trainer
Rcm_Employee.DataSource = dttrgexist22;
Rcm_Employee.DataValueField = "TRAINERDETAILS_CONTACTPERSON";
Rcm_Employee.DataTextField = "TRAINERDETAILS_CONTACTPERSON";
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
lbl_Employee.Text = "Trainer :";
}
else
{//loads trainee
SMHR_TRAININGREQUEST _obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 21;
_obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT455 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
//
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
_obj_Smhr_Trner.Mode = 18;//YYY
_obj_Smhr_Trner.TRAINERDETAILS_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dttrainer = BLL.get_TRAINer(_obj_Smhr_Trner);
//if (Convert.ToInt32(DT455.Rows[0]["login_emp_id"]) == Convert.ToInt32(Session["EMP_ID"]) )
//{//if hr logs in
if (Convert.ToInt32(Session["EMP_ID"]) != 0)
{
_obj_Smhr_TrnEE = new SMHR_TRAINEE();
_obj_Smhr_TrnEE.Mode = 5;
_obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrnEE.TRAINEE_TR_ID = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
DataTable dtemp1 = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
Rcm_Employee.DataSource = dtemp1;
Rcm_Employee.DataValueField = "TRAINEE_EMPID";
Rcm_Employee.DataTextField = "EMPLOYEE_NAME";
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
lbl_Employee.Text = "Trainee :";
}
else if (dttrainer.Rows.Count != 0)
{//if internal trainer logs in
if (Convert.ToInt32(dttrainer.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]) == Convert.ToInt32(Session["EMP_ID"]))
{
_obj_Smhr_TrnEE = new SMHR_TRAINEE();
_obj_Smhr_TrnEE.Mode = 5;
_obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrnEE.TRAINEE_TR_ID = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
DataTable dtemp1 = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
Rcm_Employee.DataSource = dtemp1;
Rcm_Employee.DataValueField = "TRAINEE_EMPID";
Rcm_Employee.DataTextField = "EMPLOYEE_NAME";
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
lbl_Employee.Text = "Trainee :";
}
}
else
{
BLL.ShowMessage(this, "No Trainee Under This User");
DataTable dt5 = new DataTable();
Rcm_Employee.DataSource = dt5;
Rcm_Employee.DataBind();
Rcm_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
lbl_starttime.Visible = true;
rtp_starttime.Visible = true;
lbl_endtime.Visible = true;
rtp_endtime.Visible = true;
Lbl_Trg.Visible = true;
Rcmb_Trg.Visible = true;
lbl_Employee.Visible = true;
Rcm_Employee.Visible = true;
expertise_id.Visible = false;
CHGEXPERTID.Visible = false;
// SMHR_ASSIGNFEEDBACK_EMPLOYEE _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
// _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 5;
// _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
// _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDBY = Convert.ToInt32(Rcmb_Trg.SelectedItem.Value);
// //i am passing trg and employee to get feedback_id
// DataTable dtfeedbackid = BLL.get__SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
// if (dtfeedbackid.Rows.Count != 0)
// {
// SMHR_TRGFEEDBACKQUESDTLS _obj_Smhr_TRGFEEDBACKQUESDTLS = new SMHR_TRGFEEDBACKQUESDTLS();
// _obj_Smhr_TRGFEEDBACKQUESDTLS.Mode = 4;
// _obj_Smhr_TRGFEEDBACKQUESDTLS.TRFDBDTL_FDBID = Convert.ToInt32(dtfeedbackid.Rows[0]["FEEDBACK_ID"]);
// DataTable dtques = BLL.get_TRGFEEDBAKQUESTDTLS(_obj_Smhr_TRGFEEDBACKQUESDTLS);
// if (dtques.Rows.Count != 0)
// {
// Rg_SaveTrgFeedback.DataSource = dtques;
// Rg_SaveTrgFeedback.DataBind();
// Rg_SaveTrgFeedback.Visible = true;
// btn_save_trgfeedbacques.Visible = true;
// }
// else
// {
// DataTable dt5 = new DataTable();
// Rg_SaveTrgFeedback.DataSource = dt5;
// Rg_SaveTrgFeedback.DataBind();
// Rg_SaveTrgFeedback.Visible = true;
// btn_save_trgfeedbacques.Visible = false;
// return;
// }
// }
// else
// {
// DataTable dt4 = new DataTable();
// Rg_SaveTrgFeedback.DataSource = dt4;
// Rg_SaveTrgFeedback.DataBind();
// Rg_SaveTrgFeedback.Visible = true;
// btn_save_trgfeedbacques.Visible = false;
// }
//}
//else
//{
// BLL.ShowMessage(this, "Please Select Training");
// DataTable dt9 = new DataTable();
// Rg_SaveTrgFeedback.DataSource = dt9;
// Rg_SaveTrgFeedback.DataBind();
// Rg_SaveTrgFeedback.Visible = true;
// btn_save_trgfeedbacques.Visible = false;
// return;
//}
}
else
{
BLL.ShowMessage(this, "Please Select Training");
lbl_starttime.Visible = true;
rtp_starttime.Visible = true;
lbl_endtime.Visible = true;
rtp_endtime.Visible = true;
Lbl_Trg.Visible = true;
Rcmb_Trg.Visible = true;
lbl_Employee.Visible = false;
Rcm_Employee.Visible = false;
expertise_id.Visible = false;
CHGEXPERTID.Visible = false;
Rg_SaveTrgFeedback.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_SaveTrgfeedbackquestion", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// when trg changed
/// </summary>
/// <param name="o"></param>
/// <param name="e"></param>
protected void rcmb_Attdtls_TRG_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_Attdtls_Training.SelectedItem.Text != "Select")
{
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
//_obj_Smhr_Trner.Mode = 17;
//_obj_Smhr_Trner.TRAINERDETAILS_EMPLOYEEID = Convert.ToInt32(Session["EMP_ID"]);
//_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(rcmb_Attdtls_Training.SelectedItem.Value);
//DataTable dt1 = BLL.get_TRAINer(_obj_Smhr_Trner);
//if (dt1.Rows.Count != 0)
//{ BLL.ShowMessage(this, "Attendace Details have been Submitted");
// lbl_AttDtls_AttDt.Visible = true;
// rdtp_AttDtls_AttDt.Visible = true;
//}
//else
//{
// BLL.ShowMessage(this, "Employee Not Under This Training");
// lbl_AttDtls_AttDt.Visible = false;
// rdtp_AttDtls_AttDt.Visible = false;
//}
//SMHR_TRAININGREQUEST _obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
// _obj_Smhr_TrgRqst.Mode = 21;
// DataTable dthrid = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
// if (dthrid.Rows.Count != 0)
// {
// if (dthrid.Rows[0]["login_emp_id"] == Session["EMP_ID"])
// {
// _obj_Smhr_Trner.Mode = 18;
// _obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(rcmb_Attdtls_Training.SelectedItem.Value);
// DataTable dt15 = BLL.get_TRAINer(_obj_Smhr_Trner);
// if (dt15.Rows.Count != 0)
// {
// lbl_AttDtls_AttDt.Visible = true;
// rdtp_AttDtls_AttDt.Visible = true;
// }
// }
// }
lbl_AttDtls_AttDt.Visible = true;
rdtp_AttDtls_AttDt.Visible = true;
}
else
{
lbl_AttDtls_AttDt.Visible = false;
rdtp_AttDtls_AttDt.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_trainingattendancedtls", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_assign_Click(object sender, EventArgs e)
{
try
{
//assign feedback to trainer of that trg
if (rcmb_CourseSchedule.SelectedItem.Text == "Trainer")
{
SMHR_ASSIGNFEEDBACK_EMPLOYEE _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_AssessmentName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_CC.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_CourseName.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_CourseSchedule.SelectedItem.Text);
DataTable dt5 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.Mode = 5;
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(rcmb_CourseName.SelectedItem.Value);
DataTable dt1 = BLL.get_TRAINer(_obj_Smhr_Trner);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 2;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
//if trg is external then inplace of trainer we are passing hr employeeid
if (dt1.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(dt1.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]);
}
else
{//IF TRAINER EXTERNAL WE HAVE TO GIVE HR ID
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 21;
_obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT45 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (DT45.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
}
DataTable dt2 = BLL.get__SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (dt2.Rows.Count != 0)
{
BLL.ShowMessage(this, "Tarining Already Assigned To Employee");
return;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 3;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
if (dt1.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(dt1.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]);
}
else
{
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 21;
_obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT455 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (DT455.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
}
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDDATE = DateTime.Now;
bool status = BLL.set_SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (status == true)
{
BLL.ShowMessage(this, "Feedback Assigned Successfully");
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
return;
}
}
}
else if (rcmb_CourseSchedule.SelectedItem.Text == "Trainee")
{
SMHR_ASSIGNFEEDBACK_EMPLOYEE _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 6;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(lbl_id.Text);
DataTable dttrnee = BLL.get__SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (dttrnee.Rows.Count != 0)
{
BLL.ShowMessage(this, "Tarining Already Assigned To Trainee");
return;
}
else
{
SMHR_TRAINEE _obj_Smhr_TrnEE = new SMHR_TRAINEE();
_obj_Smhr_TrnEE.Mode = 5;
_obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrnEE.TRAINEE_TR_ID = Convert.ToInt32(rcmb_CourseName.SelectedItem.Value);
DataTable dtemp = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
// for (int i = 0; i <= dtemp.Rows.Count ; i++)
// {
foreach (DataRow item in dtemp.Rows)
{
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_CC.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_CourseName.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_CourseSchedule.SelectedItem.Text);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_AssessmentName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt5 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 3;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(item["TRAINEE_EMPID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDDATE = DateTime.Now;
bool status = BLL.set_SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (status == true)
{
//BLL.ShowMessage(this, "Feedback Assigned Successfully");
//LoadGrid();
//Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
}
//BLL.ShowMessage(this, "Feedback Assigned Successfully");
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 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");
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Approve_Click(object sender, EventArgs e)
{
try
{
CheckBox chkBox = new CheckBox();
Label lblID = new Label();
string str = "";
bool status = false;
for (int index = 0; index <= RG_TrainingApproval.Items.Count - 1; index++)
{
chkBox = RG_TrainingApproval.Items[index].FindControl("chk_Choose") as CheckBox;
lblID = RG_TrainingApproval.Items[index].FindControl("lbltrgID") as Label;
if (chkBox.Checked)
{
if (str == "")
{
str = "" + lblID.Text + "";
}
else
{
str = str + "," + lblID.Text + "";
}
SMHR_TRAININGREQUEST _obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 9;
_obj_Smhr_TrgRqst.TR_ID = Convert.ToInt32(lblID.Text);
_obj_Smhr_TrgRqst.TR_APPROVEDBY = Convert.ToInt32(Session["emp_id"]);
_obj_Smhr_TrgRqst.TR_STATUS = "Approved";
status = BLL.set_TrgRqst(_obj_Smhr_TrgRqst);
}
}
if (string.IsNullOrEmpty(str))
{
BLL.ShowMessage(this, "Please Select Training");
return;
}
if (status == true)
{
SMHR_TRAININGREQUEST _obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.TR_ID = Convert.ToInt32(lblID.Text);
_obj_Smhr_TrgRqst.Mode = 13;
DataTable dt_ger_tr = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (dt_ger_tr.Rows.Count != 0)
{
for (int i = 0; i < dt_ger_tr.Rows.Count; i++)
{
if (dt_ger_tr.Rows[i]["LOGIN_EMAILID"] != System.DBNull.Value)
{
Dal.ExecuteNonQuery("EXEC USP_SEND_EMAIL_TRAINING @LOGIN_EMAILID='" + Convert.ToString(dt_ger_tr.Rows[i]["LOGIN_EMAILID"]) + "',@RAISEDBY='" + Convert.ToString(dt_ger_tr.Rows[i]["RAISEDBY"]) + "',@APPROVEDBY='" + Convert.ToString(dt_ger_tr.Rows[i]["APPROVEDBY"]) + "',@TR_TITLE='" + Convert.ToString(dt_ger_tr.Rows[i]["TR_TITLE"]) + "'");
}
}
}
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(lblID.Text);
_obj_Smhr_Trner.Mode = 18;
_obj_Smhr_Trner.TRAINERDETAILS_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dttrgexist = BLL.get_TRAINer(_obj_Smhr_Trner);
if (dttrgexist.Rows.Count != 0)
{
if (Convert.ToInt32(dttrgexist.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]) != 0)
{
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.TR_ID = Convert.ToInt32(lblID.Text);
_obj_Smhr_TrgRqst.Mode = 14;
DataTable dt_ger_tr1 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (dt_ger_tr1.Rows.Count != 0)
{
for (int i = 0; i < dt_ger_tr1.Rows.Count; i++)
{
if (dt_ger_tr1.Rows[i]["LOGIN_EMAILID"] != System.DBNull.Value)
{
Dal.ExecuteNonQuery(" exec USP_SEND_EMAIL_TRAINEE @LOGIN_EMAILID = '" + Convert.ToString(dt_ger_tr1.Rows[i]["LOGIN_EMAILID"]) + "',@EMPLOYEE ='" + Convert.ToString(dt_ger_tr1.Rows[i]["EMPLOYEE"]) + "',@TR_TITLE ='" + Convert.ToString(dt_ger_tr1.Rows[i]["TR_TITLE"]) + "',@TS_STARTDATE ='" + Convert.ToString(dt_ger_tr1.Rows[i]["TS_STARTDATE"]) + "',@TS_SESSIONS='" + Convert.ToString(dt_ger_tr1.Rows[i]["TS_SESSIONS"]) + "',@TS_STARTTIME ='" + Convert.ToString(dt_ger_tr1.Rows[i]["TS_STARTTIME"]) + "',@TS_ENDTIME ='" + Convert.ToString(dt_ger_tr1.Rows[i]["TS_ENDTIME"]) + "'");
}
}
}
}
else
{
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.TR_ID = Convert.ToInt32(lblID.Text);
_obj_Smhr_TrgRqst.Mode = 22;
DataTable dt_ger_tr2 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (dt_ger_tr2.Rows.Count != 0)
{
for (int i = 0; i < dt_ger_tr2.Rows.Count; i++)
{
if (dt_ger_tr2.Rows[i]["LOGIN_EMAILID"] != System.DBNull.Value)
{
Dal.ExecuteNonQuery(" exec USP_SEND_EMAIL_TRAINEE @LOGIN_EMAILID = '" + Convert.ToString(dt_ger_tr2.Rows[i]["LOGIN_EMAILID"]) + "',@EMPLOYEE ='" + Convert.ToString(dt_ger_tr2.Rows[i]["EMPLOYEE"]) + "',@TR_TITLE ='" + Convert.ToString(dt_ger_tr2.Rows[i]["TR_TITLE"]) + "',@TS_STARTDATE ='" + Convert.ToString(dt_ger_tr2.Rows[i]["TS_STARTDATE"]) + "',@TS_SESSIONS='" + Convert.ToString(dt_ger_tr2.Rows[i]["TS_SESSIONS"]) + "',@TS_STARTTIME ='" + Convert.ToString(dt_ger_tr2.Rows[i]["TS_STARTTIME"]) + "',@TS_ENDTIME ='" + Convert.ToString(dt_ger_tr2.Rows[i]["TS_ENDTIME"]) + "'");
}
}
}
}
}
BLL.ShowMessage(this, "Selected Trainings Approved");
BLL.ShowMessage(this, "Notification Send");
LoadData();
RG_TrainingApproval.DataBind();
//RG_ExpenseApproval.Visible = false;
return;
}
}
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 btn_Save_Click(object sender, EventArgs e)
{
try
{
if (rlb_Quetions.Items.Count != 0)
{
SMHR_TRAININGFEEDBACK _obj_SMHR_TRAININGFEEDBACK_RESPONSE = new SMHR_TRAININGFEEDBACK();
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE6;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt93 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
if (dt93.Rows.Count != 0)
{
BLL.ShowMessage(this, "Already Feedback Assigned For Training");
RP_trgfeedback_VIEWDETAILS.Visible = false;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = true;
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
}
else
{
bool res2 = false;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_DESCRIPTION = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackDescription.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_STATUS = 0;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.CREATEDDATE = DateTime.Now;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BACKDATE = Convert.ToInt32(rnt_bakdateddate.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.Insert;
res2 = BLL.set_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
Label lblApp = new Label();
for (int index = 0; index < RG_FeedBack.Items.Count; index++)
{
lblApp = RG_FeedBack.Items[index].FindControl("lblAppID") as Label;
SMHR_TRGFEEDBACKQUESDTLS _obj_Smhr_TRGFEEDBACKQUESDTLS = new SMHR_TRGFEEDBACKQUESDTLS();
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedValue);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedValue);
DataTable dt5 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
_obj_Smhr_TRGFEEDBACKQUESDTLS.TRFDBDTL_FDBID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
_obj_Smhr_TRGFEEDBACKQUESDTLS.TRFDBDTL_QUESTIONSID = Convert.ToInt32(lblApp.Text);
_obj_Smhr_TRGFEEDBACKQUESDTLS.Mode = 3;
_obj_Smhr_TRGFEEDBACKQUESDTLS.TRFDBDTL_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_TRGFEEDBACKQUESDTLS.TRFDBDTL_CREATEDDATE = DateTime.Now;
bool status = BLL.set_TRGFEEDBAKQUESTDTLS(_obj_Smhr_TRGFEEDBACKQUESDTLS);
Session["TR_ID"] = Convert.ToInt32(rcmb_TRName.SelectedValue);
Session["CATEGORY"] = Convert.ToString(rcmb_Type.SelectedValue);
Session["BU_ID"] = Convert.ToInt32(rcmb_BU.SelectedValue);
int a = Convert.ToInt32(Session["TR_ID"]);
//if (Convert.ToString(BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE).Rows[0]["Count"]) != "0")
////{
//// BLL.ShowMessage(this, "Trainig FeedBack Already Saved Successfully");
//// return;
////}
////else
////{
// //_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.Insert;
// //res2 = BLL.set_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
////}
}
if (res2 == true)
{
BLL.ShowMessage(this, "Training FeedBack Saved Successfully");
rlb_Quetions.Enabled = false;
btn_Preview.Visible = true;
//btn_Finalize.Visible = true;
btn_Save.Visible = false;
rcmb_Type.Enabled = false;
rcmb_BU.Enabled = false;
rcmb_TRName.Enabled = false;
rtxt_FeedbackDescription.Text = string.Empty;
rtxt_FeedbackName.Enabled = false;
RP_trgfeedback_VIEWDETAILS.Visible = false;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = true;
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
//assign feedback to trainer of that trg
if (rcmb_Type.SelectedItem.Text == "Trainer")
{
SMHR_ASSIGNFEEDBACK_EMPLOYEE _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedItem.Text);
DataTable dt5 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
SMHR_TRAINER _obj_Smhr_Trner = new SMHR_TRAINER();
_obj_Smhr_Trner.Mode = 5;
_obj_Smhr_Trner.TRAINERDETAILS_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedItem.Value);
DataTable dt1 = BLL.get_TRAINer(_obj_Smhr_Trner);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 2;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
//if trg is external then inplace of trainer we are passing hr employeeid
if (dt1.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(dt1.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]);
}
else
{//IF TRAINER EXTERNAL WE HAVE TO GIVE HR ID
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 21;
_obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT45 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (DT45.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
}
DataTable dt2 = BLL.get__SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (dt2.Rows.Count != 0)
{
BLL.ShowMessage(this, "Tarining Already Assigned To Employee");
return;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 3;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
if (dt1.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(dt1.Rows[0]["TRAINERDETAILS_EMPLOYEEID"]);
}
else
{
_obj_Smhr_TrgRqst = new SMHR_TRAININGREQUEST();
_obj_Smhr_TrgRqst.Mode = 21;
_obj_Smhr_TrgRqst.TR_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT455 = BLL.get_TrgRqst(_obj_Smhr_TrgRqst);
if (DT455.Rows.Count != 0)
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
else
{
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = 0;
}
}
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDDATE = DateTime.Now;
bool status = BLL.set_SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (status == true)
{
BLL.ShowMessage(this, "Feedback Assigned Successfully");
RP_trgfeedback_VIEWDETAILS.Visible = false;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = true;
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
}
}
}
else if (rcmb_Type.SelectedItem.Text == "Trainee")
{
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedItem.Text);
DataTable dt55 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
SMHR_ASSIGNFEEDBACK_EMPLOYEE _obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 6;
//_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(lbl_id.Text);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt55.Rows[0]["FEEDBACK_ID"]);
DataTable dttrnee = BLL.get__SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (dttrnee.Rows.Count != 0)
{
BLL.ShowMessage(this, "Training Already Assigned To Trainee");
}
else
{
SMHR_TRAINEE _obj_Smhr_TrnEE = new SMHR_TRAINEE();
_obj_Smhr_TrnEE.Mode = 5;
_obj_Smhr_TrnEE.TRAINEE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_TrnEE.TRAINEE_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedItem.Value);
DataTable dtemp = BLL.get_TRAINEE(_obj_Smhr_TrnEE);
// for (int i = 0; i <= dtemp.Rows.Count ; i++)
// {
foreach (DataRow item in dtemp.Rows)
{
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.OPERATION = operation.MODE1;
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_BU_ID = Convert.ToInt32(rcmb_BU.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_TR_ID = Convert.ToInt32(rcmb_TRName.SelectedItem.Value);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_CATEGORY = Convert.ToString(rcmb_Type.SelectedItem.Text);
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_NAME = BLL.ReplaceQuote(Convert.ToString(rtxt_FeedbackName.Text));
_obj_SMHR_TRAININGFEEDBACK_RESPONSE.FEEDBACK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt5 = BLL.get_FeedbackResponse(_obj_SMHR_TRAININGFEEDBACK_RESPONSE);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE = new SMHR_ASSIGNFEEDBACK_EMPLOYEE();
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.Mode = 3;
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGNFEED_FEEBAK_ID = Convert.ToInt32(dt5.Rows[0]["FEEDBACK_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_EMP_ID = Convert.ToInt32(item["TRAINEE_EMPID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE.ASSIGN_CREATEDDATE = DateTime.Now;
bool status = BLL.set_SMHR_ASSIGNFEEDBACK_EMPLOYEE(_obj_SMHR_ASSIGNFEEDBACK_EMPLOYEE);
if (status == true)
{
//LoadGrid();
//Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
}
//BLL.ShowMessage(this, "Feedback Assigned Successfully");
BLL.ShowMessage(this, "Feedback Assigned Successfully");
RP_trgfeedback_VIEWDETAILS.Visible = false;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = true;
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
LoadGrid();
Rg_TrgFeedback.DataBind();
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
}
}
}
return;
}
else
{
BLL.ShowMessage(this, "Please Check Feedback Question");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Check Feedback Question");
return;
}
}
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");
}
}
