private void GetSalaryIncrementLog()
{
DESIGNATION_BLL objDeg_BLL = new DESIGNATION_BLL();
SalaryIncrementBLL _salaryIncrementBll = new SalaryIncrementBLL();
try
{
string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
List <HRM_SalaryIncrement> salaryIncrements = _salaryIncrementBll.GetSalaryIncrementLog(OCODE);
DateTime serverDate = _salaryIncrementBll.GetServerDate();
List <HRM_PersonalInformations> personalInfoes = _salaryIncrementBll.GetAllEmployess(OCODE);
List <HRM_DESIGNATIONS> designationes = _salaryIncrementBll.GetAllDesgination(OCODE);
List <SalaryIncrementR> slaryIncrementRes = new List <SalaryIncrementR>();
foreach (HRM_SalaryIncrement aitem in salaryIncrements)
{
if (serverDate >= aitem.EffectiveDate)
{
SalaryIncrementR _salaryIncrementR = new SalaryIncrementR();
int? desId = personalInfoes.Where(x => x.EID == aitem.EID).FirstOrDefault().DesginationId;
string desName = designationes.Where(x => x.DEG_ID == desId).FirstOrDefault().DEG_NAME;
string grade = designationes.Where(x => x.DEG_ID == desId).FirstOrDefault().GRADE;
decimal?Gosssalary = aitem.IncrementSalary; //designationes.Where(x => x.DEG_ID == desId).FirstOrDefault().GROSS_SAL;
bool Status = CheckDesignation(desName, grade, Gosssalary);
if (Status == false)
{
InsertDesgination(desName, grade, Gosssalary);
}
HRM_DESIGNATIONS _Desobj = objDeg_BLL.GetDesignationIdByDesNameGradAndGoss(desName, grade, Gosssalary);
if (_Desobj != null)
{
_salaryIncrementR.Eid = aitem.EID;
_salaryIncrementR.IncrementDate = aitem.IncrementDate;
_salaryIncrementR.Grade = grade;
_salaryIncrementR.SalaryIncrementStatus = "Salary Increment";
_salaryIncrementR.EffectiveDate = aitem.EffectiveDate;
_salaryIncrementR.previousSalary = aitem.previousSalary;
_salaryIncrementR.Slary = Convert.ToDecimal(aitem.IncrementSalary);
_salaryIncrementR.DesId = _Desobj.DEG_ID;
_salaryIncrementR.Ocode = ((SessionUser)Session["SessionUser"]).OCode;
_salaryIncrementR.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
_salaryIncrementR.EDIT_DATE = DateTime.Now;
slaryIncrementRes.Add(_salaryIncrementR);
}
}
}
if (slaryIncrementRes.Count > 0)
{
int result = _salaryIncrementBll.AutomaticSalaryUpdate(slaryIncrementRes);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void btnTrStaffSubmit_Click(object sender, EventArgs e)
{
try
{
HRM_EMP_TRANSFER objTrns = new HRM_EMP_TRANSFER();
string employeeID = Convert.ToString(txtEid_TRNS.Text);
string desName = drpdwnDesigantion.SelectedItem.ToString();
string grade = txtbxGarde.Text;
decimal? Gosssalary = Convert.ToDecimal(txtbxGrossSalary.Text);
bool Status = CheckDesignation(desName, grade, Gosssalary);
if (Status == false)
{
InsertDesgination(desName, grade, Gosssalary);
}
decimal PreviousGrossSalary = 0;
HRM_DESIGNATIONS _Desobj = objDeg_BLL.GetDesignationIdByDesNameGradAndGoss(desName, grade, Gosssalary);
if (_Desobj != null)
{
int regID_TO = Convert.ToInt32(ddlRegion_TR.SelectedValue);
int ofcID_TO = Convert.ToInt32(ddlOffice_TR.SelectedValue);
int deptID_TO = Convert.ToInt32(ddlDepartment_TR.SelectedValue);
int sectionID_TO = Convert.ToInt32(ddlSection_TR.SelectedValue);
int subSecID_TO = Convert.ToInt32(ddlSubSec_TR.SelectedValue);
//-------------------From-------------------------------
objTrns.Regions_ID_FROM = Convert.ToInt32(lblRegion_TRNS.Text);
objTrns.Office_ID_FROM = Convert.ToInt32(lblOffice_TRNS.Text);
objTrns.DPT_ID_FROM = Convert.ToInt32(lblDepartment_TRNS.Text);
objTrns.SEC_ID_FROM = Convert.ToInt32(lblSection_TRNS.Text);
objTrns.SUB_SEC_ID_FROM = Convert.ToInt32(lblSubSection_TRNS.Text);
objTrns.DEG_ID_FROM = Convert.ToInt32(lblDesignation_TRNS.Text);
objTrns.GrossSalaryFrom = Convert.ToDecimal(lblStepGrossSalary.Text);
objTrns.GradeFrom = lblGrade_TRNS.Text;
PreviousGrossSalary = Convert.ToDecimal(objTrns.GrossSalaryFrom);
//-------------------to-------------------------------
objTrns.Regions_ID_TO = regID_TO;
objTrns.Office_ID_TO = ofcID_TO;
objTrns.DPT_ID_TO = deptID_TO;
objTrns.SEC_ID_TO = sectionID_TO;
objTrns.SUB_SEC_ID_TO = subSecID_TO;
objTrns.DEG_ID_TO = _Desobj.DEG_ID;
objTrns.GradeTo = _Desobj.GRADE;
objTrns.GorssSalaryTo = _Desobj.GROSS_SAL;
objTrns.Status = hidTransferStatus.Value.ToString();
objTrns.EID = employeeID;
objTrns.TRANSFER_DATE = DateTime.Now.Date;
objTrns.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
objTrns.EDIT_DATE = DateTime.Now;
objTrns.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
}
int result = objAdm_BLL.SaveEmployee_Transfer(objTrns, employeeID, PreviousGrossSalary);
if (result == 1)
{
BindGridEmployeeTransfer();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
