private int DeleteSalaryApprovalDetail(TblSalaryApprovalDetail row, int userIserial, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var oldRow = (from e in context.TblSalaryApprovalDetails where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); context.SaveChanges(); } } return(row.Iserial); }
private TblSalaryApprovalDetail UpdateOrInsertSalaryApprovalDetail( TblSalaryApprovalDetail newRow, int userIserial, int index, out int outindex, string company) { outindex = index; using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { var oldRow = (from e in context.TblSalaryApprovalDetails where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { var result = SharedOperation.GenericUpdate(oldRow, newRow, context); } else { context.TblSalaryApprovalDetails.AddObject(newRow); } context.SaveChanges(); return(newRow); } }
private void ImportSalaryApproval(List <TblSalaryApprovalHeader> List, int userIserial, string company) { using (var context = new ccnewEntities(SharedOperation.GetSqlConnectionString(company))) { foreach (var item in List) { var store = 0; var salarytype = 0; try { store = context.TblStores.FirstOrDefault(w => w.code == item.TblStore1.code).iserial; salarytype = context.TblSalaryTypes.FirstOrDefault(w => w.EName == item.TblSalaryType1.EName).Iserial; } catch (Exception) { continue; } item.TblStore1 = null; item.TblSalaryType1 = null; var headerRow = context.TblSalaryApprovalHeaders.FirstOrDefault(w => w.Code == item.Code && w.TblStore == store && w.Month == item.Month && w.Year == item.Year && w.TblSalaryType == salarytype); if (headerRow == null) { var newHeader = new TblSalaryApprovalHeader() { Month = item.Month, TblSalaryType = salarytype, TblStore = store, Year = item.Year, TblUser = 0, VotDate = DateTime.Now, CreationDate = DateTime.Now, HQApproved = true, StoreApproved = false, Code = item.Code, DueDate = item.DueDate }; newHeader.TblSalaryApprovalDetails = new System.Data.Objects.DataClasses.EntityCollection <TblSalaryApprovalDetail>(); headerRow = newHeader; } foreach (var SalaryDetail in item.TblSalaryApprovalDetails) { var empcode = SalaryDetail.TblEmployee.ToString(); try { var Employee = context.TblEmployees.FirstOrDefault(e => e.code == empcode).iserial; var newDetail = new TblSalaryApprovalDetail() { Approved = false, CreationDate = DateTime.Now, Salary = SalaryDetail.Salary, TblEmployee = Employee, }; headerRow.TblSalaryApprovalDetails.Add(newDetail); } catch (Exception) { continue; } } if (headerRow.Iserial == 0) { context.TblSalaryApprovalHeaders.AddObject(headerRow); } } context.SaveChanges(); } }