public async Task <JsonResult> EmployeeEosDelete(string empid, string projname, string sessionid)
{
System.Diagnostics.Debug.WriteLine(projname);
ViewBag.SessionID = sessionid;
if (Authenticate("AllEmployeesEos"))
{
try
{
if (empid != null && projname != null)
{
EosDataModel eosDataModel = await eosDataDbContext.EosDataDbSet.Where(model => model.empid.Equals(empid) && model.projname.Equals(projname)).FirstOrDefaultAsync();
eosDataDbContext.EosDataDbSet.Remove(eosDataModel);
await eosDataDbContext.SaveChangesAsync();
return(Json("Success"));
}
else
{
return(Json("Fail"));
}
}
catch
{
return(Json("Fail"));
}
}
return(Json("Fail"));
}
public async Task <JsonResult> EmployeeEos(List <EosDataModel> eosDataModels, string sessionid)
{
ViewBag.SessionID = sessionid;
if (Authenticate("AllEmployeesEos"))
{
currentFinancialYear = CurrentFinancialYearChecker();
try
{
if (eosDataModels != null)
{
EosDataModel oldvalues = new EosDataModel();
foreach (EosDataModel eosDataModel in eosDataModels)
{
oldvalues = eosDataDbContext.EosDataDbSet.Where(model => model.empid.Equals(eosDataModel.empid) && model.projname.Equals(eosDataModel.projname)).FirstOrDefault();
if (oldvalues != null)
{
for (int i = 0; i < 12; i++)
{
eosDataDbContext.Entry(oldvalues).Property(months[i]).CurrentValue = eosDataDbContext.Entry(eosDataModel).Property(months[i]).CurrentValue;
}
}
else
{
eosDataModel.year = currentFinancialYear;
eosDataDbContext.EosDataDbSet.Add(eosDataModel);
}
}
await eosDataDbContext.SaveChangesAsync();
return(Json("Success"));
}
}
catch
{
return(Json("Fail"));
}
}
return(Json("Fail"));
}
public async Task <JsonResult> MyEos(List <EosDataModel> eosDataModels, string sessionid)
{
ViewBag.SessionID = sessionid;
if (Authenticate("MyEos"))
{
currentFinancialYear = CurrentFinancialYearChecker();
try
{
if (eosDataModels != null)
{
EosDataModel oldvalues = new EosDataModel();
foreach (EosDataModel eosDataModel in eosDataModels)
{
oldvalues = eosDataDbContext.EosDataDbSet.Where(model => model.empid.Equals(eosDataModel.empid) && model.projname.Equals(eosDataModel.projname)).FirstOrDefault();
if (oldvalues != null) // for updation of old values
{
if (currentdate.Month >= 1 && currentdate.Month <= 3) // for Jan, Feb and Mar Financial Month
{
for (int i = (currentdate.Month) + 8; i < 12; i++) // Current Month till Mar
{
eosDataDbContext.Entry(oldvalues).Property(months[i]).CurrentValue = eosDataDbContext.Entry(eosDataModel).Property(months[i]).CurrentValue;
}
}
else
{
for (int i = (currentdate.Month) - 4; i < 12; i++)
{
eosDataDbContext.Entry(oldvalues).Property(months[i]).CurrentValue = eosDataDbContext.Entry(eosDataModel).Property(months[i]).CurrentValue;
}
}
}
else // for adding new values
{
if (currentdate.Month >= 1 && currentdate.Month <= 3) // for Jan, Feb and Mar Financial Month
{
for (int i = 0; i < (currentdate.Month) + 8; i++) // April Month till < Current Month
{
eosDataDbContext.Entry(eosDataModel).Property(months[i]).CurrentValue = 0;
}
}
else
{
for (int i = 0; i < (currentdate.Month) - 4; i++) // April Month till < Current Month
{
eosDataDbContext.Entry(eosDataModel).Property(months[i]).CurrentValue = 0;
}
}
eosDataModel.year = currentFinancialYear;
eosDataDbContext.EosDataDbSet.Add(eosDataModel);
}
}
await eosDataDbContext.SaveChangesAsync();
return(Json("Success"));
}
}
catch
{
return(Json("Fail"));
}
}
return(Json("Fail"));
}
