/*
* Admin - 1
* Research - 2
* IT Dev't/IE - 3
* IT Infra - 4
*
* Single - 1
* Married - 2
*
* Date: MM/DD/YYYY
*
* Jan - 1
* Feb - 2
* Mar - 3
* Apr - 4
* May - 5
* Jun - 6
* Jul - 7
* Aug - 8
* Sep - 9
* Oct - 10
* Nov - 11
* Dec - 12
*
* new AdditionalInfo() { IDNO = "10", Gender = "ale", Email = "@Savvysherpa.com", HireDate = "//", RegularizationDate = "//", DepartmentID = "", CivilStatusID = ""},
*
* */
public bool InsertLeaveCredit(LeaveCreditModel model)
{
using(DataContext _context = new DataContext())
{
int _rowsAffected = _context.Database.ExecuteSqlCommand("pInsertLeaveCredit @xIDNO, @xLeaveType, @xBeginningDate, @xCutOffDate, " +
"@xCreditsAtCutOffInDays, @xCreditsAtCutOffInMonths, @xLeaveCreditsPerMonth, " +
"@xUnusedLeavesDays, @xUnusedLeavesHours, @xLessLeaveAvailmentHours, @xConvertibleLeavesHours",
new SqlParameter("@xIDNO", model.IDNO),
new SqlParameter("@xLeaveType", model.LeaveType),
new SqlParameter("@xBeginningDate", model.BeginningDate),
new SqlParameter("@xCutOffDate", model.CutOffDate),
new SqlParameter("@xCreditsAtCutOffInDays", model.CreditsAtCutOffInDays),
new SqlParameter("@xCreditsAtCutOffInMonths", model.CreditsAtCutOffInMonths),
new SqlParameter("@xLeaveCreditsPerMonth", model.LeaveCreditsPerMonth),
new SqlParameter("@xUnusedLeavesDays", model.UnusedLeavesDays),
new SqlParameter("@xUnusedLeavesHours", model.UnusedLeavesHours),
new SqlParameter("@xLessLeaveAvailmentHours", model.LessLeaveAvailmentHours),
new SqlParameter("@xConvertibleLeavesHours", model.ConvertibleLeavesHours));
_context.Database.Connection.Close();
_context.Database.Connection.Dispose();
if(_rowsAffected == 1)
{
return true;
}
}
return false;
}
public ActionResult InsertLeaveCredit()
{
BLLLeave _leave = new BLLLeave();
LeaveCreditModel model = new LeaveCreditModel();
//int[] idnos = {10001, 10002, 10003, 10004, 10005, 10006, 10007, 10009, 10012, 10014, 10016, 10018, 10020, 10023, 10025,
// 10027, 10028, 10029, 10030, 10032, 10033, 10035, 10038, 10042, 10043, 10047, 10051, 10054, 10057, 10058, 10059,
// 10060, 10061, 10062, 10063, 10064, 10065, 10067, 10069, 10070, 10071, 10074, 10075, 10076, 10077, 10081,
// 10083, 10084, 10085, 10086, 10087, 10090, 10091, 10092, 10093, 10094, 10095, 10096, 10099, 10101, 10102, 10103, 10104,
// 10105, 10106, 10107, 10108, 10109, 10111, 10112, 10113, 10114, 10115, 10116, 10117, 10118, 10119, 10120, 10121, 10122,
// 10123, 10124, 10125, 10126, 10127, 10128, 10129, 10130, 10131, 10132, 10133, 10134};
var idnos = _leave.GetIDNOs();
foreach (string idno in idnos)
{
model.IDNO = Convert.ToInt32(idno);
model.HireDate = _leave.GetHireDate(idno);
model.LeaveType = 1;
_leave.InsertLeaveCredit(model);
model.LeaveType = 3;
_leave.InsertLeaveCredit(model);
}
//if (_leave.InsertLeaveCredit(model))
//{
// TempData["insertLeaveCredit_result"] = "LeaveCredit information was added.";
//}
return View();
}
public bool InsertLeaveCredit(LeaveCreditModel model)
{
DALLeave _leave = new DALLeave();
model.BeginningDate = CalculateBeginningDate(model.HireDate);
model.CutOffDate = new DateTime(2016, 11, 30);
model.CreditsAtCutOffInDays = Days360.CalculateDays360(model.BeginningDate, model.CutOffDate);
model.CreditsAtCutOffInMonths = (float)model.CreditsAtCutOffInDays / 30f;
float _creditsPerMonth = CalculateCreditsPerMonth(model.IDNO, model.LeaveType);
model.LeaveCreditsPerMonth = _creditsPerMonth / 12f;
model.UnusedLeavesDays = model.CreditsAtCutOffInMonths * model.LeaveCreditsPerMonth;
model.UnusedLeavesHours = model.UnusedLeavesDays * 8f;
model.LessLeaveAvailmentHours = 0;
model.ConvertibleLeavesHours = model.UnusedLeavesHours - model.LessLeaveAvailmentHours;
return _leave.InsertLeaveCredit(model);
}