/// <summary>
///In This Data Binding From Database To Datatable Binding to Radgrid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void LoadGrid()
{
try
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 1;
_obj_Pms_Task.TASK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = Pms_Bll.get_Task(_obj_Pms_Task);
if (dt.Rows.Count != 0)
{
Rg_Task.DataSource = dt;
Rg_Task.DataBind();
}
else
{
DataTable dt1 = new DataTable();
Rg_Task.DataSource = dt1;
Rg_Task.DataBind();
}
}
catch (Exception ex)
{
//Pms_Bll.ShowMessage(this, ex.Message.ToString());
//return;
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PmsTask", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
///IN THIS BASED ON Task_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void lnk_edit_command(object sender, CommandEventArgs e)
{
try
{
clearControls();
btn_Save.Text = "Update";
LoadBusinessUnit();
LoadGoal();
rcmb_BusinessUnitType.SelectedIndex = -1;
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 2;
_obj_Pms_Task.TASK_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable DT = Pms_Bll.get_Task(_obj_Pms_Task);
lbl_Task_Id.Text = Convert.ToString(DT.Rows[0]["TASK_ID"]);
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 6;
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(Convert.ToString(DT.Rows[0]["EMP_ID"]));
DataTable dt_Bus = Pms_Bll.get_Task(_obj_Pms_Task);
LoadBusinessUnit();
rcmb_BusinessUnitType.SelectedIndex = rcmb_BusinessUnitType.FindItemIndexByValue(Convert.ToString(dt_Bus.Rows[0]["EMP_BUSINESSUNIT_ID"]));
LoadEmployees();
rcmb_EmployeeType.SelectedIndex = rcmb_EmployeeType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["EMP_ID"]));
rtxt_TaskName.Text = Convert.ToString(DT.Rows[0]["TASK_NAME"]);
rtxt_TaskDescription.Text = Convert.ToString(DT.Rows[0]["TASK_DESCRIPTION"]);
rdtp_DATE.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TASK_DATE"]);
rcmb_GoalType.SelectedIndex = rcmb_GoalType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TASK_GOAL"]));
btn_Save.Visible = true;
Rm_TASK_PAGE.SelectedIndex = 1;
rcmb_BusinessUnitType.Enabled = false;
rcmb_EmployeeType.Enabled = false;
lbl_BusinessUnitName.Visible = false;
rcmb_BusinessUnitType.Visible = false;
rtxt_TaskName.Enabled = false;
rcmb_GoalType.Enabled = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Task", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// Here DataNeedSource Is Used To Bind Data To Grid
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Rg_Task_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 1;
DataTable dt = Pms_Bll.get_Task(_obj_Pms_Task);
if (dt.Rows.Count != 0)
{
Rg_Task.DataSource = dt;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Task", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// WHILE INSERTING THERE IS NO NEED TO ADD LAST MDF BY,LAST MDF DATE,BASED ON LABEL _KRAID IF IT IS NULL THEN PERFORM INSERTION
/// IF END DATE IS NULL THEN WE HAVE TO USE THIS AND IT IS TO BE DEFINED IN TRANSLAYER
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (lbl_Task_Id.Text == "")
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 8;
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value);
_obj_Pms_Task.TASK_GOAL_ID = Convert.ToInt32(rcmb_GoalType.SelectedItem.Value);
_obj_Pms_Task.TASK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = Pms_Bll.get_Task(_obj_Pms_Task);
if (dt.Rows.Count != 0)
{
Pms_Bll.ShowMessage(this, "Task Name Already Exist");
return;
}
else
{
if (rdtp_DATE.SelectedDate < DateTime.Now)
{
rdtp_DATE.Clear();
Pms_Bll.ShowMessage(this, "TaskDate Should Be Greater Than Current Date");
return;
}
_obj_Pms_Appraisalcycle = new PMS_Appraisalcycle();
_obj_Pms_Appraisalcycle.MODE = 11;
_obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Appraisalcycle.APPRCYCLE_ID = Convert.ToInt32(Session["EMP_ID"]);//where i am passing employee to get bunit
DataTable dtem = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle);
if (dtem.Rows.Count != 0)
{
_obj_Pms_Appraisalcycle.MODE = 7;
_obj_Pms_Appraisalcycle.APPRCYCLE_BU_ID = Convert.ToInt32(dtem.Rows[0]["EMP_BUSINESSUNIT_ID"]);
_obj_Pms_Appraisalcycle.APPRCYCLE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt22 = Pms_Bll.get_Appraisalcycle(_obj_Pms_Appraisalcycle);
if (dt22.Rows.Count != 0)
{
DateTime dt_st = Convert.ToDateTime(dt22.Rows[0]["APPCYCLE_STARTDATE"]);
DateTime dt_et = Convert.ToDateTime(dt22.Rows[0]["APPCYCLE_ENDDATE"]);
if ((rdtp_DATE.SelectedDate.Value > dt_et) || (rdtp_DATE.SelectedDate.Value < dt_st))
{
BLL.ShowMessage(this, "Date Should Validate With Appraisal Cycle Date");
return;
}
}
else
{
BLL.ShowMessage(this, "Error Occured");
return;
}
}
else
{
Pms_Bll.ShowMessage(this, "Employee Is In Active");
return;
}
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value);
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
_obj_Pms_Task.TASK_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskDescription.Text));
_obj_Pms_Task.TASK_DATE = rdtp_DATE.SelectedDate.Value;
_obj_Pms_Task.TASK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Task.TASK_GOAL_ID = Convert.ToInt32(rcmb_GoalType.SelectedItem.Value);
_obj_Pms_Task.TASK_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Pms_Task.TASK_CREATEDDATE = DateTime.Now;
_obj_Pms_Task.TASK_APPRAISAL_CYCLE = Convert.ToInt32(rcm_apprcycle.SelectedItem.Value);
_obj_Pms_Task.Mode = 4;
bool status = Pms_Bll.set_Task(_obj_Pms_Task);
if (status == true)
{
LoadGrid();
Rg_Task.DataBind();
btn_Save.Visible = true;
Rm_TASK_PAGE.SelectedIndex = 0;
Rp_TASK_VIEWDETAILS.Visible = false;
Rp_TASK_VIEWMAIN.Visible = true;
Pms_Bll.ShowMessage(this, "Task Inserted Successfully");
return;
}
}
}
else
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.TASK_ID = Convert.ToInt32(lbl_Task_Id.Text);
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value);
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
_obj_Pms_Task.TASK_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskDescription.Text));
_obj_Pms_Task.TASK_DATE = rdtp_DATE.SelectedDate.Value;
_obj_Pms_Task.TASK_GOAL_ID = Convert.ToInt32(rcmb_GoalType.SelectedItem.Value);
_obj_Pms_Task.TASK_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Pms_Task.TASK_LASTMDFDATE = DateTime.Now;
_obj_Pms_Task.TASK_APPRAISAL_CYCLE = Convert.ToInt32(rcm_apprcycle.SelectedItem.Value);
_obj_Pms_Task.Mode = 5;
bool status = Pms_Bll.set_Task(_obj_Pms_Task);
if (status == true)
{
LoadGrid();
Rg_Task.DataBind();
btn_Save.Visible = true;
Rm_TASK_PAGE.SelectedIndex = 0;
Rp_TASK_VIEWDETAILS.Visible = false;
Rp_TASK_VIEWMAIN.Visible = true;
}
if (status == true)
{
Pms_Bll.ShowMessage(this, "Task Updated Successfully");
// return;
}
}
}
catch (Exception ex)
{
//Pms_Bll.ShowMessage(this, ex.Message.ToString());
//return;
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PmsTask", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
///IN THIS BASED ON Task_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void lnk_edit_command(object sender, CommandEventArgs e)
{
try
{
clearControls();
btn_Save.Text = "Update";
LoadBusinessUnit();
//LoadGoal();
rcmb_BusinessUnitType.SelectedIndex = -1;
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 2;
_obj_Pms_Task.TASK_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable DT = Pms_Bll.get_Task(_obj_Pms_Task);
if (DT.Rows.Count != 0)
{
lbl_Task_Id.Text = Convert.ToString(DT.Rows[0]["TASK_ID"]);
Session["empid1"] = (DT.Rows[0]["EMP_ID"]);
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 6;
_obj_Pms_Task.TASK_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(Convert.ToString(DT.Rows[0]["EMP_ID"]));
DataTable dt_Bus = Pms_Bll.get_Task(_obj_Pms_Task);
LoadBusinessUnit();
rcmb_BusinessUnitType.SelectedIndex = rcmb_BusinessUnitType.FindItemIndexByValue(Convert.ToString(dt_Bus.Rows[0]["EMP_BUSINESSUNIT_ID"]));
//LoadEmployees();
PMS_EMPSETUP _obj_Pms_EmpSetup;
_obj_Pms_EmpSetup = new PMS_EMPSETUP();
_obj_PMS_getemployee = new PMS_GETEMPLOYEE();
if ((Convert.ToString(Session["EMP_TYPE"])) == "5")
{
_obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
}
else
{
_obj_PMS_getemployee.EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
}
_obj_PMS_getemployee.BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value);
_obj_PMS_getemployee.LASTMDFBY = Convert.ToInt32(Session["ORG_ID"]);
_obj_PMS_getemployee.Mode = 5;
dtbuid = Pms_Bll.get_RMEmployees(_obj_PMS_getemployee);
if (dtbuid.Rows.Count != 0)
{
rcmb_EmployeeType.Items.Clear();
rcmb_EmployeeType.DataSource = dtbuid;
rcmb_EmployeeType.DataTextField = "employee";
rcmb_EmployeeType.DataValueField = "EMPID";
rcmb_EmployeeType.DataBind();
rcmb_EmployeeType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
//rcmb_BusinessUnitType.Visible = false;
//lbl_BusinessUnitName.Visible = false;
}
else
{
DataTable dt1 = new DataTable();
rcmb_EmployeeType.DataSource = dt1;
rcmb_EmployeeType.DataBind();
//lbl_BusinessUnitName.Visible = false;
//rcmb_BusinessUnitType.Visible = false;
}
//EmpLoad();
rcmb_EmployeeType.SelectedIndex = rcmb_EmployeeType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["EMP_ID"]));
//rcmb_EmployeeType.SelectedValue = Convert.ToString(DT.Rows[0]["TASK_EMP_ID"]);
rtxt_TaskName.Text = Convert.ToString(DT.Rows[0]["TASK_NAME"]);
rtxt_TaskDescription.Text = Convert.ToString(DT.Rows[0]["TASK_DESCRIPTION"]);
rdtp_DATE.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TASK_DATE"]);
LoadGoal1();
rcmb_GoalType.SelectedIndex = rcmb_GoalType.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TASK_GOAL"]));
LoadAppraisalCycle1();
rcm_apprcycle.SelectedIndex = rcm_apprcycle.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TASK_APPRAISAL_CYCLE"]));
btn_Save.Visible = true;
rtxt_TaskName.Enabled = false;
Rm_TASK_PAGE.SelectedIndex = 1;
Rp_TASK_VIEWMAIN.Visible = false;
Rp_TASK_VIEWDETAILS.Visible = true;
rcmb_BusinessUnitType.Enabled = false;
rcmb_EmployeeType.Enabled = false;
//rcmb_BusinessUnitType.Visible = false;
//lbl_BusinessUnitName.Visible = false;
rcmb_GoalType.Enabled = false;
rcm_apprcycle.Enabled = false;
rdtp_DATE.Enabled = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Save.Visible = false;
}
else
{
btn_Save.Visible = true;
}
}
else
{
Pms_Bll.ShowMessage(this, "Error Occured");
}
}
catch (Exception ex)
{
//Pms_Bll.ShowMessage(this, ex.Message.ToString());
//return;
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PmsTask", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// WHILE INSERTING THERE IS NO NEED TO ADD LAST MDF BY,LAST MDF DATE,BASED ON LABEL _KRAID IF IT IS NULL THEN PERFORM INSERTION
/// IF END DATE IS NULL THEN WE HAVE TO USE THIS AND IT IS TO BE DEFINED IN TRANSLAYER
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (lbl_Task_Id.Text == "")
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.Mode = 8;
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
DataTable dt = Pms_Bll.get_Task(_obj_Pms_Task);
if (dt.Rows.Count != 0)
{
Pms_Bll.ShowMessage(this, "Task Name Already Exist");
return;
}
else
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value);
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
_obj_Pms_Task.TASK_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskDescription.Text));
_obj_Pms_Task.TASK_DATE = rdtp_DATE.SelectedDate.Value;
_obj_Pms_Task.TASK_GOAL_ID = Convert.ToInt32(rcmb_GoalType.SelectedItem.Value);
_obj_Pms_Task.TASK_CREATEDBY = 1; // ### Need to Get the Session
_obj_Pms_Task.TASK_CREATEDDATE = DateTime.Now;
_obj_Pms_Task.Mode = 4;
bool status = Pms_Bll.set_Task(_obj_Pms_Task);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Task Inserted Successfully");
LoadGrid();
Rg_Task.DataBind();
btn_Save.Visible = true;
Rm_TASK_PAGE.SelectedIndex = 0;
return;
}
}
}
else
{
_obj_Pms_Task = new SPMS_TASK();
_obj_Pms_Task.TASK_ID = Convert.ToInt32(lbl_Task_Id.Text);
_obj_Pms_Task.TASK_EMP_ID = Convert.ToInt32(rcmb_EmployeeType.SelectedItem.Value);
_obj_Pms_Task.TASK_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskName.Text));
_obj_Pms_Task.TASK_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_TaskDescription.Text));
_obj_Pms_Task.TASK_DATE = rdtp_DATE.SelectedDate.Value;
_obj_Pms_Task.TASK_GOAL_ID = Convert.ToInt32(rcmb_GoalType.SelectedItem.Value);
_obj_Pms_Task.TASK_LASTMDFBY = 1; // ### Need to Get the Session
_obj_Pms_Task.TASK_LASTMDFDATE = DateTime.Now;
_obj_Pms_Task.Mode = 5;
bool status = Pms_Bll.set_Task(_obj_Pms_Task);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Task Updated Successfully");
LoadGrid();
Rg_Task.DataBind();
btn_Save.Visible = true;
Rm_TASK_PAGE.SelectedIndex = 0;
return;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Task", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
