public bool Delete([FromBody] TblEmployeeMaster employee) { try { this._repoWrapper.Employee.Delete(employee); this._repoWrapper.Employee.Save(); return(true); } catch (Exception e) { return(false); } }
public bool Add([FromBody] TblEmployeeMaster employee) { try { this._repoWrapper.Employee.Create(employee); this._repoWrapper.Employee.Save(); this._repoWrapper.Employee.SaveLoginDetails(employee); this._repoWrapper.Employee.Save(); return(true); } catch (Exception e) { return(false); } }
public static string UpdateEmployeeList(List <EmployeeMasterModel> list) { using (var context = new SalesReturndbEntities()) { using (TransactionScope transaction = new TransactionScope()) { List <EmployeeMasterModel> lst = new List <EmployeeMasterModel>(); foreach (var obj in list) { var duplicateCheck = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.Id == obj.Id).FirstOrDefault(); if (duplicateCheck != null) { var check = lst.Where(x => x.IsActive == true && x.DepotName == obj.DepotName).FirstOrDefault(); if (check == null) { //update duplicateCheck.DepotName = obj.DepotName; duplicateCheck.CommercialCode = obj.CommercialCode; duplicateCheck.CommercialHead = obj.CommercialHead; duplicateCheck.ComplaintHandler = obj.ComplaintHandler; duplicateCheck.ComplaintManager = obj.ComplaintManager; duplicateCheck.CSO = obj.CSO; duplicateCheck.Depotcode = obj.Depotcode; duplicateCheck.ISC = obj.ISC; duplicateCheck.LogisticsHead = obj.LogisticsHead; duplicateCheck.ModifiedBy = obj.CreatedBy; duplicateCheck.ModifiedDate = DateTime.Now; context.Entry(duplicateCheck).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); lst.Add(obj); } else { return("Duplicate value not allowed"); } } else { var duplicateCheck1 = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.DepotName == obj.DepotName).FirstOrDefault(); if (duplicateCheck1 == null) { //new entry TblEmployeeMaster ReasonMaster = new TblEmployeeMaster() { DepotName = obj.DepotName, CommercialCode = obj.CommercialCode, CommercialHead = obj.CommercialHead, ComplaintHandler = obj.ComplaintHandler, ComplaintManager = obj.ComplaintManager, CSO = obj.CSO, Depotcode = obj.Depotcode, ISC = obj.ISC, LogisticsHead = obj.LogisticsHead, IsActive = true, CreatedBy = obj.CreatedBy, CreatedDate = DateTime.Now, }; context.Entry(ReasonMaster).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); lst.Add(obj); } else { return("Duplicate value not allowed"); } } } transaction.Complete(); transaction.Dispose(); } return("Success : succssfully saved"); } }
public IEnumerable <ViewStockDetails> GetDatewiseExpencesDetails([FromBody] TblEmployeeMaster master) { var Product = this._repoWrapper.Product.GetDatewiseExpencesDetails(master); return(Product); }