private EmpLeavingTransaction UpdateOrInsertEmpLeavingTransaction(EmpLeavingTransaction newRow, bool save, int index, int user, out int outindex) { outindex = index; using (var context = new TimeAttEntities()) { if (save) { newRow.CreationBy = user; newRow.CreationDate = DateTime.Now; context.EmpLeavingTransactions.AddObject(newRow); } else { var oldRow = (from e in context.EmpLeavingTransactions where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private int DeleteTblEmployeeShift(TblEmployeeShift row) { if (!Att.AttService.EmpCanEdit(row.TransDate, row.EmpId)) { throw new Exception("Cannot edit a transaction because this period is already closed"); } using (var context = new TimeAttEntities()) { var oldRow = (from e in context.TblEmployeeShifts.Include("TblEmployeeShiftLookup1") where e.EmpId == row.EmpId && e.TransDate == row.TransDate select e).SingleOrDefault(); if (oldRow != null) { //if (oldRow.Status == 1) //{ // var srv = new EmployeePayrollServiceClient(); // srv.DeleteEmpCalendarDeviation(row.EmpId, row.TransDate, oldRow.TblEmployeeShiftLookup1.CalendarId); //} context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
public TblEmployeeShift UpdateAndInsertTblEmployeeShift(TblEmployeeShift row, int index, int userIserial, out int outindex) { if (!Att.AttService.EmpCanEdit(row.TransDate, row.EmpId)) { throw new Exception("Cannot edit a transaction because this period is already closed"); } outindex = index; IEnumerable <string> changedList = null; bool save = row.Iserial == 0; using (var db = new TimeAttEntities()) { var oldRow = (from e in db.TblEmployeeShifts where e.EmpId == row.EmpId && e.TransDate == row.TransDate select e).SingleOrDefault(); if (oldRow != null) { if (row.CreationDate == DateTime.MinValue) { row.CreatedBy = userIserial; row.CreationDate = DateTime.Now; } row.CreatedBy = userIserial; row.Iserial = oldRow.Iserial; changedList = GenericUpdate(oldRow, row, db); } else { row.CreatedBy = userIserial; row.CreationDate = DateTime.Now; db.TblEmployeeShifts.AddObject(row); } if (row.Status == 1) { // var srv = new EmployeePayrollServiceClient(); // var listOfEmployeeShifts = new List<ServiceReference1.TblEmployeeShift> //{ // new ServiceReference1.TblEmployeeShift().InjectFrom(row) as ServiceReference1.TblEmployeeShift //}; // try // { // if (listOfEmployeeShifts.Count != 0) // { // srv.InsertEmpCalendarDeviation(listOfEmployeeShifts); // } // } // catch (Exception) // { // } } db.SaveChanges(); } return(row); }
private int DeleteTblPeriodLock(TblPeriodLock row) { using (var context = new TimeAttEntities()) { var oldRow = (from e in context.TblPeriodLocks where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
private int DeleteEmpLeavingTransaction(EmpLeavingTransaction row) { using (var context = new TimeAttEntities()) { var oldRow = (from e in context.EmpLeavingTransactions where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
private int DeleteTblVariableTermManual(Model.TblVariableTermManual row) { using (var context = new TimeAttEntities()) { var oldRow = (from e in context.TblVariableTermManuals where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
public List <TblEmployeeShift> UpdateAndInsertTblEmployeeShiftList(List <TblEmployeeShift> newList) { using (var db = new TimeAttEntities()) { foreach (var row in newList) { var oldRow = (from e in db.TblEmployeeShifts where e.EmpId == row.EmpId && e.TransDate == row.TransDate select e).SingleOrDefault(); if (oldRow != null) { row.Iserial = oldRow.Iserial; GenericUpdate(oldRow, row, db); } else { db.TblEmployeeShifts.AddObject(row); } db.SaveChanges(); } //var srv = new EmployeePayrollServiceClient(); //var listOfEmployeeShifts = new List<ServiceReference1.TblEmployeeShift>(); //foreach (var row in newList.Where(x => x.Status == 1)) //{ // listOfEmployeeShifts.Add(new ServiceReference1.TblEmployeeShift().InjectFrom(row) as ServiceReference1.TblEmployeeShift); //} //try //{ // if (listOfEmployeeShifts.Count != 0) // { // srv.InsertEmpCalendarDeviation(listOfEmployeeShifts); // } //} //catch (Exception) //{ // throw; //} return(newList); } }
private TblPeriodLock UpdateOrInsertTblPeriodLock(TblPeriodLock newRow, bool save, int index, out int outindex) { outindex = index; using (var context = new TimeAttEntities()) { if (save) { context.TblPeriodLocks.AddObject(newRow); } else { var oldRow = (from e in context.TblPeriodLocks where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { Operations.SharedOperation.GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private TblEmployeeBehalf UpdateOrInsertTblEmployeeBehalf(TblEmployeeBehalf newRow, bool save, int index, out int outindex) { outindex = index; using (var context = new TimeAttEntities()) { if (save) { context.TblEmployeeBehalves.AddObject(newRow); } else { var oldRow = (from e in context.TblEmployeeBehalves where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private FingerPrintTransaction UpdateOrInsertFingerPrintTransaction(FingerPrintTransaction newRow, bool save, int index, out int outindex) { outindex = index; using (var context = new TimeAttEntities()) { if (save) { context.FingerPrintTransactions.AddObject(newRow); } else { var oldRow = (from e in context.FingerPrintTransactions where e.GlSerial == newRow.GlSerial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private Model.TblVariableTermManual UpdateOrInsertTblVariableTermManual(Model.TblVariableTermManual newRow, bool save, int index, out int outindex) { var oldRow = new Model.TblVariableTermManual(); outindex = index; using (var context = new TimeAttEntities()) { if (save) { context.TblVariableTermManuals.AddObject(newRow); } else { oldRow = (from e in context.TblVariableTermManuals where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); var srv = new EmployeePayrollServiceClient(); //newRow var row = new ServiceReference1.TblVariableTermManual(); row.InjectFrom(newRow); srv.InsertVariableTerm(row, row); var selectedTerm = context.TblSalaryTerms.FirstOrDefault(w => w.Iserial == newRow.TermId).Ename; using (PayrollEntities payrolldb = new PayrollEntities()) { if (oldRow != null) { deletePayrollVr(payrolldb, oldRow, selectedTerm); } var emp = payrolldb.TblEmployeePayrolls.FirstOrDefault(w => w.EmpId == newRow.Emplid); var period = getPeriodByOrganizationUnit(emp.TblOrganizationUnit ?? 0, payrolldb).Iserial; var periodline = payrolldb.TblPeriodLines.FirstOrDefault(x => x.FromDate <= newRow.TransDate && x.ToDate >= newRow.TransDate && x.TblPeriod == period); var exType = payrolldb.PayrollTblSalaryTerms.FirstOrDefault(w => w.Ename == selectedTerm).Iserial; if (emp != null && exType != null) { var ExToInsert = new PayrollTblVariableTermManual() { TblEmployee = emp.Iserial, TblSalaryTerm = exType, Hours = newRow.Hours, AmountCUR = 0, AttHours = 0, AttType = "0", ExcuseTransRECId = null, OldAmount = 0, TblAttendaceFile = null, TblCalculated = 0, TblCurrency = null, TblPenalty = null, TransDate = newRow.TransDate, FromAtt = false, TblPeriodLine = periodline.Iserial, }; payrolldb.PayrollTblVariableTermManuals.AddObject(ExToInsert); } payrolldb.SaveChanges(); } return(newRow); } }