/// <summary> /// Create CustomerDOTNumber /// </summary> /// <param name="model"></param> /// <returns></returns> public CustomerDOTNumberDTO CreateCustomerDOTNumber(CustomerDOTNumber model) { if (IsActiveProfile) { var CDOTNumber = context.CustomerDOTNumbers.Where(o => o.DOTNumber == model.DOTNumber && o.CustomerID == model.CustomerID) .Select(x => new CustomerDOTNumberDTO { ItemID = x.ItemID, DOTNumber = x.DOTNumber, DOTTag = x.DOTTag, CustomerID = x.CustomerID, CreatedOn = x.CreatedOn, ModifiedOn = x.ModifiedOn, IsActive = x.IsActive, CreatedBy = x.CreatedBy, ModifiedBy = x.ModifiedBy }).FirstOrDefault(); if (CDOTNumber == null) { var customerDOT = new CustomerDOTNumber { CustomerID = model.CustomerID, DOTNumber = CommonFunctions.Trimstring(model.DOTNumber), DOTTag = CommonFunctions.Trimstring(model.DOTTag), IsActive = true, CreatedOn = DateTime.Now, CreatedBy = model.CreatedBy, ModifiedBy = model.CreatedBy, ModifiedOn = DateTime.Now, IsDelete = false }; context.CustomerDOTNumbers.Add(customerDOT); context.SaveChanges(); var CustomerDOT = new CustomerDOTNumberDTO { ItemID = customerDOT.ItemID, DOTNumber = customerDOT.DOTNumber, DOTTag = customerDOT.DOTTag, CustomerID = customerDOT.CustomerID, CreatedOn = customerDOT.CreatedOn, ModifiedOn = customerDOT.ModifiedOn, IsActive = customerDOT.IsActive, CreatedBy = customerDOT.CreatedBy, ModifiedBy = customerDOT.ModifiedBy }; return(CustomerDOT); } else { return(CDOTNumber); } } return(null); }
/// <summary> /// Update CustomerDOTNumber /// </summary> /// <param name="model"></param> /// <param name="RoleName"></param> /// <returns></returns> public CustomerDOTNumberDTO UpdateCustomerDOTNumber(CustomerDOTNumber model) { if (IsActiveProfile) { var CDOTNumber = context.CustomerDOTNumbers.Where(o => o.ItemID == model.ItemID && o.CustomerID == model.CustomerID).FirstOrDefault(); if (CDOTNumber != null) { if (CDOTNumber.DOTNumber == model.DOTNumber) { CDOTNumber.DOTTag = CommonFunctions.Trimstring(model.DOTTag); CDOTNumber.IsActive = model.IsActive; CDOTNumber.ModifiedOn = DateTime.Now; CDOTNumber.ModifiedBy = model.ModifiedBy; context.SaveChanges(); } else { //New Dot data Update if (!context.CustomerDOTNumbers.Where(o => o.DOTNumber == model.DOTNumber).Any()) { CDOTNumber.DOTNumber = model.DOTNumber; CDOTNumber.DOTTag = CommonFunctions.Trimstring(model.DOTTag); CDOTNumber.IsActive = model.IsActive; CDOTNumber.ModifiedOn = DateTime.Now; CDOTNumber.ModifiedBy = model.ModifiedBy; context.SaveChanges(); } else { return(null); } } var CustomerDOT = new CustomerDOTNumberDTO { ItemID = CDOTNumber.ItemID, DOTNumber = CDOTNumber.DOTNumber, DOTTag = CDOTNumber.DOTTag, CustomerID = CDOTNumber.CustomerID, CreatedOn = CDOTNumber.CreatedOn, ModifiedOn = CDOTNumber.ModifiedOn, IsActive = CDOTNumber.IsActive, CreatedBy = CDOTNumber.CreatedBy, ModifiedBy = CDOTNumber.ModifiedBy }; return(CustomerDOT); } else { return(null); } } return(null); }