public MessageRespons CloseOrder(IUnitOfWork uow, ExcelMassUploadImportRequest request)
{
MessageRespons responseaction = new MessageRespons();
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Data harus dipilih");
}
{
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
foreach (string id in idAll)
{
HijrahquDataContext ctx = new HijrahquDataContext();
Order ord = ctx.Orders.FirstOrDefault(x => x.OrderID == int.Parse(id));
if (ord.OrderStatus == "Complete" && ord.TanggalBayar != null)
{
ord.OrderStatus = "Close";
ctx.SubmitChanges();
}
}
}
responseaction.message = "OK";
return(responseaction);
}
public FileContentResult ExportDataNINJA(IDbConnection connection, ExcelMassUploadImportRequest request)
{
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Batch Id Cannot NULL");
}
var template = Server.MapPath(ConfigurationManager.AppSettings["TEMPLATENINJA"].ToString());
var filename = "NINJAAWB_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
var templateFile = new System.IO.FileInfo(template);
var stream = new MemoryStream();
using (var package = new ExcelPackage(templateFile, false))
{
var workbook = package.Workbook;
var worksheet = package.Workbook.Worksheets[1];
var fields = MyRow.Fields;
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
int idxData = 1;
int idxCol = 2;
foreach (string id in idAll)
{
HijrahquDataContext ctx = new HijrahquDataContext();
List <ViewOrder> order = ctx.ViewOrders.Where(x => x.OrderID == int.Parse(id)).ToList();
//string cells = "";
if (order.Count > 0)
{
worksheet.Cells["A" + idxCol.ToString()].Value = order[0].OrderID.ToString();
worksheet.Cells["B" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["C" + idxCol.ToString()].Value = order[0].Address;
//worksheet.Cells["D" + idxCol.ToString()].Value = "JAWA BARAT";
worksheet.Cells["E" + idxCol.ToString()].Value = order[0].District;
worksheet.Cells["F" + idxCol.ToString()].Value = order[0].City;
worksheet.Cells["G" + idxCol.ToString()].Value = order[0].Province;
//worksheet.Cells["H" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["I" + idxCol.ToString()].Value = order[0].Handphone;
//PROVINCE
worksheet.Cells["J" + idxCol.ToString()].Value = order[0].KodePos;
//CITY
worksheet.Cells["K" + idxCol.ToString()].Value = (DateTime.Now.AddDays(1)).ToString("yyyy-MM-dd");
//COUNTRY
//worksheet.Cells["L" + idxCol.ToString()].Value = "INDONESIA";
worksheet.Cells["M" + idxCol.ToString()].Value = 1;
worksheet.Cells["N" + idxCol.ToString()].Value = "Standard";
worksheet.Cells["O" + idxCol.ToString()].Value = order[0].OrderID.ToString();
string keterangan = order[0].Keterangan;
string intruksi = "UNTUK KURIR MOHON AMANAH DALAM MELAKUKAN PENGANTARAN (HARAP LAKUKAN SESUAI SOP)";
keterangan += intruksi;
worksheet.Cells["P" + idxCol.ToString()].Value = keterangan;
worksheet.Cells["Q" + idxCol.ToString()].Value = "TRUE";
worksheet.Cells["R" + idxCol.ToString()].Value = order[0].TotalBayar.ToString();
idxData++;
idxCol++;
}
}
return(ExcelContentResult.Create(package.GetAsByteArray(), filename));
}
}
public FileContentResult ExportDataJX(IDbConnection connection, ExcelMassUploadImportRequest request)
{
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Batch Id Cannot NULL");
}
var template = Server.MapPath(ConfigurationManager.AppSettings["TEMPLATEJX"].ToString());
var filename = "JXAWB_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
var templateFile = new System.IO.FileInfo(template);
var stream = new MemoryStream();
using (var package = new ExcelPackage(templateFile, false))
{
var workbook = package.Workbook;
var worksheet = package.Workbook.Worksheets[1];
var fields = MyRow.Fields;
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
int idxData = 1;
int idxCol = 2;
foreach (string id in idAll)
{
HijrahquDataContext ctx = new HijrahquDataContext();
List <ViewOrder> order = ctx.ViewOrders.Where(x => x.OrderID == int.Parse(id)).ToList();
//string cells = "";
worksheet.Cells["A" + idxCol.ToString()].Value = "#" + order[0].OrderID.ToString();
worksheet.Cells["B" + idxCol.ToString()].Value = order[0].NamaPengirim;
worksheet.Cells["C" + idxCol.ToString()].Value = order[0].NoPengirim;
worksheet.Cells["D" + idxCol.ToString()].Value = "JAWA BARAT";
worksheet.Cells["E" + idxCol.ToString()].Value = "BEKASI";
worksheet.Cells["F" + idxCol.ToString()].Value = "INDONESIA";
worksheet.Cells["G" + idxCol.ToString()].Value = "RUKO HIJRAHQU, JALAN RAYA KARANG SATRIA TAMBUN UTARA BEKASI";
worksheet.Cells["H" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["I" + idxCol.ToString()].Value = order[0].Handphone;
//PROVINCE
//worksheet.Cells["J" + idxCol.ToString()].Value = order[0].TanggalWa;
//CITY
//worksheet.Cells["K" + idxCol.ToString()].Value = order[0].TanggalClosing;
//COUNTRY
worksheet.Cells["L" + idxCol.ToString()].Value = "INDONESIA";
worksheet.Cells["M" + idxCol.ToString()].Value = order[0].Address;
worksheet.Cells["N" + idxCol.ToString()].Value = "PAKET BUKU";
worksheet.Cells["O" + idxCol.ToString()].Value = "1";
worksheet.Cells["P" + idxCol.ToString()].Value = "1";
worksheet.Cells["Q" + idxCol.ToString()].Value = "COD";
worksheet.Cells["R" + idxCol.ToString()].Value = "COD";
idxData++;
idxCol++;
}
return(ExcelContentResult.Create(package.GetAsByteArray(), filename));
}
}
public FileContentResult LaporanPenjualan(IDbConnection connection, ExcelMassUploadImportRequest request)
{
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Batch Id Cannot NULL");
}
var template = Server.MapPath(ConfigurationManager.AppSettings["LapPenjualan"].ToString());
var filename = "LapPenjualan_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
var templateFile = new System.IO.FileInfo(template);
var stream = new MemoryStream();
using (var package = new ExcelPackage(templateFile, false))
{
var workbook = package.Workbook;
var worksheet = package.Workbook.Worksheets[1];
var fields = MyRow.Fields;
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
int idxData = 1;
int idxCol = 4;
foreach (string id in idAll)
{
HijrahquDataContext ctx = new HijrahquDataContext();
List <ViewLapPenjualan> order = ctx.ViewLapPenjualans.Where(x => x.OrderID == int.Parse(id)).ToList();
//string cells = "";
worksheet.Cells["B" + idxCol.ToString()].Value = idxData.ToString();
worksheet.Cells["C" + idxCol.ToString()].Value = "#" + order[0].OrderID.ToString();
worksheet.Cells["D" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["E" + idxCol.ToString()].Value = order[0].Handphone;
worksheet.Cells["F" + idxCol.ToString()].Value = "1";
worksheet.Cells["G" + idxCol.ToString()].Value = "1";
worksheet.Cells["H" + idxCol.ToString()].Value = "1";
worksheet.Cells["I" + idxCol.ToString()].Value = "1";
worksheet.Cells["J" + idxCol.ToString()].Value = order[0].Ongkir;
worksheet.Cells["K" + idxCol.ToString()].Value = 125000 + order[0].Ongkir;
worksheet.Cells["L" + idxCol.ToString()].Value = order[0].TanggalWa;
worksheet.Cells["M" + idxCol.ToString()].Value = order[0].TanggalClosing;
worksheet.Cells["N" + idxCol.ToString()].Value = order[0].TanggalKirim;
worksheet.Cells["O" + idxCol.ToString()].Value = order[0].TanggalBayar;
worksheet.Cells["P" + idxCol.ToString()].Value = order[0].TanggalCS;
idxData++;
idxCol++;
}
return(ExcelContentResult.Create(package.GetAsByteArray(), filename));
}
}
public FileContentResult CreateJOB(IDbConnection connection, ExcelMassUploadImportRequest request)
{
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Batch Id Cannot NULL");
}
var template = Server.MapPath(ConfigurationManager.AppSettings["JOBTemplate"].ToString());
var filename = "JOB_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
var templateFile = new System.IO.FileInfo(template);
var stream = new MemoryStream();
using (var package = new ExcelPackage(templateFile, false))
{
var workbook = package.Workbook;
var worksheet = package.Workbook.Worksheets[1];
var fields = MyRow.Fields;
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
int idxData = 1;
int idxCol = 2;
foreach (string id in idAll)
{
HijrahquDataContext ctx = new HijrahquDataContext();
List <ViewOrder> order = ctx.ViewOrders.Where(x => x.OrderID == int.Parse(id)).ToList();
//string cells = "";
worksheet.Cells["A" + idxCol.ToString()].Value = order[0].NamaPengirim;
worksheet.Cells["B" + idxCol.ToString()].Value = "TAMBUN UTARA, BEKASI";
worksheet.Cells["E" + idxCol.ToString()].Value = order[0].NamaPengirim;
worksheet.Cells["F" + idxCol.ToString()].Value = "0877-8090-1125";
worksheet.Cells["G" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["H" + idxCol.ToString()].Value = order[0].Address;
worksheet.Cells["I" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["L" + idxCol.ToString()].Value = order[0].CustomerName;
worksheet.Cells["M" + idxCol.ToString()].Value = order[0].Handphone;
worksheet.Cells["N" + idxCol.ToString()].Value = "1";
worksheet.Cells["O" + idxCol.ToString()].Value = "1";
worksheet.Cells["P" + idxCol.ToString()].Value = "BUKU SYAMAIL MUHAMMADIYAH";
idxData++;
idxCol++;
}
return(ExcelContentResult.Create(package.GetAsByteArray(), filename));
}
}
public ExcelMassUploadImportResponse ExcelImport(IUnitOfWork uow, ExcelMassUploadImportRequest request)
{
Check.NotNullOrWhiteSpace(request.FileName, "filename");
UploadHelper.CheckFileNameSecurity(request.FileName);
if (!request.FileName.StartsWith("temporary/"))
{
throw new ArgumentOutOfRangeException("filename");
}
ExcelPackage ep = new ExcelPackage();
using (var fs = new FileStream(UploadHelper.DbFilePath(request.FileName), FileMode.Open, FileAccess.Read))
ep.Load(fs);
var response = new ExcelMassUploadImportResponse();
response.ErrorList = new List <string>();
// Get batch of row number/index
var numberList = request.TotalRecord;
var p = MyRow.Fields;
/////////////////////////////////////////////////////////////
//ITEM INFO UPLOAD
/////////////////////////////////////////////////////////////
var wsItemInfo = ep.Workbook.Worksheets[1];
for (var currRow = 2; currRow <= (numberList + 2); currRow++)
{
try
{
var order = new MyRow();
try
{
order.CustomerCustomerName = wsItemInfo.Cells[currRow, 1].Value.ToString();
order.CustomerHandphone = wsItemInfo.Cells[currRow, 2].Value.ToString();
order.CustomerAddress = wsItemInfo.Cells[currRow, 3].Value.ToString();
order.OrderStatus = "New Order";
new OrderRepository().Create(uow, new SaveRequest <MyRow>()
{
Entity = order
});
response.Inserted = response.Inserted + 1;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
catch (Exception x)
{
string msg = "Row:" + currRow.ToString() + " - " + x.Message;
response.ErrorList.Add(x.Message);
}
}
return(response);
}
public FileContentResult Printlabel(IUnitOfWork uow, ExcelMassUploadImportRequest request)
{
request.CheckNotNull();
if (request.IdExport == null)
{
throw new ValidationError("Batch Id Cannot NULL");
}
var template = Server.MapPath(ConfigurationManager.AppSettings["LabelTemplate"].ToString());
var filename = "CustomerList_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
var templateFile = new System.IO.FileInfo(template);
var stream = new MemoryStream();
using (var package = new ExcelPackage(templateFile, false))
{
var workbook = package.Workbook;
var worksheet = package.Workbook.Worksheets[1];
var fields = MyRow.Fields;
string[] idAll = request.IdExport[0].Split(new char[] { ',' });
int idxData = 1;
int idxCol = 2;
foreach (string id in idAll)
{
RetrieveRequest retReq = new RetrieveRequest();
retReq.EntityId = id;
var ord = new OrderRepository().Retrieve(uow.Connection, retReq);
HijrahquDataContext ctx = new HijrahquDataContext();
List <ViewOrder> order = ctx.ViewOrders.Where(x => x.OrderID == int.Parse(id)).ToList();//int.Parse("15")).ToList();
string cells = "";
if (order[0].OrderStatus == "NewOrder")
{
if (idxData == 1)
{
cells = "D";
worksheet.Cells[cells + "6"].Value = order[0].CustomerName;
worksheet.Cells[cells + "7"].Value = order[0].Handphone;
worksheet.Cells[cells + "8"].Value = order[0].Address;
worksheet.Cells["H3"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 2)
{
cells = "D";
worksheet.Cells[cells + "21"].Value = order[0].CustomerName;
worksheet.Cells[cells + "22"].Value = order[0].Handphone;
worksheet.Cells[cells + "23"].Value = order[0].Address;
worksheet.Cells["H18"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 3)
{
cells = "D";
worksheet.Cells[cells + "36"].Value = order[0].CustomerName;
worksheet.Cells[cells + "37"].Value = order[0].Handphone;
worksheet.Cells[cells + "38"].Value = order[0].Address;
worksheet.Cells["H33"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 4)
{
cells = "D";
worksheet.Cells[cells + "51"].Value = order[0].CustomerName;
worksheet.Cells[cells + "52"].Value = order[0].Handphone;
worksheet.Cells[cells + "53"].Value = order[0].Address;
worksheet.Cells["H48"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 5)
{
cells = "K";
worksheet.Cells[cells + "6"].Value = order[0].CustomerName;
worksheet.Cells[cells + "7"].Value = order[0].Handphone;
worksheet.Cells[cells + "8"].Value = order[0].Address;
worksheet.Cells["O3"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 6)
{
cells = "K";
worksheet.Cells[cells + "21"].Value = order[0].CustomerName;
worksheet.Cells[cells + "22"].Value = order[0].Handphone;
worksheet.Cells[cells + "23"].Value = order[0].Address;
worksheet.Cells["O18"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 7)
{
cells = "K";
worksheet.Cells[cells + "36"].Value = order[0].CustomerName;
worksheet.Cells[cells + "37"].Value = order[0].Handphone;
worksheet.Cells[cells + "38"].Value = order[0].Address;
worksheet.Cells["O33"].Value = "#" + order[0].OrderID.ToString();
}
;
if (idxData == 8)
{
cells = "K";
worksheet.Cells[cells + "51"].Value = order[0].CustomerName;
worksheet.Cells[cells + "52"].Value = order[0].Handphone;
worksheet.Cells[cells + "53"].Value = order[0].Address;
worksheet.Cells["O48"].Value = "#" + order[0].OrderID.ToString();
}
;
ord.Entity.OrderStatus = "Printed";
new OrderRepository().Update(uow, new SaveRequest <MyRow> {
Entity = ord.Entity, EntityId = ord.Entity.OrderId
});
}
idxData++;
idxCol++;
}
return(ExcelContentResult.Create(package.GetAsByteArray(), filename));
}
}
public ExcelMassUploadImportResponse UploadDataClosing(IUnitOfWork uow, ExcelMassUploadImportRequest request)
{
Check.NotNullOrWhiteSpace(request.FileName, "filename");
UploadHelper.CheckFileNameSecurity(request.FileName);
if (!request.FileName.StartsWith("temporary/"))
{
throw new ArgumentOutOfRangeException("filename");
}
ExcelPackage ep = new ExcelPackage();
using (var fs = new FileStream(UploadHelper.DbFilePath(request.FileName), FileMode.Open, FileAccess.Read))
ep.Load(fs);
var response = new ExcelMassUploadImportResponse();
response.ErrorList = new List <string>();
// Get batch of row number/index
var numberList = request.TotalRecord;
var p = MyRow.Fields;
int receivedCount = 0;
/////////////////////////////////////////////////////////////
//ITEM INFO UPLOAD
/////////////////////////////////////////////////////////////
var wsItemInfo = ep.Workbook.Worksheets[1];
for (var currRow = 4; currRow <= (numberList + 4); currRow++)
{
try
{
var odr = new OrderRow();
try
{
CustomerRow custNew = new CustomerRow();
custNew.CustomerName = wsItemInfo.Cells[currRow, 2].Value.ToString();
custNew.Address = "Bekasi";
SaveResponse savedCust = new CustomerRepository().Create(uow, new SaveRequest <CustomerRow>()
{
Entity = custNew
});
odr.CustomerId = int.Parse(savedCust.EntityId.ToString());
odr.Ongkir = 9000;
odr.OrderStatus = "NewOrder";
odr.DetailList = new List <OrderDetailRow>();
odr.DetailList.Add(new OrderDetailRow()
{
ProductId = 1, Quantity = 1, Price = 125000
});
SaveResponse savedOdr = new OrderRepository().Create(uow, new SaveRequest <OrderRow>()
{
Entity = odr
});
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
catch (Exception x)
{
string msg = "Row:" + currRow.ToString() + " - " + x.Message;
response.ErrorList.Add(x.Message);
}
}
response.Inserted = receivedCount;
return(response);
}
public ExcelMassUploadImportResponse SynchResi(IUnitOfWork uow, ExcelMassUploadImportRequest request)
{
Check.NotNullOrWhiteSpace(request.FileName, "filename");
UploadHelper.CheckFileNameSecurity(request.FileName);
if (!request.FileName.StartsWith("temporary/"))
{
throw new ArgumentOutOfRangeException("filename");
}
ExcelPackage ep = new ExcelPackage();
using (var fs = new FileStream(UploadHelper.DbFilePath(request.FileName), FileMode.Open, FileAccess.Read))
ep.Load(fs);
var response = new ExcelMassUploadImportResponse();
response.ErrorList = new List <string>();
// Get batch of row number/index
var numberList = request.TotalRecord;
var p = MyRow.Fields;
int receivedCount = 0;
/////////////////////////////////////////////////////////////
//ITEM INFO UPLOAD
/////////////////////////////////////////////////////////////
var wsItemInfo = ep.Workbook.Worksheets[1];
if (request.Expedisi == "JNE")
{
for (var currRow = 4; currRow <= (numberList + 4); currRow++)
{
try
{
var noResi = new NoResiRow();
try
{
var dateCode = DateTime.Parse(wsItemInfo.Cells[currRow, 4].Value.ToString()).Year.ToString() +
DateTime.Parse(wsItemInfo.Cells[currRow, 4].Value.ToString()).Month.ToString() +
DateTime.Parse(wsItemInfo.Cells[currRow, 4].Value.ToString()).Day.ToString();
noResi.CustomerName = wsItemInfo.Cells[currRow, 11].Value.ToString();
noResi.Handphone = "";
noResi.Expedisi = "JNE";
noResi.ExpedisiService = wsItemInfo.Cells[currRow, 5].Value.ToString();
noResi.Destination = wsItemInfo.Cells[currRow, 8].Value.ToString();
noResi.Ongkir = decimal.Parse(wsItemInfo.Cells[currRow, 12].Value.ToString());
noResi.NoResi = "0" + wsItemInfo.Cells[currRow, 3].Value.ToString();
noResi.SendDate = dateCode + "_" + noResi.CustomerName.Trim();
noResi.JNEDate = DateTime.Parse(wsItemInfo.Cells[currRow, 4].Value.ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
ListRequest req = new ListRequest();
req.EqualityFilter = new Dictionary <string, object>
{
{ "CustomerName", noResi.CustomerName },
{ "OrderStatus", "Printed" }
};
var cust = new ViewOrderRepository().List(uow.Connection, req);
if (cust.Entities.Count > 0)
{
RetrieveRequest retReq = new RetrieveRequest();
retReq.EntityId = cust.Entities[0].OrderId;
var order = new OrderRepository().Retrieve(uow.Connection, retReq);
order.Entity.NoResi = noResi.NoResi;
order.Entity.OrderStatus = "Delivery";
order.Entity.Ongkir = noResi.Ongkir;
new OrderRepository().Update(uow, new SaveRequest <OrderRow>()
{
EntityId = order.Entity.OrderId, Entity = order.Entity
});
new NoResiRepository().Create(uow, new SaveRequest <NoResiRow>()
{
Entity = noResi
});
receivedCount++;
}
}
catch (Exception x)
{
string msg = "Row:" + currRow.ToString() + " - " + x.Message;
response.ErrorList.Add(x.Message);
}
}
}
else
{
for (var currRow = 2; currRow <= (numberList); currRow++)
{
try
{
var noResi = new NoResiRow();
try
{
//var dateCode = DateTime.Parse(wsItemInfo.Cells[currRow, 8].Value.ToString()).Year.ToString() +
// //DateTime.Parse(wsItemInfo.Cells[currRow, 8].Value.ToString()).Month.ToString() +
// //DateTime.Parse(wsItemInfo.Cells[currRow, 8].Value.ToString()).Day.ToString();
noResi.CustomerName = wsItemInfo.Cells[currRow, 6].Value.ToString();
noResi.Handphone = wsItemInfo.Cells[currRow, 7].Value.ToString();
noResi.Expedisi = request.Expedisi;
noResi.ExpedisiService = "Standart";
//noResi.Destination = wsItemInfo.Cells[currRow, 8].Value.ToString();
//noResi.Ongkir = decimal.Parse(wsItemInfo.Cells[currRow, 12].Value.ToString());
noResi.NoResi = wsItemInfo.Cells[currRow, 1].Value.ToString();
noResi.SendDate = wsItemInfo.Cells[currRow, 8].Value.ToString();
noResi.NINJADate = wsItemInfo.Cells[currRow, 2].Value.ToString();
noResi.StatusPengiriman = wsItemInfo.Cells[currRow, 3].Value.ToString();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
ListRequest req = new ListRequest();
req.EqualityFilter = new Dictionary <string, object>
{
{ "Handphone", noResi.Handphone.Replace("+", "") },
{ "OrderStatus", "Printed" }
};
var cust = new ViewOrderRepository().List(uow.Connection, req);
ListRequest req1 = new ListRequest();
req1.EqualityFilter = new Dictionary <string, object>
{
{ "Handphone", noResi.Handphone.Replace("+", "") },
{ "OrderStatus", "NewOrder" }
};
var cust1 = new ViewOrderRepository().List(uow.Connection, req1);
if (cust.Entities.Count > 0)
{
RetrieveRequest retReq = new RetrieveRequest();
retReq.EntityId = cust.Entities[0].OrderId;
var order = new OrderRepository().Retrieve(uow.Connection, retReq);
order.Entity.NoResi = noResi.NoResi;
if (noResi.StatusPengiriman == "Lengkap")
{
order.Entity.OrderStatus = "Received";
}
//order.Entity.Ongkir = noResi.Ongkir;
new OrderRepository().Update(uow, new SaveRequest <OrderRow>()
{
EntityId = order.Entity.OrderId,
Entity = order.Entity
});
new NoResiRepository().Create(uow, new SaveRequest <NoResiRow>()
{
Entity = noResi
});
receivedCount++;
}
if (cust1.Entities.Count > 0)
{
RetrieveRequest retReq = new RetrieveRequest();
retReq.EntityId = cust1.Entities[0].OrderId;
var order = new OrderRepository().Retrieve(uow.Connection, retReq);
order.Entity.NoResi = noResi.NoResi;
if (noResi.StatusPengiriman == "Lengkap")
{
order.Entity.OrderStatus = "Received";
}
//order.Entity.Ongkir = noResi.Ongkir;
new OrderRepository().Update(uow, new SaveRequest <OrderRow>()
{
EntityId = order.Entity.OrderId,
Entity = order.Entity
});
new NoResiRepository().Create(uow, new SaveRequest <NoResiRow>()
{
Entity = noResi
});
receivedCount++;
}
}
catch (Exception x)
{
string msg = "Row:" + currRow.ToString() + " - " + x.Message;
response.ErrorList.Add(x.Message);
}
}
}
response.Inserted = receivedCount;
return(response);
}
