public void Update(DockMilkCollectionDtl dockMilkCollectionDtl)
{
if (dockMilkCollectionDtl != null)
{
_repository.Entry <Sql.DockMilkCollectionDtl>(dockMilkCollectionDtl).State = System.Data.Entity.EntityState.Modified;
// _repository.SaveChanges();
}
}
public void Add(DockMilkCollectionDtl dockMilkCollectionDtl)
{
if (dockMilkCollectionDtl != null)
{
_repository.DockMilkCollectionDtls.Add(dockMilkCollectionDtl);
// _repository.SaveChanges();
}
}
public static void ConvertToDockMilkCollectionDtlEntity(ref DockMilkCollectionDtl DockMilkCollectionDtl, DockMilkCollectionDtlDTO DockMilkCollectionDtlDTO, bool isUpdate)
{
if (isUpdate)
{
DockMilkCollectionDtl.DockMilkCollectionDtlI = DockMilkCollectionDtlDTO.DockMilkCollectionDtlId;
}
if (DockMilkCollectionDtlDTO.CLR > 0)
{
DockMilkCollectionDtl.CLR = DockMilkCollectionDtlDTO.CLR;
}
if (DockMilkCollectionDtlDTO.FAT > 0)
{
DockMilkCollectionDtl.FAT = DockMilkCollectionDtlDTO.FAT;
}
if (DockMilkCollectionDtlDTO.Quantity > 0)
{
DockMilkCollectionDtl.Quantity = DockMilkCollectionDtlDTO.Quantity;
}
if (DockMilkCollectionDtlDTO.RejectedQuantity > 0)
{
DockMilkCollectionDtl.RejectedQuantity = DockMilkCollectionDtlDTO.RejectedQuantity;
}
if (DockMilkCollectionDtlDTO.TotalCan > 0)
{
DockMilkCollectionDtl.TotalCan = DockMilkCollectionDtlDTO.TotalCan;
}
if (DockMilkCollectionDtlDTO.TotalRejectedCan > 0)
{
DockMilkCollectionDtl.TotalRejectedCan = DockMilkCollectionDtlDTO.TotalRejectedCan;
}
DockMilkCollectionDtl.ProductId = (int)DockMilkCollectionDtlDTO.ProductId;
DockMilkCollectionDtl.TotalAmount = DockMilkCollectionDtlDTO.TotalAmount;
if (string.IsNullOrWhiteSpace(DockMilkCollectionDtlDTO.Comments) == false)
{
DockMilkCollectionDtl.Comments = DockMilkCollectionDtlDTO.Comments;
}
if (string.IsNullOrWhiteSpace(DockMilkCollectionDtlDTO.RejectedReason) == false)
{
DockMilkCollectionDtl.RejectedReason = DockMilkCollectionDtlDTO.RejectedReason;
}
}
public static DockMilkCollectionDtlDTO ConvertToDockMilkCollectionDtlDTO(DockMilkCollectionDtl dockMilkCollectionDtl)
{
DockMilkCollectionDtlDTO dockMilkCollectionDtlDTO = new DockMilkCollectionDtlDTO();
dockMilkCollectionDtlDTO.DockMilkCollectionDtlId = dockMilkCollectionDtl.DockMilkCollectionDtlI;
dockMilkCollectionDtlDTO.CLR = dockMilkCollectionDtl.CLR.GetValueOrDefault();
dockMilkCollectionDtlDTO.FAT = dockMilkCollectionDtl.FAT.GetValueOrDefault();
dockMilkCollectionDtlDTO.Quantity = dockMilkCollectionDtl.Quantity.GetValueOrDefault();
dockMilkCollectionDtlDTO.TotalAmount = dockMilkCollectionDtl.TotalAmount.GetValueOrDefault();
dockMilkCollectionDtlDTO.ProductId = (MilkTypeEnum)dockMilkCollectionDtl.ProductId;
dockMilkCollectionDtlDTO.Comments = dockMilkCollectionDtl.Comments;
dockMilkCollectionDtlDTO.RatePerUnit = dockMilkCollectionDtl.RatePerUnit.GetValueOrDefault();
dockMilkCollectionDtlDTO.RejectedQuantity = dockMilkCollectionDtl.RejectedQuantity.GetValueOrDefault();
dockMilkCollectionDtlDTO.RejectedReason = dockMilkCollectionDtl.RejectedReason;
dockMilkCollectionDtlDTO.TotalCan = dockMilkCollectionDtl.TotalCan.HasValue ? dockMilkCollectionDtl.TotalCan.Value : 0;
dockMilkCollectionDtlDTO.TotalRejectedCan = dockMilkCollectionDtl.TotalRejectedCan.GetValueOrDefault();
dockMilkCollectionDtlDTO.Amount = dockMilkCollectionDtl.Amount;
dockMilkCollectionDtlDTO.Commission = dockMilkCollectionDtl.Commission;
return(dockMilkCollectionDtlDTO);
}
public ResponseDTO AddDockMilkCollection(DockMilkCollectionDTO dockMilkCollectionDTO)
{
var vlc = unitOfWork.VLCRepository.GetById(dockMilkCollectionDTO.VLCId);
if (vlc != null)
{
ResponseDTO responseDTO = new ResponseDTO();
decimal milkCommission = GetCommissionForDockMilkCollection(vlc);
DockMilkCollection dockMilkCollection = new DockMilkCollection();
dockMilkCollection.DockMilkCollectionId = unitOfWork.DashboardRepository.NextNumberGenerator("DockMilkCollection");
if (dockMilkCollectionDTO.CollectionDateTime != DateTime.MinValue)
{
dockMilkCollection.CollectionDateTime = dockMilkCollectionDTO.CollectionDateTime;
}
else
{
dockMilkCollection.CollectionDateTime = DateTimeHelper.GetISTDateTime();
}
dockMilkCollection.CreatedDate = DateTimeHelper.GetISTDateTime();
dockMilkCollection.ModifiedDate = DateTimeHelper.GetISTDateTime();
dockMilkCollection.CreatedBy = dockMilkCollectionDTO.ModifiedBy = "Admin";
dockMilkCollection.IsDeleted = false;
DockMilkCollectionConvertor.ConvertToDockMilkCollectionEntity(ref dockMilkCollection, dockMilkCollectionDTO, false);
if (dockMilkCollectionDTO.dockMilkCollectionList != null)
{
foreach (var dockMilkCollectionDtlDto in dockMilkCollectionDTO.dockMilkCollectionList)
{
if (dockMilkCollectionDtlDto.Quantity > 0 && dockMilkCollectionDtlDto.ProductId > 0)
{
this.CheckForExistingCollectionDetailByDateShiftProduct(dockMilkCollection.CollectionDateTime.Date, dockMilkCollection.ShiftId, (int)dockMilkCollectionDtlDto.ProductId, dockMilkCollection.VLCId);
DockMilkCollectionDtl dockMilkCollectionDtl = new DockMilkCollectionDtl();
dockMilkCollectionDtl.DockMilkCollectionDtlI = unitOfWork.DashboardRepository.NextNumberGenerator("DockMilkCollectionDtl");
dockMilkCollectionDtl.DockMilkCollectionId = dockMilkCollection.DockMilkCollectionId;
DockMilkCollectionConvertor.ConvertToDockMilkCollectionDtlEntity(ref dockMilkCollectionDtl, dockMilkCollectionDtlDto, false);
dockMilkCollectionDtl.RatePerUnit = unitOfWork.MilkRateRepository.GetMilkRateByApplicableRate(vlc.ApplicableRate, dockMilkCollectionDtlDto.FAT.GetValueOrDefault(), dockMilkCollectionDtlDto.CLR.GetValueOrDefault());
dockMilkCollectionDtlDto.Amount = dockMilkCollectionDtl.Amount = dockMilkCollectionDtl.RatePerUnit.GetValueOrDefault() * dockMilkCollectionDtlDto.Quantity;
dockMilkCollectionDtlDto.Commission = dockMilkCollectionDtl.Commission = dockMilkCollectionDtlDto.Quantity * milkCommission;
dockMilkCollectionDtlDto.TotalAmount = dockMilkCollectionDtl.TotalAmount = dockMilkCollectionDtl.Commission.GetValueOrDefault() + dockMilkCollectionDtl.Amount;
unitOfWork.DockMilkCollectionDtlRepository.Add(dockMilkCollectionDtl);
}
}
dockMilkCollection.TotalCan = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.TotalCan);
dockMilkCollection.TotalRejectedCan = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.TotalRejectedCan);
dockMilkCollection.Amount = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.Amount);
dockMilkCollection.TotalQuantity = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.Quantity);
dockMilkCollection.Commission = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.Commission).GetValueOrDefault();
dockMilkCollection.TotalAmount = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.TotalAmount).GetValueOrDefault();
dockMilkCollection.RejectedQuantity = dockMilkCollectionDTO.dockMilkCollectionList.Sum(s => s.RejectedQuantity);
}
else
{
throw new PlatformModuleException("Dock Milk Collection Detail Not Found");
}
unitOfWork.DockMilkCollectionRepository.Add(dockMilkCollection);
UpdateVLCPaymentDetailsForDockCollection(vlc, dockMilkCollection);
string dockMessage = string.Format(NatrajConfigurationHelper.DockCollectionMessage, dockMilkCollection.CollectionDateTime.Date, dockMilkCollection.TotalQuantity, dockMilkCollection.TotalAmount);
var natrajSMSLog = this.SendSMS(vlc.Contact, dockMessage);
unitOfWork.SMSRepository.Add(natrajSMSLog);
unitOfWork.SaveChanges();
new SMSService().SendEmailInBackgroundThread(natrajSMSLog);
unitOfWork.SaveChanges();
responseDTO.Status = true;
responseDTO.Message = String.Format("Dock Milk Collection Detail Added Successfully ");
responseDTO.Data = this.GetDockCollectionByDateAndShift(DateTimeHelper.GetISTDateTime().Date, dockMilkCollection.ShiftId, 1);
return(responseDTO);
}
else
{
throw new PlatformModuleException("VLC Collection Details Not Found");
}
}
