/// <summary> /// Upload Vendor Details /// </summary> /// <param name = "data" ></ param > /// < returns ></ returns > public CommonResponse UploadVendorDetails(List <VendorEntity> data) { CommonResponse obj = new CommonResponse(); try { var check = db.UnitworkccsTblvendor.Where(m => m.IsDeleted == 0).ToList(); db.UnitworkccsTblvendor.RemoveRange(check); db.SaveChanges(); foreach (var item in data) { UnitworkccsTblvendor UnitworkccsTblvendor = new UnitworkccsTblvendor(); UnitworkccsTblvendor.Vendor = item.vendor; UnitworkccsTblvendor.VendorName = item.vendorName; UnitworkccsTblvendor.IsDeleted = 0; UnitworkccsTblvendor.CreatedOn = DateTime.Now; db.UnitworkccsTblvendor.Add(UnitworkccsTblvendor); db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.AddedSuccessMessage; } } catch (Exception e) { log.Error(e); if (e.InnerException != null) { log.Error(e.InnerException.ToString()); } obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }
/// <summary> /// AddUpdateVendorDetails /// </summary> /// <param name="data"></param> /// <returns></returns> public CommonResponse AddUpdateVendorDetails(VendorEntity data) { CommonResponse obj = new CommonResponse(); try { var check = db.UnitworkccsTblvendor.Where(m => m.VendorId == data.vendorId && m.IsDeleted == 0).FirstOrDefault(); if (check == null) { UnitworkccsTblvendor UnitworkccsTblvendordet = new UnitworkccsTblvendor(); UnitworkccsTblvendordet.Vendor = data.vendor; UnitworkccsTblvendordet.VendorName = data.vendorName; UnitworkccsTblvendordet.IsDeleted = 0; UnitworkccsTblvendordet.CreatedOn = DateTime.Now; UnitworkccsTblvendordet.CreatedBy = 1; db.UnitworkccsTblvendor.Add(UnitworkccsTblvendordet); db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.AddedSuccessMessage; } else { check.Vendor = data.vendor; check.VendorName = data.vendorName; check.ModifiedBy = 2; check.ModifiedOn = DateTime.Now; db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.UpdatedSuccessMessage; } } catch (Exception e) { log.Error(e); if (e.InnerException != null) { log.Error(e.InnerException.ToString()); } obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }