public List <DeliveryReceipt> CustomerReceipt(int salesid)
{
var x = pEntity.customer_sales_receipt(salesid);
List <DeliveryReceipt> cus = new List <DeliveryReceipt>();
foreach (customer_sales_receipt_Result a in x)
{
DeliveryReceipt cp = new DeliveryReceipt();
cp.Firstname = a.Firstname;
cp.Lastname = a.Lastname;
cp.productcode = a.productcode;
cp.ProductDescription = a.ProductDescription;
cp.ProductName = a.ProductName;
cp.QTY = a.QTY;
cp.RetailPrice = a.RetailPrice;
cp.sales_id = a.sales_id;
cp.TotalAmount = a.TotalAmount;
cp.unitWeight = a.unitWeight;
cp.Weight = a.Weight;
cp.measurement = a.measurement;
cp.referenceNo = a.referenceNo;
cp.Address = a.Address + " " + a.City;
cp.ContactNo = a.cpno;
cp.Date = a.DateCreated.Value.ToShortDateString();
cp.Discounted = a.Discounted;
cp.GrandTotal = a.GrandTotal;
cus.Add(cp);
}
return(cus);
}
public async Task <IActionResult> PutDeliveryReceipt(int id, DeliveryReceipt deliveryReceipt)
{
if (id != deliveryReceipt.ID)
{
return(BadRequest());
}
_context.Entry(deliveryReceipt).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DeliveryReceiptExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool SendDeliveryReceipt(PurchaseOrderModel order, string language = null)
{
var mailSettings = _notificationSettingsRepository.GetNotificationSettings(language);
if (mailSettings != null)
{
var emailMessage = new DeliveryReceipt(_currentMarket, order);
emailMessage.From = mailSettings.From;
emailMessage.Header = mailSettings.MailHeader.ToString();
emailMessage.Footer = mailSettings.MailFooter.ToString();
var result = _emailDispatcher.SendEmail(emailMessage);
if (result.Success)
{
return(true);
}
else
{
Log.Error(result.Exception.Message, result.Exception);
return(false);
}
}
Log.Error("Unable to get notification settings");
return(false);
}
public async Task <ActionResult <DeliveryReceipt> > PostDeliveryReceipt(DeliveryReceipt deliveryReceipt)
{
_context.Delivery_Receipts.Add(deliveryReceipt);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDeliveryReceipt", new { id = deliveryReceipt.ID }, deliveryReceipt));
}
public void DeliveryReceipt(string ChannelId, string ChannelRef, string TransactionId, DeliveryReceiptHeadDoc aDeliveryReceiptHeadDoc)
{
// transform external object to packaged object understandable by BizTalk
DeliveryReceipt part = new DeliveryReceipt();
part.ChannelId = ChannelId;
part.ChannelRef = ChannelRef;
part.TransactionId = TransactionId;
part.aDeliveryReceiptHeadDoc = aDeliveryReceiptHeadDoc;
ArrayList inHeaders = null;
ArrayList inoutHeaders = null;
ArrayList inoutHeaderResponses = null;
ArrayList outHeaderResponses = null;
SoapUnknownHeader[] unknownHeaderResponses = null;
// Parameter information
object[] invokeParams = new object[] { part };
ParamInfo[] inParamInfos = new ParamInfo[] { new ParamInfo(typeof(DeliveryReceipt), "part") };
ParamInfo[] outParamInfos = null;
// Define the assembly (port)
// NOTE! This line is only a sample, it needs to be modified to match your orchestration
// at least regarding your project name and the public access token
string bodyTypeAssemblyQualifiedName = "YOUR_ORCHESTRATION_PROJECT.FromWMSschema+DeliveryReceipt, YOUR_ORCHESTRATION_PROJECT, Version=1.0.0.0, Culture=neutral, PublicKeyToken=" +
"92267163d02e63da";
// BizTalk invocation
// NOTE! This line is only a sample, it needs to be modified to match your orchestration
// regarding the operation to call
this.Invoke("Operation_1", invokeParams, inParamInfos, outParamInfos, 0, bodyTypeAssemblyQualifiedName, inHeaders, inoutHeaders, out inoutHeaderResponses, out outHeaderResponses, null, null, null, out unknownHeaderResponses, true, false);
}
private List <DeliveryReceipt> GetSelectedDeliveryReceipts()
{
List <DeliveryReceipt> list = new List <DeliveryReceipt>();
foreach (GridViewRow row in this.gvDeliveryReceipts.Rows)
{
CheckBox ck = ((CheckBox)row.FindControl("chkID"));
Image imgDR = (Image)row.FindControl("imgDetails");
if (ck.Checked)
{
DeliveryReceipt dr = new DeliveryReceipt();
dr.RecordNo = int.Parse(imgDR.ToolTip);
dr.PLNumber = row.Cells[10].Text;
dr.DeliveredTo = row.Cells[6].Text;
dr.DRDate = DateTime.Parse(row.Cells[4].Text);
dr.DeliveryReceiptNumber = row.Cells[3].Text;
dr.Forwarder = imgDR.AlternateText.Split('-')[0];
dr.WayBillNumber = imgDR.AlternateText.Split('-')[1];
list.Add(dr);
}
else
{
//Code if it is not checked ......may not be required
}
}
return(list);
}
private async Task UploadSampleDeliveryNotificationFile()
{
var sampleDeliveryNotification = new DeliveryReceipt()
{
DeliveryNotifications = new List <DeliveryNotification>()
{
new DeliveryNotification()
{
BatchID = 1,
CertificateNumber = "00000001",
Status = CertificateStatus.Delivered,
Reason = "",
StatusChangeDate = DateTime.Parse("2020-04-03T16:31:40.0000000Z")
},
new DeliveryNotification()
{
BatchID = 1,
CertificateNumber = "00000001",
Status = CertificateStatus.NotDelivered,
Reason = "Reason why certificate wasn't delivered",
StatusChangeDate = DateTime.Parse("2020-04-04T11:22:00.0000000Z")
}
}
};
var filename = "DeliveryNotifications-0702201530.json";
var path = $"{_deliveryNotificationDirectory}/Samples/{filename}";
await _blobFileTransferClient.UploadFile(JsonConvert.SerializeObject(sampleDeliveryNotification), path);
}
private void MainUI_Load(object sender, EventArgs e)
{
DeliveryReceipt deliveryReceipt = CheckRepository.GetDeliveryReceipt(CheckID);
DeliveryReceiptBindingSource.Add(deliveryReceipt);
this.reportViewer1.RefreshReport();
}
public void PostToLedger(DeliveryReceipt deliveryReceipt)
{
foreach (var deliveryReceiptDetail in deliveryReceipt.DeliveryReceiptDetails)
{
PostToLedger(deliveryReceipt.DeliveryReceiptId, deliveryReceipt.CustomerId,
DataConstants.InventoryLedgerType.Delivery,
deliveryReceipt.DRDate, deliveryReceiptDetail.ProductTypeId, deliveryReceiptDetail.Quantity,
string.Empty);
}
}
public IHttpActionResult PostDeliveryReceipt([FromBody] DeliveryReceipt input)
{
using (ctx = new YwtDbContext())
{
input.CreateTime = DateTime.Now;
ctx.DeliveryReceipt.Add(input);
var entity = ctx.DeliveryApply.FirstOrDefault(m => m.Id == input.ApplyId);
entity.Status = DeliveryApplyStatus.Received.ToString();
entity.LastUpdateTime = DateTime.Now;
ctx.SaveChanges();
return(Ok(input));
}
}
public async Task HandleDlr(DeliveryReceipt dlr)
{
var donors = (await _db.Donors.Where(x => x.PhoneNumber == dlr.Msisdn).ToListAsync()).ToDonorModels().ToList();
donors.ForEach(d => {
if ((dlr.Status == DlrStatus.failed) || (dlr.Status == DlrStatus.rejected))
{
d.NumberReachable = false;
d.ContactSuccessful = false;
}
else
{
d.ContactSuccessful = true;
}
});
//foreach(var d in donors) {
// await _hub.SendDonor(d);
//}
await _db.SaveChangesAsync();
}
private List <DeliveryReceipt> GetSelectedDeliveryReceiptsToBeCancelled()
{
List <DeliveryReceipt> list = new List <DeliveryReceipt>();
foreach (GridViewRow row in this.gvPreviewSelectedDR.Rows)
{
CheckBox ck = ((CheckBox)row.FindControl("chkSelectedDRTCancelled"));
if (ck.Checked)
{
DeliveryReceipt dr = new DeliveryReceipt();
dr.RecordNo = int.Parse(ck.ToolTip); // DRManager.GetDeliveryReceiptByKey(int.Parse(ck.ToolTip));
list.Add(dr);
}
else
{
//Code if it is not checked ......may not be required
}
}
return(list);
}
private void RecordToLedger(DeliveryReceipt deliveryReceipt)
{
var amount = deliveryReceipt.DeliveryReceiptDetails.Sum(x => x.Amount);
ledgerService.RecordToLedger(deliveryReceipt.DeliveryReceiptId, amount);
}
public void Insert(DeliveryReceipt deliveryReceipt)
{
deliveryRepository.Insert(deliveryReceipt);
RecordToLedger(deliveryReceipt);
}
public void Update(DeliveryReceipt deliveryReceipt)
{
deliveryRepository.Update(deliveryReceipt);
RecordToLedger(deliveryReceipt);
}
public List <DeliveryStatusViewModel> Match(List <Delivery> _deliveries)
{
BranchCorpOfficeBL bcoService = new BranchCorpOfficeBL();
DeliveryStatusBL status = new DeliveryStatusBL();
DeliveryRemarkBL remark = new DeliveryRemarkBL();
DistributionBL distributionService = new DistributionBL();
DeliveryReceiptBL deliveryReceiptService = new DeliveryReceiptBL();
ShipmentBL shipmentService = new ShipmentBL();
PackageNumberBL _packageNumberService = new PackageNumberBL();
List <DeliveryStatusViewModel> _results = new List <DeliveryStatusViewModel>();
List <Distribution> distributions = distributionService.GetAll().ToList();
List <DeliveryReceipt> deliveryReceipt = deliveryReceiptService.GetAll().ToList();
UserStore _userService = new UserStore();
foreach (Delivery delivery in _deliveries)
{
DeliveryStatusViewModel model = new DeliveryStatusViewModel();
DeliveryStatusViewModel isExist = _results.Find(x => x.AirwayBillNo == delivery.Shipment.AirwayBillNo);
if (isExist != null)
{
isExist.QTY++;
}
else
{
model.AirwayBillNo = delivery.Shipment.AirwayBillNo;
model.QTY = _packageNumberService.FilterActiveBy(x => x.Shipment.AirwayBillNo == delivery.Shipment.AirwayBillNo).Count;
model.Status = delivery.DeliveryStatus.DeliveryStatusName;
model.Remarks = "NA";
model.DeliveredBy = delivery.DeliveredBy.FullName;
if (delivery.DeliveryRemarkId != null)
{
model.Remarks = delivery.DeliveryRemark.DeliveryRemarkName;
}
Distribution dis = distributions.Find(x => x.ShipmentId == delivery.ShipmentId);
DeliveryReceipt dReceipt = deliveryReceipt.Find(x => x.DeliveryId == delivery.DeliveryId);
//List<Distribution> list = distributions.Where( x => x.ShipmentId == delivery.ShipmentId).Distinct().ToList();
//foreach(Distribution dis in list)
//{
// //model.Area = dis.Area.RevenueUnitName;
// model.Driver = dis.Driver;
// model.Checker = dis.Checker;
// model.Batch = dis.Batch.BatchName;
// model.PlateNo = dis.PlateNo;
// model.BCO = dis.Area.City.BranchCorpOffice.BranchCorpOfficeName;
//}
model.Area = dis.Area.RevenueUnitName;
model.Driver = dis.Driver;
model.Checker = dis.Checker;
model.Batch = dis.Batch.BatchName;
model.PlateNo = dis.PlateNo;
model.BCO = dis.Area.City.BranchCorpOffice.BranchCorpOfficeName;
//model.ScannedBy = AppUser.User.Employee.FullName;
model.ScannedBy = "N/A";
string employee = _userService.FindById(dis.CreatedBy).Employee.FullName;
if (employee != "")
{
model.ScannedBy = employee;
}
model.ReceivedBy = "NA";
if (dReceipt != null)
{
model.ReceivedBy = dReceipt.ReceivedBy;
}
_results.Add(model);
}
}
//List<BranchCorpOffice> _bco= bcoService.GetAll().Where(x => x.RecordStatus == 1 && x.BranchCorpOfficeId == GlobalVars.DeviceBcoId).ToList();
//string bcoName = bcoService.GetAll().Where(x => x.BranchCorpOfficeId == GlobalVars.DeviceBcoId).Select(x => x.BranchCorpOfficeName).ToString();
//string bcoName = _bco.Select(x => x.BranchCorpOfficeName).ToString();
string bcoName = bcoService.GetAll().Find(x => x.BranchCorpOfficeId == GlobalVars.DeviceBcoId).BranchCorpOfficeName;
List <DeliveryStatusViewModel> _resultsFilter = _results.FindAll(x => x.BCO == bcoName);
//List<DeliveryStatusViewModel> resultList = modelList.FindAll(x => x.Area == revenueUnitName);
//return _results;
return(_resultsFilter);
}
