/// <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);
}
