Esempio n. 1
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                // lngID = objDB.GerMaxIDNumber("PostingDivisionList", "PostingDivId");TrainingNeedType
                lngID = objDB.GerMaxIDNumber("TrainingNeedType", "TrainingNeedTypeID");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }



            Desigation objCnt = new Desigation(lngID.ToString(), txtTraniniType.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (ChkIsActive.Checked == true ? "N" : "Y"));

            objTM.InsTainingTypeWiseSubtype(grLocation, objCnt, hfIsUpadate.Value, IsDelete, (ChkIsActive.Checked == true ? "N" : "Y"));

            lblMsg.Text = Common.GetMessage(hfIsUpadate.Value.ToString(), IsDelete);
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord(0);
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 2
0
    private void SendEmail()
    {
        MasterTablesManager   MasMgr  = new MasterTablesManager();
        MailManagerSmtpClient objMail = new MailManagerSmtpClient();

        DataTable dt = MasMgr.GetEmailNotification();

        string strRetText  = "";
        string strToAddr   = dt.Rows[0]["Approval"].ToString().Trim();
        string strCC       = dt.Rows[0]["Notify"].ToString().Trim() + ";" + dt.Rows[0]["Verify"].ToString().Trim();
        string strSubject  = "Salary of " + ddlMonth.SelectedItem.ToString().Trim() + " has been waiting for your Approval";
        string strBody     = "Hi,<br />The salary has been reviwed and found ok, you may now approve.";
        string strFromAddr = Session["EMAILID"].ToString().Trim();

        strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, strCC);

        if (strRetText == "Y")
        {
            lblMsg.Text = lblMsg.Text + ", and Email has been sent to Approve by CR.";
        }
        else
        {
            lblMsg.Text = lblMsg.Text + ", Email sending failed.";
        }
    }
Esempio n. 3
0
    private void SaveData(string IsDelete)
    {
        long   lngID      = 0;
        string strCmdType = "";

        if (IsDelete == "Y")
        {
            strCmdType = "U";
        }
        else
        {
            strCmdType = hfIsUpadate.Value == "N" ? "I" : "U";
        }
        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("HomeDistrictList", "DistId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            DataTable dtData = objDS.Tables["HomeDistrictList"];
            DataRow   nRow   = dtData.NewRow();

            nRow["DistId"]    = lngID;
            nRow["DistName"]  = txtDistrict.Text.Trim();
            nRow["HomeDivId"] = ddlDivision.SelectedValue.Trim();
            nRow["IsActive"]  = ChkIsActive.Checked == true ? "N" : "Y";
            nRow["IsDeleted"] = "N";
            if (hfIsUpadate.Value == "N")
            {
                nRow["InsertedBy"]   = Session["USERID"].ToString();
                nRow["InsertedDate"] = DateTime.Now.ToString();
            }
            else
            {
                nRow["UpdatedBy"]   = Session["USERID"].ToString();
                nRow["UpdatedDate"] = DateTime.Now.ToString();
            }
            dtData.Rows.Add(nRow);
            dtData.AcceptChanges();

            MasMgr.SaveData(dtData, strCmdType);
            lblMsg.Text = Common.GetMessage(strCmdType);

            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 4
0
    private void SendEmail()
    {
        MasterTablesManager   MasMgr  = new MasterTablesManager();
        MailManagerSmtpClient objMail = new MailManagerSmtpClient();

        DataTable dt = MasMgr.GetEmailNotification();

        string strRetText  = "";
        string strToAddr   = dt.Rows[0]["Review"].ToString().Trim();
        string strCC       = dt.Rows[0]["Notify"].ToString().Trim();
        string strSubject  = "Salary of " + ddlMonth.SelectedItem.ToString().Trim() + " has been waiting for ur Recommendation";
        string strBody     = "Hi,<br />The salary has been verified by Finance and found ok, you may recommend for approval.";
        string strFromAddr = Session["EMAILID"].ToString().Trim();

        strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, strCC);

        if (strRetText == "Y")
        {
            lblMsg.Text = lblMsg.Text + ", and Email has been sent to Review by Director Finance.";
        }
        else
        {
            lblMsg.Text = lblMsg.Text + ", Email sending failed.";
        }
    }
Esempio n. 5
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("BloodGroupList", "BloodGroupId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Desigation objCnt = new Desigation(lngID.ToString(), txtDesigation.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (ChkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertBloodGroupList(objCnt, hfIsUpadate.Value, IsDelete, (ChkIsActive.Checked == true ? "N" : "Y"));

            lblMsg.Text = Common.GetMessage(hfIsUpadate.Value.ToString(), IsDelete);
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
    private void SendEmail()
    {
        MasterTablesManager   MasMgr  = new MasterTablesManager();
        MailManagerSmtpClient objMail = new MailManagerSmtpClient();

        DataTable dt = MasMgr.GetEmailNotification();

        string strRetText  = "";
        string strToAddr   = dt.Rows[0]["Disburse"].ToString().Trim();
        string strCC       = dt.Rows[0]["Notify"].ToString().Trim() + ";" + dt.Rows[0]["Verify"].ToString().Trim() + ";" + dt.Rows[0]["Review"].ToString().Trim();
        string strSubject  = "Salary of " + ddlMonth.SelectedItem.ToString().Trim() + " has been Approved";
        string strBody     = "Salary is approved, please proceed for payment.";
        string strFromAddr = Session["EMAILID"].ToString().Trim();

        strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, strCC);

        if (strRetText == "Y")
        {
            lblMsg.Text = lblMsg.Text + ", and Email has been sent to Disburse by Finance.";
        }
        else
        {
            lblMsg.Text = lblMsg.Text + ", Email sending failed.";
        }
    }
Esempio n. 7
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpdate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("EmpTypeList", "EmpTypeID");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            clsEmpType objEmpType = new clsEmpType(lngID.ToString(), txtEmpType.Text.Trim(), "", (chkInActive.Checked == true ? "N" : "Y"),
                                                   "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");

            MasMgr.InsertEmpType(objEmpType, hfIsUpdate.Value, IsDelete);

            lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);

            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
    private void SendEmail()
    {
        MasterTablesManager   MasMgr  = new MasterTablesManager();
        MailManagerSmtpClient objMail = new MailManagerSmtpClient();

        DataTable dt = MasMgr.GetEmailNotification();

        string strRetText  = "";
        string strToAddr   = dt.Rows[0]["Notify"].ToString().Trim();
        string strCC       = dt.Rows[0]["Verify"].ToString().Trim() + ";" + dt.Rows[0]["Review"].ToString().Trim() + ";" + dt.Rows[0]["Approval"].ToString().Trim();
        string strSubject  = "Payroll has been Disbursed";
        string strBody     = "";
        string strFromAddr = Session["EMAILID"].ToString().Trim();

        strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, strCC);

        if (strRetText == "Y")
        {
            lblMsg.Text = lblMsg.Text + ", and Email has been sent to Notify previous Actors.";
        }
        else
        {
            lblMsg.Text = lblMsg.Text + ", Email sending failed.";
        }
    }
    private void SaveData()
    {
        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpdate.Value == "Y")
            {
                hfId.Value = hfId.Value;
            }
            else
            {
                hfId.Value = Common.getMaxId("EmpTempDutyAssignLog", "DutyAssignID");
            }
            hfId.Value = txtEmpID.ToString();
            string strStartDate = "";
            string strEndDate   = "";

            if (string.IsNullOrEmpty(txtProcessDate.Text.Trim()) == false)
            {
                strStartDate = Common.ReturnDate(txtProcessDate.Text.Trim());
            }

            if (string.IsNullOrEmpty(txtDueDate.Text.Trim()) == false)
            {
                strEndDate = Common.ReturnDate(txtDueDate.Text.Trim());
            }

            //clsTempDutyAssign objclsTempDutyAssign = new clsTempDutyAssign
            //(
            //    hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), ddlDistrict.SelectedValue.ToString(), ddlLocation.SelectedValue.ToString(),
            //    ddlSector.SelectedValue.ToString(), ddlUnit.SelectedValue.ToString(), ddlDept.SelectedValue.ToString(), txtAssignment.Text.Trim(), strStartDate, strEndDate,
            //   txtPercentage.Text.Trim(), txtAmount.Text.Trim(), txtSupervisorId.Text.Trim(), txtSupervisorComments.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())
            //);

            objEmpInfoMgr.InsertFinalPayment(txtEmpID.Text.Trim(), strStartDate, strEndDate, txtPaymentAmt.Text.ToString(), txtPFAmount.Text.ToString(), txtRemarks.Text.ToString(), hfIsUpdate.Value);

            if (hfIsUpdate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else if (hfIsUpdate.Value == "Y")
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            else
            {
                lblMsg.Text = "Record Deleted Successfully";
            }

            this.EntryMode(false);
            this.ClearControls();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 10
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("ProjectList", "ProjectId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            clsProject objPrj = new clsProject(lngID.ToString(),
                                               txtProject.Text.Trim(),
                                               txtProjectCode.Text.Trim(),

                                               Common.ReturnDate(txtStartDate.Text.ToString()),
                                               Common.ReturnDate(txtEndDate.Text.ToString()),

                                               ddlWeekend.SelectedItem.Value.ToString(),
                                               ddlIncrement.SelectedItem.Value.ToString(),
                                               ddlIncrMonth.SelectedItem.Value.ToString(),
                                               txtIncrementYear.Text.ToString() == "" ? "0" : txtIncrementYear.Text.ToString(),
                                               (ChkIsActive.Checked == true ? "N" : "Y"),
                                               "N",
                                               Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()));

            MasMgr.InsertUpProject(grBenefits, objPrj, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 11
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            StringBuilder strSBUID = new StringBuilder();

            MasterTablesManager MasMgr = new MasterTablesManager();

            string strValidFrom = "";
            string strValidTo   = "";

            if (string.IsNullOrEmpty(txtValidFrom.Text.Trim()) == false)
            {
                strValidFrom = Common.ReturnDate(txtValidFrom.Text.Trim());
            }


            if (string.IsNullOrEmpty(txtValidTo.Text.Trim()) == false)
            {
                strValidTo = Common.ReturnDate(txtValidTo.Text.Trim());
            }

            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("DepartmentList", "DeptID");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Department objDepartment = new Department(lngID.ToString(), txtDept.Text.Trim(), "", "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()),
                                                      Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N/A", "N", "N", strSBUID.ToString(), (chkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertDepartment(objDepartment, hfIsUpadate.Value, IsDelete, strSBUID.ToString(), (chkIsActive.Checked == true ? "N" : "Y"),
                                    txtDeptCode.Text.Trim(), strValidFrom, strValidTo);

            Common.GetMessage(hfIsUpadate.Value, IsDelete);
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 12
0
    protected void btnUploadMe_Click(object sender, EventArgs e)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("FileDetails", "FileId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            if (fuFileUploader.PostedFile != null && fuFileUploader.PostedFile.ContentLength > 0)
            {
                string fileName      = Path.GetFileName(fuFileUploader.PostedFile.FileName);
                string fileExtension = Path.GetExtension(fuFileUploader.PostedFile.FileName);

                string fileSavePath = Server.MapPath("~//MSBPolicyFile");
                if (!Directory.Exists(fileSavePath))
                {
                    Directory.CreateDirectory(fileSavePath);
                }
                fileSavePath = fileSavePath + "//" + fileName;
                fuFileUploader.PostedFile.SaveAs(fileSavePath);
                FileInfo fileInfo = new FileInfo(fileSavePath);

                MasMgr.InsertMSBFILEList(lngID.ToString(), hfIsUpadate.Value, "N", fileName, fileInfo.Length.ToString(), fileExtension, fileSavePath);
                lblMsg.Text      = "File Uploaded Successfully!";
                lblMsg.ForeColor = System.Drawing.Color.Green;
            }
            else
            {
                lblMsg.Text = "Error: Please select a file to upload!";
            }

            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 13
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            StringBuilder       strDivisionID = new StringBuilder();
            MasterTablesManager MasMgr        = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("UnitList", "UnitId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }
            Desigation objCnt = new Desigation(lngID.ToString(), txtSbu.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (chkInActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertUnit(grDepartment, objCnt, hfIsUpadate.Value, IsDelete, (chkInActive.Checked == true ? "N" : "Y"));


            /* Division objDivision = new Division(lngID.ToString(), txtSbu.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N/A", "N", "N", (chkInActive.Checked == true ? "N" : "Y"));
             *
             * objMasMgr.InsertUnit(objDivision, hfIsUpadate.Value, IsDelete, (chkInActive.Checked == true ? "N" : "Y"));
             *
             * MasMgr.InsertUnit(grDepartment, objDivision, hfIsUpadate.Value, IsDelete, (chkInActive.Checked == true ? "N" : "Y"));*/
            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord(0);
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 14
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("ClinicList", "ClinicId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Clinic objCnt = new Clinic(lngID.ToString(), txtClinic.Text.Trim(), txtShortName.Text.Trim(), ddlClinicType.SelectedValue.ToString(), txtSunCode.Text.Trim(),
                                       txtBankAccNo.Text.Trim(), ddlBank.SelectedValue.ToString().Trim(), ddlBranch.SelectedValue.ToString().Trim(),
                                       (ChkIsActive.Checked == true ? "N" : "Y"), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(),
                                       Common.SetDateTime(DateTime.Now.ToString()), "MSB");

            MasMgr.InsertUpClinicList(objCnt, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 15
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("LocationCategory", "LocCatId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            clsCommonSetup objSetup = new clsCommonSetup(lngID.ToString(), txtClinicType.Text.Trim(), (ChkIsActive.Checked == true ? "N" : "Y"), "N",
                                                         Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");


            MasMgr.InsertLocationCategory(objSetup, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 16
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("GradeLevelList", "GradeLevelId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            GradeEquiv objGrd = new GradeEquiv(lngID.ToString(), txtGrade.Text.Trim(), "N", Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (chkIsActive.Checked == true ? "N" : "Y"), "");

            MasMgr.InsertGradeLevel(objGrd, hfIsUpadate.Value, IsDelete, (chkIsActive.Checked == true ? "N" : "Y"));

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 17
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            //if (EntryMode(true))
            //    hfIsUpadate.Value="N";
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("JobTitle", "JbTlId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Desigation objCnt = new Desigation(lngID.ToString(), txtDesigation.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (ChkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertDesignation(objCnt, hfIsUpadate.Value, IsDelete, (ChkIsActive.Checked == true ? "N" : "Y"));

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("SalaryLocation", "SalLocId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Desigation objCnt = new Desigation(lngID.ToString(), txtDesigation.Text.Trim(), ddlCostCenterCode.SelectedItem.ToString().Trim(), "N", Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (ChkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertSalaryLocation(grSubLocation, objCnt, hfIsUpadate.Value, IsDelete, (ChkIsActive.Checked == true ? "N" : "Y"));

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord(0);
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 19
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("CountryList", "CountryID");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Country objCnt = new Country(lngID.ToString(), txtCountry.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N");

            MasMgr.InsertCountry(objCnt, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 20
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("SpecialSkillList", "SpecSkillId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Department objDepartment = new Department(lngID.ToString(), txtDept.Text.Trim(), "", "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N/A", "N", "N", "", (chkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertSpecialSkill(objDepartment, hfIsUpadate.Value, IsDelete, "", (chkIsActive.Checked == true ? "N" : "Y"));

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 21
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("Disiciplineinfo", "DisiciplineId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            Disicipline objDiv = new Disicipline(lngID.ToString(), txttitel.Text.Trim(), "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (chkInActive.Checked == true ? "Y" : "N"));

            MasMgr.InsertDisicipline(objDiv, hfIsUpadate.Value, IsDelete, (chkInActive.Checked == true ? "N" : "Y"));

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            StringBuilder strSBUID = new StringBuilder();

            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpdate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("OrientationTraining", "OriTrainingID");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }
            string strFirstDayOri     = this.chkFDayOrien.Checked == true? "Y" : "N";
            string strFirstDayOriDate = this.txtFDayOTDate.Text;
            string strAngChiSeftyPol  = this.chkAnCSPori.Checked == true? "Y" : "N";
            string strOT     = this.chkOT.Checked == true? "Y" : "N";
            string strOTDate = this.txtOTDate.Text;
            string strRemark = this.txtRemarks.Text;

            objTM.InsertOrientaTraining(lngID.ToString(), txtEmpID.Text.Trim(), strFirstDayOri, strFirstDayOriDate, strAngChiSeftyPol,
                                        strOT, strOTDate, strRemark, IsDelete, Session["USERID"].ToString(), hfIsUpdate.Value.ToString());

            lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);
            //Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord(txtEmpID.Text.Trim());
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 23
0
    private void SaveData(string IsDelete)
    {
        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                hfID.Value = Common.getMaxId("ProjectOfficeList", "ProjOfficeId");
            }
            else
            {
                hfID.Value = hfID.Value;
            }

            Desigation objCnt = new Desigation(hfID.Value.ToString(), txtName.Text.Trim(), "N", Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", (ChkIsActive.Checked == true ? "N" : "Y"));

            MasMgr.InsertProjectOffice(objCnt, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 24
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("SalaryHeadBlock", "TransId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            MasMgr.InsertSalaryHeadBlock(lngID.ToString(), ddlSupervisor.SelectedValue.Trim(), ddlSalHead.SelectedValue.Trim(), txtFromDate.Text.Trim(),
                                         txtToDate.Text.Trim(), txtBlockAmt.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 25
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            Desigation          objCnt = new Desigation(lngID.ToString(), "", "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "HRD", "N", "N", "Y");
            MasMgr.UpdateProfessionalDegree(grprofessional, Session["USERID"].ToString());
            lblMsg.Text = "Record Updated Successfully";
            Common.EmptyTextBoxValues(this);
            //this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }



        //  clsCommonSetup objCommonSetup = new clsCommonSetup(hfId.Value.ToString(), txtName.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
        //        Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);

        //   objEmpMgr.InsertDegree(objCommonSetup, hfIsUpdate.Value, IsDelete);
        //   lblMsg.Text = "Record Updated Successfully";
        //    Common.EmptyTextBoxValues(this);
        //    this.EntryMode(false);
        //    this.OpenRecord();
        //}
        //catch (Exception ex)
        //{
        //    lblMsg.Text = "";
        //    throw (ex);
        //}
    }
    private void SendEmail()
    {
        MasterTablesManager   MasMgr  = new MasterTablesManager();
        MailManagerSmtpClient objMail = new MailManagerSmtpClient();

        DataTable dt = MasMgr.GetEmailNotification();

        string strRetText  = "";
        string strToAddr   = dt.Rows[0]["Verify"].ToString().Trim();
        string strSubject  = "Salary of " + ddlMonth.SelectedItem.ToString().Trim() + " has been waiting for your verification";
        string strBody     = "Hi,<br />The salary has been prepared by HR. Please verify and forword to Dir finance & Admin.";
        string strFromAddr = Session["EMAILID"].ToString().Trim();

        strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, "");

        if (strRetText == "Y")
        {
            lblMsg.Text = lblMsg.Text + "Email has been sent to Verify by Finance.";
        }
        else
        {
            lblMsg.Text = lblMsg.Text + "Email sending failed.";
        }
    }
Esempio n. 27
0
    private void SaveData()
    {
        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();

            if (hfIsUpdate.Value == "Y")
            {
                hfId.Value = hfId.Value;
            }
            else
            {
                hfId.Value = Common.getMaxId("EmpTempDutyAssignLog", "DutyAssignID");
            }

            string strStartDate = "";
            string strEndDate   = "";

            if (string.IsNullOrEmpty(txtStartDate.Text.Trim()) == false)
            {
                strStartDate = Common.ReturnDate(txtStartDate.Text.Trim());
            }

            if (string.IsNullOrEmpty(txtEndDate.Text.Trim()) == false)
            {
                strEndDate = Common.ReturnDate(txtEndDate.Text.Trim());
            }

            clsTempDutyAssign objclsTempDutyAssign = new clsTempDutyAssign
                                                     (
                hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(),
                ddlCompany.SelectedValue.ToString(), ddlClinic.SelectedValue.ToString(), ddlProject.SelectedValue.ToString(), ddlDept.SelectedValue.ToString(), ddlSubDept.SelectedValue.ToString(),
                txtAssignment.Text.Trim(), strStartDate, strEndDate,
                txtPercentage.Text.Trim(), txtAmount.Text.Trim(), txtSupervisorId.Text.Trim(),
                txtSupervisorComments.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())
                                                     );

            objEmpInfoMgr.InsertEmpTempDuty(objclsTempDutyAssign, hfIsUpdate.Value);

            if (hfIsUpdate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else if (hfIsUpdate.Value == "Y")
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            else
            {
                lblMsg.Text = "Record Deleted Successfully";
            }

            this.EntryMode(false);
            this.ClearControls();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 28
0
    private void SaveData(string IsDelete)
    {
        long lngID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            //Filling Class Properties with values
            if (hfIsUpadate.Value == "N")
            {
                lngID = objDB.GerMaxIDNumber("ProjectList", "ProjectId");
            }
            else
            {
                lngID = Convert.ToInt32(hfID.Value);
            }

            clsProject objPrj = new clsProject(lngID.ToString(),
                                               txtProject.Text.Trim(),
                                               txtSName.Text.Trim(),
                                               txtProjectCode.Text.Trim(),

                                               Common.ReturnDate(txtStartDate.Text.ToString()),
                                               Common.ReturnDate(txtEndDate.Text.ToString()),

                                               //ddlWeekend.SelectedItem.Value.ToString(),
                                               //ddlIncrement.SelectedItem.Value.ToString(),
                                               //ddlIncrMonth.SelectedItem.Value.ToString(),
                                               //txtIncrementYear.Text.ToString(),

                                               (chkPF.Checked == true ? "Y" : "N"),
                                               (chkGratuity.Checked == true ? "Y" : "N"),
                                               //(chkEOC.Checked == true ? "Y" : "N"),
                                               //(chkEL.Checked == true ? "Y" : "N"),
                                               //(chkInsurance.Checked == true ? "Y" : "N"),
                                               //(chkGrossSalary.Checked == true ? "Y" : "N"),
                                               //(chkBasicSalary.Checked == true ? "Y" : "N"),
                                               //(chkCore.Checked == true ? "Y" : "N"),
                                               //(chkProject.Checked == true ? "Y" : "N"),

                                               (ChkIsActive.Checked == true ? "N" : "Y"),
                                               "N",
                                               Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()),
                                               Session["USERID"].ToString(),
                                               Common.SetDateTime(DateTime.Now.ToString()),
                                               "RDRS"

                                               );

            MasMgr.InsertUpProject(objPrj, hfIsUpadate.Value, IsDelete);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
            this.OpenRecord();
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 29
0
    private void SaveData(string IsDelete)
    {
        try
        {
            MasterTablesManager MasMgr     = new MasterTablesManager();
            clsEmpInfo          objEmpInfo = new clsEmpInfo(
                txtEmpID.Text.ToString(),
                ddlTitle.SelectedValue.ToString(),
                txtFullName.Text.Trim(),
                txtFirstName.Text.Trim(),
                txtMiddleName.Text.Trim(),
                txtLastName.Text.Trim(),
                txtFatherName.Text.Trim(),
                txtMotherName.Text.Trim(),
                txtPreAddress.Text.Trim(),
                txtPrePhone.Text.Trim(),
                txtPreFax.Text.Trim(),
                txtPerAddress.Text.Trim(),
                txtPerPhone.Text.Trim(),
                txtPerFax.Text.Trim(),
                ddlPerDistrict.SelectedValue.ToString(),
                ddlPerCountry.SelectedValue.ToString(),
                ddlGender.SelectedValue.ToString(),
                txtDob.Text.Trim(),
                ddlReligion.SelectedValue.ToString(),
                ddlBloodGroup.SelectedValue.ToString(),
                ddlMaritalStatus.SelectedValue.ToString(),
                txtMarriageDate.Text.Trim(),
                txtNationality.Text.Trim(),
                txtNationalId.Text.Trim(),
                txtDOBId.Text.Trim(),
                txtTINNo.Text.Trim(),
                txtCircle.Text.Trim(),
                txtZone.Text.Trim(),
                txtPassportNo.Text.Trim(),
                txtPassExpDate.Text.Trim(),
                txtPasportIssOff.Text.Trim(),
                txtSkypeID.Text.Trim(),
                txtOffPhExt.Text.Trim(),
                txtOfficeEmail.Text.Trim(),
                txtCellPhone.Text.Trim(),
                txtLandPhone.Text.Trim(),
                txtPersonalEmail.Text.Trim(),
                ddlHighestEdu.SelectedValue.ToString(),
                ddlProffDegree.SelectedValue.ToString(),
                ddlSpecialSkill.SelectedValue.ToString(),
                chkIsRelativeSC.Checked == true ? "Y" : "N",
                ddlRelation.SelectedValue.ToString(),
                //chkIsSpectacled.Checked == true ? "Y" : "N",
                txtLicenseNo.Text.Trim(),
                txtLicenseExpDate.Text.Trim(),
                hfEmpImage.Value.ToString(),
                txtRelativeInfo.Text.Trim(),
                ddlNature.SelectedValue.ToString(),
                ddlPerDivision.SelectedValue.Trim(),
                ddlPerUpazila.SelectedValue.Trim(),
                ddlPerPS.SelectedValue.Trim(),
                ddlPreDivision.SelectedValue.Trim(),
                ddlPreDistrict.SelectedValue.Trim(),
                ddlPreUpzilla.SelectedValue.Trim(),
                ddlPrePS.SelectedValue.Trim(),
                ddlSubject.SelectedValue.ToString(),
                txtSSMMrNo.Text.Trim(),
                txtSpouseName.Text.Trim(),
                txtOldEmpID.Text.Trim()
                );

            // Upload Employee Image
            if (hfIsUpadate.Value == "N")
            {
                this.UploadImage();
            }
            else
            {
                if (FileUpload1.HasFile && FileUpload1.PostedFile != null)
                {
                    this.UploadImage();
                }
                else if (!string.IsNullOrEmpty(Session["imgByte"].ToString()))
                {
                    imgByte = (byte[])Session["imgByte"];
                }
            }
            // Upload Employee Signature Image
            if (hfIsUpadate.Value == "N")
            {
                this.UploadSignImage();
            }
            else
            {
                if (FileUpload2.HasFile && FileUpload2.PostedFile != null)
                {
                    this.UploadSignImage();
                }
                else if (!string.IsNullOrEmpty(Session["imgSignByte"].ToString()))
                {
                    imgSignByte = (byte[])Session["imgSignByte"];
                }
            }

            objEmpInfoMgr.InsertEmpInfo(objEmpInfo, hfIsUpadate.Value, IsDelete, imgByte, imgSignByte);

            if (hfIsUpadate.Value == "N")
            {
                lblMsg.Text = "Record Saved Successfully";
            }
            else
            {
                lblMsg.Text = "Record Updated Successfully";
            }
            Common.EmptyTextBoxValues(this);
            this.EntryMode(false);
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }
Esempio n. 30
0
    private void SaveData(string IsDelete)
    {
        decimal decID = 0;

        try
        {
            MasterTablesManager MasMgr = new MasterTablesManager();
            if (hfIsUpdate.Value == "N")
            {
                decID = Convert.ToDecimal(Common.getMaxId("OfficeList", "OfficeID"));
            }
            else
            {
                decID = Convert.ToDecimal(hfID.Value);
            }

            List <DataTable> dtList = new List <DataTable>();

            DataTable dtData = objDS.Tables["OfficeList"];
            DataRow   nRow   = dtData.NewRow();
            nRow["OfficeID"]     = decID;
            nRow["OfficeTitle"]  = txtOffTitle.Text.Trim();
            nRow["OfficeTypeID"] = Common.RoundDecimal(ddlOffType.SelectedItem.Value.ToString(), 0);
            if (ddlParentOff.Items.Count != 0)
            {
                if (ddlParentOff.SelectedItem.Value.ToString() != "-1")
                {
                    nRow["ParentID"] = Common.RoundDecimal(ddlParentOff.SelectedItem.Value.ToString(), 0);
                }
            }

            nRow["DivID"]  = Common.RoundDecimal(ddlDivision.SelectedItem.Value.ToString(), 0);
            nRow["DistID"] = Common.RoundDecimal(ddlDistrict.SelectedItem.Value.ToString(), 0);
            nRow["UpzID"]  = Common.RoundDecimal(ddlUpazila.SelectedItem.Value.ToString(), 0);

            nRow["IsActive"]  = chkInActive.Checked == true ? 'N' : 'Y';
            nRow["IsDeleted"] = "N";
            nRow["IsPayLoc"]  = chkIsPayroleLoc.Checked == true ? 'Y' : 'N';
            if (hfIsUpdate.Value == "N")
            {
                nRow["InsertedBy"]   = Session["USERID"].ToString();
                nRow["InsertedDate"] = DateTime.Now;
            }
            else
            {
                nRow["UpdatedBy"]   = Session["USERID"].ToString();
                nRow["UpdatedDate"] = DateTime.Now;
            }


            dtData.Rows.Add(nRow);
            dtData.AcceptChanges();
            dtList.Add(dtData);

            DataTable dtDataSalLoc = objDS.Tables["SalaryLocation"];
            DataRow   nRowSal      = dtDataSalLoc.NewRow();
            nRowSal["SalLocId"]        = decID;
            nRowSal["SalLocName"]      = txtOffTitle.Text.Trim();
            nRowSal["DivisionID"]      = Common.RoundDecimal(hfDivisionID.Value, 0);
            nRowSal["IsActive"]        = chkInActive.Checked == true ? 'N' : 'Y';
            nRowSal["IsDeleted"]       = "Y";
            nRowSal["InsertedBy"]      = Session["USERID"].ToString();
            nRowSal["InsertedDate"]    = DateTime.Now;
            nRowSal["UpdatedBy"]       = Session["USERID"].ToString();
            nRowSal["UpdatedDate"]     = DateTime.Now;
            nRowSal["LastUpdatedFrom"] = Session["USERID"].ToString();
            if (chkIsPayroleLoc.Checked)
            {
                nRowSal["IsDeleted"] = "N";
            }
            dtDataSalLoc.Rows.Add(nRowSal);
            dtDataSalLoc.AcceptChanges();
            dtList.Add(dtDataSalLoc);
            objTMM.SaveOfficeData(dtList, hfIsUpdate.Value == "N" ? "I" : "U");

            lblMsg.Text = Common.GetMessage(hfIsUpdate.Value == "N" ? "I" : "U");
            this.EntryMode(false);
            this.OpenRecord(0, Convert.ToDecimal(ddlIntervention.SelectedValue.Trim()), Convert.ToDecimal(ddlOffTypeSearch.SelectedValue.Trim()));
        }
        catch (Exception ex)
        {
            lblMsg.Text = "";
            throw (ex);
        }
    }