protected void btnSave_Click(object sender, EventArgs e) { try { clsPaySlipOptions[] objOpt = new clsPaySlipOptions[1]; objOpt[0] = new clsPaySlipOptions(); objOpt[0].OptID = objOpt[0].PAYSLIP_VALIDITY; objOpt[0].OptName = "PAYSLIP_VALIDITY"; objOpt[0].OptValue = ddlFiscalYear.SelectedValue.Trim(); objOpt[0].ValidFrom = Common.ReturnDate(txtValidFrom.Text.Trim()); objOpt[0].ValidTo = Common.ReturnDate(txtValidTo.Text.Trim()); //objOpt[1] = new clsPaySlipOptions(); //objOpt[1].OptID = objOpt[1].FISCAL_VALIDITY; //objOpt[1].OptName = "FISCAL_VALIDITY"; //objOpt[1].OptValue = "0"; //objOpt[1].ValidFrom = Common.ReturnDate(txtFYStartDate.Text.Trim()); //objOpt[1].ValidTo = Common.ReturnDate(txtFYEndDate.Text.Trim()); //objOpt._OptID[1] = objOpt.PAYSLIP_TAXDEDEDUCTION_SALARYHEAD; //objOpt._OptName[1] = "taxDeducation"; //objOpt._OptValue[1] = ddltaxdeducation.SelectedValue.ToString(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); objOptMgr.InsertpaySlipOption(objOpt, Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); lblMsg.Text = "Record Saved Successfully"; } catch (Exception ex) { throw (ex); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { string strPID = ""; Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); // objOptMgr.InsertpaySlipOption(objOpt, Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); if (hfBPID.Value == "") { strPID = Common.getMaxId("PayrollBenefitsPolicy", "PID"); } else { strPID = hfBPID.Value; } objOptMgr.InsertPayrollBenefitsPolicyData(strPID, ddlBenefitHead.SelectedValue.Trim(), ddlEmpType.SelectedValue.Trim(), chkIsPercent.Checked == true ? "Y" : "N", ddlPercentHead.SelectedValue.Trim(), txtValue.Text.Trim(), hfBPID.Value == "" ? "N" : "Y", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); this.OpenBenefitsPolicyRecord(); hfBPID.Value = ""; btnAdd.Text = "Save"; } catch (Exception ex) { throw (ex); } }
protected void btnSave_Click(object sender, EventArgs e) { clsPaySlipOptions[] objOpt = new clsPaySlipOptions[1]; try { objOpt[0] = new clsPaySlipOptions(); //objOpt[0].OptID = objOpt[0].PAYSLIP_RET_AGE; objOpt[0].OptName = "RETIREMENT_AGE"; objOpt[0].OptValue = txtRetAge.Text; //objOpt[1].OptID = objOpt[0].PAYSLIP_BAISC_PERCENT; objOpt[1].OptName = "PAYSLIP_BAISC_PERCENT"; objOpt[1].OptValue = txtBasicPercent.Text; Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); objOptMgr.InsertpaySlipOption(objOpt, Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); lblMsg.Text = "Record Saved Successfully"; } catch (Exception ex) { throw (ex); } }
private void CalculateBasicSalary() { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("1", ddlEmpType.SelectedValue.ToString()); if (dtBfPlc.Rows.Count > 0) { decimal dclBasicAmt = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtGrossSalary.Text, 0), Common.RoundDecimal(dtBfPlc.Rows[0]["Value"].ToString(), 2)); txtBasicSalary.Text = dclBasicAmt.ToString(); } }
protected void btnGenerate_Click(object sender, EventArgs e) { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBenefitsPolicy = objOptMgr.SelectPayrollBenefitsPolicyData("0", "0"); DataTable dtBasic = objSalaryManager.GetEmpBasic(ddlSalPackTitle.SelectedValue.Trim()); DataTable dtSalHead = objSalaryManager.GetSalaryHeadForPackageSetup(); this.AddToSalaryPakDetailsDataSet(dtSalHead, dtBenefitsPolicy, dtBasic); }
protected void OpenBenefitsPolicyRecord() { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); grBPList.DataSource = objOptMgr.SelectPayrollBenefitsPolicyData("0", "0"); grBPList.DataBind(); foreach (GridViewRow gRow in grBPList.Rows) { if (grBPList.DataKeys[gRow.RowIndex][5].ToString() == "99") { gRow.Cells[6].Text = "Gross Salary"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); objOptMgr.GetPaySlipOptionsValue(); Common.FillDropDownList(objSalaryHeadMgr.SelectSalaryHead(0, "N"), ddlBenefitHead, "HEADNAME", "SHEADID", true, "Select"); Common.FillDropDownList(objMasMgr.SelectEmpType(0, "Y"), ddlEmpType, "TYPENAME", "EMPTYPEID", true, "Select"); Common.FillDropDownListWithGross(objSalaryHeadMgr.SelectGrossSalHeadWithName(0), ddlPercentHead, "HEADNAME", "SHEADID", true); Common.FillDropDownList(objSalaryHeadMgr.SelectFiscalYear(0), ddlFiscalYear, "FISCALYRTITLE", "FISCALYRID", false); this.OpenRecord(); hfMPCIsUpdate.Value = "N"; this.FillMPCDayDropDownList(31); this.OpenMonthlyPayrollCycleData(); this.OpenBenefitsPolicyRecord(); hfBPID.Value = ""; } }
protected void btnGenerate_Click(object sender, EventArgs e) { try { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBenefitsPolicy = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataTable dtBasic = objSalaryManager.GetEmpBasic(ddlSalPackTitle.SelectedValue.Trim()); if (string.IsNullOrEmpty(dtBasic.Rows[0]["GradeID"].ToString()) == true || string.IsNullOrEmpty(dtBasic.Rows[0]["GradeLevelID"].ToString()) == true) { lblMsg.Text = "Please assign staffs grade & grade step from HR screen."; return; } DataTable dtSalHead = objSalaryManager.GetSalaryHeadForPackageSetup(); this.AddToSalaryPakDetailsDataSet(dtSalHead, dtBenefitsPolicy, dtBasic); } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); } }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strTranType = ""; if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpTransitionLog", "TransId"); } string strEntryDate = ""; string strEffDate = ""; string strNextIncDate = ""; string strGradeChDate = ""; string strRetirementDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strEffDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNextIncDate.Text.Trim()) == false) { strNextIncDate = Common.ReturnDate(txtNextIncDate.Text.Trim()); } if (string.IsNullOrEmpty(txtGradeChangeDate.Text.Trim()) == false) { strGradeChDate = Common.ReturnDate(txtGradeChangeDate.Text.Trim()); } char[] splitter = { '/' }; string[] arinfo = Common.str_split(lblName.ToolTip.ToString(), splitter); int iBirthYear = 0; if (arinfo.Length == 3) { iBirthYear = Convert.ToInt16(arinfo[2]); iBirthYear = iBirthYear + 60; strRetirementDate = iBirthYear + "/" + arinfo[1] + "/" + arinfo[0]; arinfo = null; } if (radPromotion.Checked == true) { strTranType = "P"; } else if (radTrans.Checked == true) { strTranType = "T"; } else if (radStatus.Checked == true) { strTranType = "C"; } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", ddlEmpType.SelectedValue.ToString()); DataRow[] foundPlcRow; foundPlcRow = null; decimal dclNewBasicSal = 0; //Basic foundPlcRow = dtBfPlc.Select("SHEADID=1"); if (foundPlcRow.Length > 0) { DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); dclNewBasicSal = Convert.ToDecimal(nRow1["PAYAMT"].ToString()); objDs.dtSalPackUpdate.Rows.Add(nRow1); } //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 3; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } if (ddlEmpType.SelectedValue.ToString() == "1") { //PF Allowance foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (dtBfPlc.Rows.Count > 0) { DataRow nRow4 = objDs.dtSalPackUpdate.NewRow(); nRow4["SHEADID"] = 8; nRow4["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(dclNewBasicSal.ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow4); } objDs.dtSalPackUpdate.AcceptChanges(); } clsEmpTransition objEmpTrans = new clsEmpTransition(hfId.Value.ToString(), txtEmpID.Text.Trim(), strEntryDate, strTranType, ddlAction.SelectedValue.ToString(), ddlCompany.SelectedValue.ToString(), ddlClinic.SelectedValue.ToString(), ddlProject.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString(), ddlSubDept.SelectedValue.ToString(), ddlDesignation.SelectedValue.ToString(), ddlGrade.SelectedValue.ToString(), ddlSalaryLoc.SelectedValue.ToString(), ddlEmpType.SelectedValue.ToString(), txtNewGrossSalary.Text.Trim(), strEffDate, strNextIncDate, strGradeChDate, txtRemarks.Text.Trim(), (chkIsTAApplicable.Checked == true ? "Y" : "N"), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); objEmpInfoMgr.InsertEmpTransitionLog(objEmpTrans, hfDivision.Value.ToString(), hfClinic.Value.ToString(), hfProject.Value.ToString(), hfDept.Value.ToString(), hfSubDept.Value.ToString(), hfDesig.Value.ToString(), hfGrade.Value.ToString(), hfSalLoc.Value.ToString(), hfEmpType.Value.ToString(), txtNewGrossSalary.Text.Trim(), strEffDate, strNextIncDate, strGradeChDate, strRetirementDate, txtRemarks.Text.Trim(), hfIsUpdate.Value, txtNewGrossSalary.ToolTip.ToString(), hfGrossSalary.Value.ToString(), objDs.dtSalPackUpdate); lblMsg.Text = "Record Saved Successfully"; this.EntryText(); this.EntryMode(false); this.ClearControls(); }
protected void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strEntryDate = ""; string strConfirmDueDate = ""; string strExtensionDate = ""; string strConfirmDate = ""; decimal dclNewBasicSal = 0; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDueDate.Text.Trim()) == false) { strConfirmDueDate = Common.ReturnDate(txtConfirmDueDate.Text.Trim()); } if (string.IsNullOrEmpty(txtExtensionDate.Text.Trim()) == false) { strExtensionDate = Common.ReturnDate(txtExtensionDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDate.Text.Trim()) == false) { strConfirmDate = Common.ReturnDate(txtConfirmDate.Text.Trim()); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", "1"); DataRow[] foundPlcRow; foundPlcRow = null; //Basic foundPlcRow = dtBfPlc.Select("SHEADID=1"); if (foundPlcRow.Length > 0) { DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); dclNewBasicSal = Convert.ToDecimal(nRow1["PAYAMT"].ToString()); objDs.dtSalPackUpdate.Rows.Add(nRow1); } //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 3; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } if (ddlEmpType.SelectedValue.ToString() == "1") { //PF Allowance foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (dtBfPlc.Rows.Count > 0) { DataRow nRow4 = objDs.dtSalPackUpdate.NewRow(); nRow4["SHEADID"] = 8; nRow4["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(dclNewBasicSal.ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow4); } objDs.dtSalPackUpdate.AcceptChanges(); } if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpConfirmationLog", "ConfirmId"); } objEmpInfoMgr.InsertConfirmation(hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), strEntryDate, txtProbationPeriod.Text.Trim(), strConfirmDueDate, strExtensionDate, strConfirmDate, txtExtensionMonth.Text.Trim(), txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value.ToString(), lblBasicSalary.ToolTip.ToString(), objDs.dtSalPackUpdate, "Y", lblJoinDate.Text.Trim(), lblJoinDate.ToolTip.Trim(), ddlEmpType.SelectedValue.ToString(), txtNewGrossSalary.Text, dclNewBasicSal.ToString()); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.OpenRecord(); this.EntryMode(false); }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string IsDelete = "N"; long lngID = 0; try { string strConfrimDate = ""; if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strConfrimDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (hfIsUpdate.Value == "N") { lngID = objDB.GerMaxIDNumber("EmpSalaryAmendment", "LogId"); } else { lngID = Convert.ToInt32(hfID.Value); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; //Basic DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = Common.RoundDecimal(txtBasicSalary.Text, 0); objDs.dtSalPackUpdate.Rows.Add(nRow1); //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 3; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Conveyance foundPlcRow = dtBfPlc.Select("SHEADID=4"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 4; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Calculate Gross, Incremented Amount, and Percent decimal decGross = Common.RoundDecimal(txtBasicSalary.Text.Trim(), 0) + Common.RoundDecimal(txtHouseRent.Text.Trim(), 0) + Common.RoundDecimal(txtMedical.Text.Trim(), 0) + Common.RoundDecimal(txtConveyance.Text.Trim(), 0); decimal decIncrAmt = decGross - Common.RoundDecimal(lblGross.Text.Trim(), 0); decimal decIncrPercnt = (decIncrAmt * 100) / Common.RoundDecimal(lblGross.Text.Trim(), 0); decIncrPercnt = Common.RoundDecimal(decIncrPercnt.ToString(), 2); objEmpInfoMgr.InsertEmpSalaryAmendment(lngID.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), ddlAction.SelectedItem.ToString(), strConfrimDate, txtBasicSalary.Text, txtHouseRent.Text.Trim(), txtMedical.Text.Trim(), txtConveyance.Text.Trim(), decGross.ToString(), txtRemarks.Text.Trim(), decIncrAmt.ToString(), decIncrPercnt.ToString(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value, IsDelete, lblSalPac.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.EntryMode(false); this.ClearControls(); //this.OpenRecord(); } catch (Exception ex) { lblMsg.Text = ""; throw (ex); } }
protected void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strEntryDate = ""; string strConfirmDate = ""; string strNewConfirmDate = ""; string strExtensionDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDate.Text.Trim()) == false) { strConfirmDate = Common.ReturnDate(txtConfirmDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNewConfirmDate.Text.Trim()) == false) { strNewConfirmDate = Common.ReturnDate(txtNewConfirmDate.Text.Trim()); } if (string.IsNullOrEmpty(txtExtensionDate.Text.Trim()) == false) { strExtensionDate = Common.ReturnDate(txtExtensionDate.Text.Trim()); } //PF Allowance DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=13"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 13; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(lblBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } objDs.dtSalPackUpdate.AcceptChanges(); if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpConfirmationLog", "ConfirmId"); } objEmpInfoMgr.InsertConfirmation(hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), strEntryDate, strConfirmDate, txtExtensionMonth.Text.Trim(), strNewConfirmDate, strExtensionDate, txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value.ToString(), lblBasicSalary.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.OpenRecord(); this.EntryMode(false); }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string IsDelete = "N"; long lngID = 0; try { string strConfrimDate = ""; decimal dclNewBasicSal = 0; if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strConfrimDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (hfIsUpdate.Value == "N") { lngID = objDB.GerMaxIDNumber("EmpSalaryIncrementLog", "LogId"); } else { lngID = Convert.ToInt32(hfID.Value); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", lblName.ToolTip.ToString()); DataRow[] foundPlcRow; foundPlcRow = null; //Basic foundPlcRow = dtBfPlc.Select("SHEADID=1"); if (foundPlcRow.Length > 0) { DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); dclNewBasicSal = Convert.ToDecimal(nRow1["PAYAMT"].ToString()); objDs.dtSalPackUpdate.Rows.Add(nRow1); } //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 3; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } //PF Allowance foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (foundPlcRow.Length > 0) { DataRow nRow4 = objDs.dtSalPackUpdate.NewRow(); nRow4["SHEADID"] = 8; nRow4["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(dclNewBasicSal.ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow4); } objDs.dtSalPackUpdate.AcceptChanges(); objEmpInfoMgr.InsertEmpSalaryIncrement(lngID.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), ddlAction.SelectedItem.ToString(), strConfrimDate, Common.ReturnZeroForNull(txtCOLA.Text.Trim()), Common.ReturnZeroForNull(txtGpPer.Text.Trim()), Common.ReturnZeroForNull(txtInvPer.Text.Trim()), txtNewGrossSalary.Text.Trim(), dclNewBasicSal.ToString(), txtRemarks.Text.Trim(), txtIncrement.Text, txtNewGrossSalary.ToolTip.ToString(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value, IsDelete, lblSalPac.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.EntryMode(false); this.ClearControls(); //this.OpenRecord(); } catch (Exception ex) { lblMsg.Text = ""; throw (ex); } }
protected void btnLogin_Click(object sender, EventArgs e) { string strFiscalYear = ""; string strFiscalStartDate = ""; string userid = txtuserid.Text.ToString(); string password = txtpassword.Text.ToString(); string strInputPwd = Common.getHashValue(password); DataTable dtUser = new DataTable(); UserManager objUserMgr = new UserManager(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); dtUser = objUserMgr.SelectUserInfo(userid, "Y"); // Payroll Fiscal Year DataTable dtPayOpt = objOptMgr.SelectpaySlipOption("OC03"); if (dtPayOpt.Rows.Count > 0) { strFiscalYear = dtPayOpt.Rows[0]["OPTVALUE"].ToString().Trim(); strFiscalStartDate = dtPayOpt.Rows[0]["PAYROLLVALIDFROM"].ToString().Trim(); } if (dtUser.Rows.Count > 0) { #region user view insert delete permission string sql = "Select distinct v.ViewId,v.ViewName,v.ShowToPage,v.ParentId,up.ViewPerm,up.InsertPerm,up.DeletePerm,up.InterventionId" + ",up.HeadOfficeId,up.CCOId,up.ZoneId,up.UnitId,up.AreaId,up.BranchId,up.DistrictId,up.UpazillaId,up.ProjectId,up.GradeId,up.SectorId from ViewName v, userprivs up," + "userinfo ui where v.ViewId=up.VIEWID AND ui.USERID=up.USERID AND up.ViewPerm='Y' AND v.VIEWID<>1 AND ui.Userid='" + userid.Trim() + "' order by viewid"; DataTable dtUserPermisson = objUserMgr.Dbconnect.CreateDT(sql, "UserPermisson"); ViewPermission viewPerm = null; List <ViewPermission> viewPermList = new List <ViewPermission>(); UserAccess.Access.UserId = userid; foreach (DataRow arow in dtUserPermisson.Rows) { decimal currentPage = Convert.ToDecimal(arow["ViewId"].ToString()); decimal curIntervention = Convert.ToDecimal(arow["InterventionId"]); decimal curHeadOffice = Convert.ToDecimal(arow["HeadOfficeId"]); decimal curCCO = Convert.ToDecimal(arow["CCOId"]); decimal curZone = Convert.ToDecimal(arow["ZoneId"]); decimal curUnit = Convert.ToDecimal(arow["UnitId"]); decimal curArea = Convert.ToDecimal(arow["AreaId"]); decimal curBranch = Convert.ToDecimal(arow["BranchId"]); decimal curDistrict = Convert.ToDecimal(arow["DistrictId"]); decimal curUpazilla = Convert.ToDecimal(arow["UpazillaId"]); decimal curProject = Convert.ToDecimal(arow["ProjectId"]); decimal curGrade = Convert.ToDecimal(arow["GradeId"]); decimal curSector = Convert.ToDecimal(arow["SectorId"]); viewPerm = viewPermList.Find(x => x.PageId == currentPage); if (viewPerm == null) { viewPerm = new ViewPermission(); viewPerm.PageId = currentPage; viewPerm.InsertPerm = arow["InsertPerm"].ToString(); viewPerm.DeletePerm = arow["DeletePerm"].ToString(); viewPerm.ViewPerm = arow["ViewPerm"].ToString(); viewPerm.InterventionIds = new List <decimal?>(); viewPerm.HeadOfficeIds = new List <decimal?>(); viewPerm.CCOIds = new List <decimal?>(); viewPerm.ZoneIds = new List <decimal?>(); viewPerm.UnitIds = new List <decimal?>(); viewPerm.AreaIds = new List <decimal?>(); viewPerm.BranchIds = new List <decimal?>(); viewPerm.DistrictIds = new List <decimal?>(); viewPerm.UpazillaIds = new List <decimal?>(); viewPerm.ProjectIds = new List <decimal?>(); viewPerm.GradeIds = new List <decimal?>(); viewPerm.SectorIds = new List <decimal?>(); viewPermList.Add(viewPerm); } if (!viewPerm.InterventionIds.Exists(ii => ii == curIntervention)) { viewPerm.InterventionIds.Add(curIntervention); } if (!viewPerm.HeadOfficeIds.Exists(ii => ii == curHeadOffice)) { viewPerm.HeadOfficeIds.Add(curHeadOffice); } if (!viewPerm.CCOIds.Exists(ii => ii == curCCO)) { viewPerm.CCOIds.Add(curCCO); } if (!viewPerm.ZoneIds.Exists(ii => ii == curZone)) { viewPerm.ZoneIds.Add(curZone); } if (!viewPerm.UnitIds.Exists(ii => ii == curUnit)) { viewPerm.UnitIds.Add(curUnit); } if (!viewPerm.AreaIds.Exists(ii => ii == curArea)) { viewPerm.AreaIds.Add(curArea); } if (!viewPerm.BranchIds.Exists(ii => ii == curBranch)) { viewPerm.BranchIds.Add(curBranch); } if (!viewPerm.DistrictIds.Exists(ii => ii == curDistrict)) { viewPerm.DistrictIds.Add(curDistrict); } if (!viewPerm.UpazillaIds.Exists(ii => ii == curUpazilla)) { viewPerm.UpazillaIds.Add(curUpazilla); } if (!viewPerm.ProjectIds.Exists(ii => ii == curProject)) { viewPerm.ProjectIds.Add(curProject); } if (!viewPerm.GradeIds.Exists(ii => ii == curGrade)) { viewPerm.GradeIds.Add(curGrade); } if (!viewPerm.SectorIds.Exists(ii => ii == curSector)) { viewPerm.SectorIds.Add(curSector); } } UserAccess.Access.viewPerms = viewPermList; #endregion Session["LOGINID"] = Common.getMaxId("UserInOutHistory", "LogInId"); foreach (DataRow row in dtUser.Rows) { //if (strInputPwd != "") //{ if (string.Compare(row["Password"].ToString().Trim(), strInputPwd) == 0) { if (strInputPwd != "0") { Session["USERID"] = userid.ToString(); Session["USERNAME"] = row["FullName"].ToString(); Session["EMPID"] = row["EMPID"].ToString(); Session["EMAILID"] = row["OfficeEmail"].ToString(); Session["INTERVENIONNAME"] = row["DivisionName"].ToString(); Session["INTERVENIONID"] = row["DivisionId"].ToString(); Session["OFFICEID"] = row["OfficeId"].ToString(); Session["OFFICENAME"] = row["OfficeTitle"].ToString(); Session["SALARYLOC"] = row["SalLocId"].ToString(); Session["TEAM"] = row["DEPTNAME"].ToString(); Session["TEAMID"] = row["DEPTID"].ToString(); Session["EMPLOYEEID"] = row["EmpId"].ToString().Trim(); Session["ISADMIN"] = row["IsAdmin"].ToString().Trim(); Session["DESIGNATION"] = row["JobTitleName"].ToString().Trim(); Session["FISCALYRID"] = strFiscalYear; Session["FISCALSTARTDATE"] = strFiscalStartDate; Session["USDRATE"] = Convert.ToDouble(objPayMgr.SelectUSDRate()); objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "S", "N"); DataTable dtTaskPermission = objUserMgr.GetUserTaskPermission(Session["USERID"].ToString(), "1", "T103"); if (dtTaskPermission.Rows.Count > 0) { Response.Redirect("File/Home.aspx"); } else { Response.Redirect("Default.aspx"); } } else { Session["USERID"] = ""; Session["USERNAME"] = ""; Session["EMPID"] = ""; Session["EMAILID"] = ""; Session["INTERVENIONNAME"] = ""; Session["INTERVENIONID"] = ""; Session["OFFICEID"] = ""; Session["OFFICENAME"] = ""; Session["SALARYLOC"] = ""; Session["TEAM"] = ""; Session["TEAM"] = ""; Session["EMPLOYEEID"] = ""; Session["ISADMIN"] = ""; Session["TEAMID"] = ""; Session["DESIGNATION"] = ""; Session["ISADMIN"] = ""; Session["FISCALYRID"] = ""; Session["FISCALSTARTDATE"] = ""; Session["USDRATE"] = ""; Response.Redirect("~/index.aspx?inval=Y"); lblMsg.Text = ""; objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); this.FillOptionValue(); } } else { objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); lblMsg.Text = "Invalid User Id or Password."; } } } else { //Session["USERID"] = ""; Session["USERNAME"] = ""; Session["EMPID"] = ""; Session["EMAILID"] = ""; Session["COUNTRYDIRECTOR"] = ""; Session["INTERVENIONNAME"] = ""; Session["INTERVENIONID"] = ""; Session["OFFICEID"] = ""; Session["OFFICENAME"] = ""; Session["SALARYLOC"] = ""; //Session["PROGRAM"] = ""; //Session["PROGRAMID"] = ""; Session["TEAM"] = ""; Session["TEAMID"] = ""; Session["EMPLOYEEID"] = ""; Session["ISADMIN"] = ""; Session["ISSHIFTINCHR"] = ""; Session["DESIGNATION"] = ""; Session["LOCATION"] = ""; // Payroll Session["FISCALYRID"] = ""; Session["USERID"] = txtuserid.Text.Trim(); objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); Response.Redirect("~/index.aspx?inval=Y"); lblMsg.Text = ""; } }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); //string strSalPackId; string strTranType = ""; if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpTransitionLog", "TransId"); } string strEntryDate = ""; string strEffDate = ""; string strNextIncDate = ""; string strGradeChDate = ""; string strRetirementDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strEffDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNextIncDate.Text.Trim()) == false) { strNextIncDate = Common.ReturnDate(txtNextIncDate.Text.Trim()); } if (string.IsNullOrEmpty(txtGradeChangeDate.Text.Trim()) == false) { strGradeChDate = Common.ReturnDate(txtGradeChangeDate.Text.Trim()); } if (radPromotion.Checked == true) { strTranType = "P"; } else if (radTrans.Checked == true) { strTranType = "T"; } else if (radStatus.Checked == true) { strTranType = "C"; } else if (radEquity.Checked == true) { strTranType = "E"; } else if (radReDesig.Checked == true) { strTranType = "R"; } else if (radDeputation.Checked == true) { strTranType = "D"; } else if (radIncrement.Checked == true) { strTranType = "I"; } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; //Basic DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = Common.RoundDecimal(txtBasicSal.Text, 0); objDs.dtSalPackUpdate.Rows.Add(nRow1); //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = Common.RoundDecimal(hfHousing.Value, 0); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //PF Allowance //dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("13"); foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 8; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSal.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } objDs.dtSalPackUpdate.AcceptChanges(); clsEmpTransition objEmpTrans = new clsEmpTransition(hfId.Value.ToString(), txtEmpID.Text.Trim(), strEntryDate, strTranType, ddlAction.SelectedValue.ToString(), ddlDivision.SelectedValue.ToString(), ddlOffice.SelectedValue.ToString(), ddlDesignation.SelectedValue.ToString(), ddlJobTitle.SelectedValue.ToString(), ddlSector.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString(), ddlUnit.SelectedValue.ToString(), ddlGrade.SelectedValue.ToString(), ddlGradeLevel.SelectedValue.ToString(), ddlDivision.SelectedValue.ToString(), ddlDistrict.SelectedValue.ToString(), ddlSalaryLoc.SelectedValue.ToString(), "", ddlPostingPlace.SelectedValue.ToString(), txtBasicSal.Text.Trim(), txtGrossSalary.Text.Trim(), strEffDate, strNextIncDate, (chkIsNew.Checked == true ? "Y" : "N"), txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), ddlPosByFunction.SelectedValue.ToString(), strGradeChDate, ddlProject.SelectedValue.ToString(), ddlSupervisor.SelectedValue.ToString(), txtBankAccNo.Text.Trim()); // lblJoinDate.ToolTip contains salpakid objEmpInfoMgr.InsertEmpTransitionLog(objEmpTrans, "", hfDiv.Value.ToString(), hfOffice.Value.ToString(), hfDesig.Value.ToString(), hfJobTitle.Value.ToString(), hfSector.Value.ToString(), hfDept.Value.ToString(), hfUnit.Value.ToString(), hfGrade.Value.ToString(), hfGradeLevel.Value.ToString(), hfPostingDiv.Value.ToString(), hfPostingDist.Value.ToString(), hfSalLoc.Value.ToString(), "", hfPostingPlace.Value.ToString(), hfPosByFunction.Value.ToString(), txtBasicSal.ToolTip, txtGrossSalary.ToolTip, strEffDate, strNextIncDate, strGradeChDate, strRetirementDate, txtRemarks.Text.Trim(), hfIsUpdate.Value, lblJoinDate.ToolTip.ToString(), objDs.dtSalPackUpdate, hfProject.Value.ToString(), hfSuperId.Value.ToString(), hfBankAccNo.Value.ToString()); lblMsg.Text = "Record Saved Successfully"; this.EntryText(); this.EntryMode(false); this.ClearControls(); }
protected void btnLogin_Click(object sender, EventArgs e) { string strFiscalYear = ""; string strFiscalStartDate = ""; string userid = txtuserid.Text.ToString(); string password = txtpassword.Text.ToString(); string strInputPwd = Common.getHashValue(password); DataTable dtUser = new DataTable(); UserManager objUserMgr = new UserManager(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); dtUser = objUserMgr.SelectUserInfo(userid, "Y"); // Payroll Fiscal Year DataTable dtPayOpt = objOptMgr.SelectpaySlipOption("OC03"); if (dtPayOpt.Rows.Count > 0) { strFiscalYear = dtPayOpt.Rows[0]["OPTVALUE"].ToString().Trim(); strFiscalStartDate = dtPayOpt.Rows[0]["PAYROLLVALIDFROM"].ToString().Trim(); } if (dtUser.Rows.Count > 0) { Session["LOGINID"] = Common.getMaxId("UserInOutHistory", "LogInId"); foreach (DataRow row in dtUser.Rows) { //if (strInputPwd != "") //{ if (string.Compare(row["Password"].ToString().Trim(), strInputPwd) == 0) { if (strInputPwd != "0") { Session["USERID"] = userid.ToString(); Session["USERNAME"] = row["FullName"].ToString(); Session["EMPID"] = row["EMPID"].ToString(); Session["EMAILID"] = row["OfficeEmail"].ToString(); Session["OFFICE"] = row["DivisionName"].ToString(); Session["TEAM"] = row["DEPTNAME"].ToString(); Session["TEAMID"] = row["DEPTID"].ToString(); Session["EMPLOYEEID"] = row["EmpId"].ToString().Trim(); Session["ISADMIN"] = row["IsAdmin"].ToString().Trim(); Session["ISPAYADMIN"] = row["IsPayAdmin"].ToString().Trim(); Session["USERROLE"] = row["UserRole"].ToString().Trim(); Session["DESIGNATION"] = row["JobTitleName"].ToString().Trim(); Session["FISCALYRID"] = strFiscalYear; Session["FISCALSTARTDATE"] = strFiscalStartDate; Session["USDRATE"] = Convert.ToDouble(objPayMgr.SelectUSDRate()); objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "S", "N"); DataTable dtTaskPermission = objUserMgr.GetUserTaskPermission(Session["USERID"].ToString(), "1", "T103"); if (dtTaskPermission.Rows.Count > 0) { Response.Redirect("File/Home.aspx"); } else { Response.Redirect("Default.aspx"); } } else { Session["USERID"] = ""; Session["USERNAME"] = ""; Session["EMPID"] = ""; Session["EMAILID"] = ""; Session["OFFICE"] = ""; Session["TEAM"] = ""; Session["TEAM"] = ""; Session["EMPLOYEEID"] = ""; Session["ISADMIN"] = ""; Session["ISPAYADMIN"] = ""; Session["TEAMID"] = ""; Session["DESIGNATION"] = ""; Session["ISADMIN"] = ""; Session["FISCALYRID"] = ""; Session["FISCALSTARTDATE"] = ""; Session["USDRATE"] = ""; Response.Redirect("index.aspx?inval=Y"); lblMsg.Text = ""; objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); this.FillOptionValue(); } } else { objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); lblMsg.Text = "Invalid User Id or Password."; } } } else { //Session["USERID"] = ""; Session["USERNAME"] = ""; Session["EMPID"] = ""; Session["EMAILID"] = ""; Session["COUNTRYDIRECTOR"] = ""; Session["OFFICE"] = ""; Session["PROGRAM"] = ""; Session["OFFICEID"] = ""; Session["PROGRAMID"] = ""; Session["TEAM"] = ""; Session["TEAMID"] = ""; Session["EMPLOYEEID"] = ""; Session["ISADMIN"] = ""; Session["ISSHIFTINCHR"] = ""; Session["DESIGNATION"] = ""; Session["LOCATION"] = ""; // Payroll Session["FISCALYRID"] = ""; Session["USERID"] = txtuserid.Text.Trim(); //objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()), // Common.SetDateTime(DateTime.Now.ToString()), "U", "N"); Response.Redirect("index.aspx?inval=Y"); lblMsg.Text = ""; } }