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);
}
}
private void UpdatePersonalInfoForEffectiveDate(SalaryIncrementR aitem)
{
HRM_PersonalInformations _personalInformations = _context.HRM_PersonalInformations.Where(x => x.EID == aitem.Eid).FirstOrDefault();
_personalInformations.Salary = aitem.Slary;
_personalInformations.DesginationId = aitem.DesId;
_personalInformations.Grade = aitem.Grade;
_personalInformations.EffectiveSalaryStatus = true;
_context.SaveChanges();
}
private void UpdateSlaryIncrementLog(SalaryIncrementR aitem)
{
try
{
HRM_SalaryIncrement _salaryIncrementLog = _context.HRM_SalaryIncrement.Where(x => x.EID == aitem.Eid && x.ApprovedStatus == false).FirstOrDefault();
_salaryIncrementLog.ApprovedStatus = true;
_context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
private void UpdatePersonalInfo(SalaryIncrementR aitem)
{
try
{
HRM_PersonalInformations _personalInformations = _context.HRM_PersonalInformations.Where(x => x.EID == aitem.Eid).FirstOrDefault();
_personalInformations.Salary = aitem.Slary;
_personalInformations.DesginationId = aitem.DesId;
_personalInformations.Grade = aitem.Grade;
_context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
private void InsertSalaryIncrement(SalaryIncrementR aitem)
{
try
{
HRM_SalaryIncrementSLog _slaryIncrementlog = new HRM_SalaryIncrementSLog();
_slaryIncrementlog.EID = aitem.Eid;
_slaryIncrementlog.SalaryIncrementStatus = aitem.SalaryIncrementStatus;
_slaryIncrementlog.previousSalary = aitem.previousSalary;
_slaryIncrementlog.IncrementDate = aitem.IncrementDate;
_slaryIncrementlog.EffectiveDate = aitem.EffectiveDate;
_slaryIncrementlog.IncrementSalary = aitem.Slary;
_slaryIncrementlog.OCODE = aitem.Ocode;
_slaryIncrementlog.EDIT_DATE = aitem.EDIT_DATE;
_slaryIncrementlog.EDIT_USER = aitem.EDIT_USER;
_context.HRM_SalaryIncrementSLog.AddObject(_slaryIncrementlog);
_context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
