Exemple #1
0
    protected void loadDropdown()
    {
        try
        {
            SMHR_EMPNOTES _obj_Smhr_EmpNotes = new SMHR_EMPNOTES();
            _obj_Smhr_EmpNotes.OPERATION = operation.Empty;

            rcmb_OTDetEmployeeID.Items.Clear();
            rcmb_OTDetEmployeeID.DataSource     = BLL.get_EmpNotes(_obj_Smhr_EmpNotes);
            rcmb_OTDetEmployeeID.DataTextField  = "EMPNAME";
            rcmb_OTDetEmployeeID.DataValueField = "EMP_ID";
            rcmb_OTDetEmployeeID.DataBind();
            rcmb_OTDetEmployeeID.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));

            rcmb_OTDetOTType.Items.Clear();
            rcmb_OTDetOTType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));

            rcmb_OTDetPeriodMain.Items.Clear();
            rcmb_OTDetPeriodMain.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));

            rcmb_OTDetPeriodDetails.Items.Clear();
            rcmb_OTDetPeriodDetails.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OverTime", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    private void LoadReportEmployees()
    {
        try
        {
            if (Convert.ToString(rcmb_NotesRecEmpID.SelectedItem.Value) != "-1")
            {
                SMHR_EMPNOTES _obj_Smhr_EmpNotes = new SMHR_EMPNOTES();
                _obj_Smhr_EmpNotes.OPERATION       = operation.Empty;
                _obj_Smhr_EmpNotes.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                DataTable dt = BLL.get_EmpNotes(_obj_Smhr_EmpNotes);
                dt.DefaultView.RowFilter = " EMP_ID <> " + Convert.ToString(rcmb_NotesRecEmpID.SelectedItem.Value);
                dt = dt.DefaultView.ToTable();
                rcmb_NotesRecManagerID.Items.Clear();
                rcmb_NotesRecManagerID.DataSource     = dt;
                rcmb_NotesRecManagerID.DataTextField  = "EMPNAME";
                rcmb_NotesRecManagerID.DataValueField = "EMP_ID";
                rcmb_NotesRecManagerID.DataBind();


                SMHR_EMPLOYEE _obj_Smhr_Employee = new SMHR_EMPLOYEE();
                _obj_Smhr_Employee.OPERATION = operation.Select;
                _obj_Smhr_Employee.EMP_ID    = Convert.ToInt32(rcmb_NotesRecEmpID.SelectedItem.Value);
                dt = new DataTable();
                _obj_Smhr_Employee.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                dt = BLL.get_Employee(_obj_Smhr_Employee);
                rcmb_NotesRecManagerID.SelectedIndex = rcmb_NotesRecManagerID.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMP_REPORTINGEMPLOYEE"]));
                if (dt.Rows[0]["EMP_DOJ"] != DBNull.Value)
                {
                    rdtp_NotesRecDOJ.SelectedDate = Convert.ToDateTime(Convert.ToString(dt.Rows[0]["EMP_DOJ"]));
                }
                rcmb_NotesRecManagerID.Enabled = false;
            }
            else
            {
                rcmb_NotesRecManagerID.Items.Clear();
                rdtp_NotesRecDOJ.SelectedDate = null;
            }
            rcmb_NotesRecManagerID.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeeNotes", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
 public void LoadGrid()
 {
     try
     {
         SMHR_EMPNOTES _obj_Smhr_EmpNotes = new SMHR_EMPNOTES();
         _obj_Smhr_EmpNotes.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
         _obj_Smhr_EmpNotes.LOGIN_ID        = Convert.ToInt32(Session["USER_ID"]);
         //        DataTable DT = BLL.get_EmpNotes(new SMHR_EMPNOTES());BHARADWAJ
         DataTable DT = BLL.get_EmpNotes(_obj_Smhr_EmpNotes);
         Rg_NotesRec.DataSource = DT;
         clearControls();
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeeNotes", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    protected void lnk_Edit_Command(object sender, CommandEventArgs e)
    {
        try
        {
            loadDropdown();
            clearControls();
            ddl_BusinessUnit.Enabled   = false;
            rcmb_NotesRecEmpID.Enabled = false;
            SMHR_EMPNOTES _obj_Smhr_EmpNotes = new SMHR_EMPNOTES();
            _obj_Smhr_EmpNotes.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
            _obj_Smhr_EmpNotes.EMPNOTES_ID     = Convert.ToInt32(Convert.ToString(e.CommandArgument));
            DataTable dt = BLL.get_EmpNotes(_obj_Smhr_EmpNotes);
            ddl_BusinessUnit.SelectedIndex = ddl_BusinessUnit.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPNOTES_BU"]));
            lbl_NotesRecID.Text            = Convert.ToString(dt.Rows[0]["EMPNOTES_ID"]);
            //ddl_BusinessUnit_SelectedIndexChanged(null, null);
            LoadEmployees_Edit();
            rcmb_NotesRecEmpID.SelectedIndex = rcmb_NotesRecEmpID.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPNOTES_EMPID"]));
            //rcmb_NotesRecEmpID_SelectedIndexChanged(null, null);
            LoadReportEmployees_Edit();
            rcmb_NotesRecManagerID.SelectedIndex = rcmb_NotesRecManagerID.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPNOTES_RPTMNGID"]));
            rtxt_NotesRecRemarks.Text            = Convert.ToString(dt.Rows[0]["EMPNOTES_REMARKS"]);
            rtxt_NotesRecReason.Text             = Convert.ToString(dt.Rows[0]["EMPNOTES_REASON"]);
            rdtp_NotesRecDate.SelectedDate       = Convert.ToDateTime(dt.Rows[0]["EMPNOTES_DATE"]);
            if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
            {
                btn_Edit.Visible = false;
            }

            else
            {
                btn_Edit.Visible = true;
            }


            Rm_NR_page.SelectedIndex = 1;
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeeNotes", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        try
        {
            SMHR_EMPNOTES _obj_Smhr_EmpNotes = new SMHR_EMPNOTES();

            _obj_Smhr_EmpNotes.EMPNOTES_BU       = Convert.ToInt32(ddl_BusinessUnit.SelectedValue);
            _obj_Smhr_EmpNotes.EMPNOTES_EMPID    = Convert.ToInt32(rcmb_NotesRecEmpID.SelectedItem.Value);
            _obj_Smhr_EmpNotes.EMPNOTES_RPTMNGID = Convert.ToInt32(rcmb_NotesRecManagerID.SelectedItem.Value);
            _obj_Smhr_EmpNotes.EMPNOTES_REMARKS  = BLL.ReplaceQuote(rtxt_NotesRecRemarks.Text);
            _obj_Smhr_EmpNotes.EMPNOTES_REASON   = BLL.ReplaceQuote(rtxt_NotesRecReason.Text);
            _obj_Smhr_EmpNotes.EMPNOTES_DATE     = Convert.ToDateTime(rdtp_NotesRecDate.SelectedDate);

            _obj_Smhr_EmpNotes.CREATEDBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_EmpNotes.CREATEDDATE = DateTime.Now;

            _obj_Smhr_EmpNotes.LASTMDFBY       = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_EmpNotes.LASTMDFDATE     = DateTime.Now;
            _obj_Smhr_EmpNotes.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);

            SMHR_EMPLOYEE _obj_smhr_employee = new SMHR_EMPLOYEE();
            _obj_smhr_employee.OPERATION = operation.Select;
            _obj_smhr_employee.EMP_ID    = Convert.ToInt32(rcmb_NotesRecEmpID.SelectedItem.Value);
            //dt_Details = new DataTable();
            _obj_smhr_employee.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
            DataTable dt_Details = BLL.get_Employee(_obj_smhr_employee);
            if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 1)
            {
                BLL.ShowMessage(this, "Employee is Resigned.You can not update the record.");
                return;
            }
            else if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 2)
            {
                BLL.ShowMessage(this, "Employee is Relieved.You can not update the record.");
                return;
            }
            else if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 3)
            {
                BLL.ShowMessage(this, "Employee is Rehired.You can not update the record.");
                return;
            }
            else
            {
                switch (((Button)sender).ID.ToUpper())
                {
                case "BTN_EDIT":
                    _obj_Smhr_EmpNotes.EMPNOTES_ID = Convert.ToInt32(lbl_NotesRecID.Text);
                    _obj_Smhr_EmpNotes.OPERATION   = operation.Update;
                    if (BLL.set_EmpNotes(_obj_Smhr_EmpNotes))
                    {
                        BLL.ShowMessage(this, "Information Updated Successfully");
                    }
                    else
                    {
                        BLL.ShowMessage(this, "Information Not Saved");
                    }

                    break;

                case "BTN_SAVE":
                    _obj_Smhr_EmpNotes.OPERATION = operation.Insert;
                    if (BLL.set_EmpNotes(_obj_Smhr_EmpNotes))
                    {
                        BLL.ShowMessage(this, "Information Saved Successfully");
                    }
                    else
                    {
                        BLL.ShowMessage(this, "Information Not Saved");
                    }
                    break;

                default:
                    break;
                }
                Rm_NR_page.SelectedIndex = 0;
                LoadGrid();
                Rg_NotesRec.DataBind();
            }
        }

        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeeNotes", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }