public HttpResponseMessage detail(string repair_code)
{
//Service
var b3gRepair = new b3gRepair();
var sapSaleOrder = new sapSaleOrder();
var sapCustomer = new sapCustomer();
var sapBilling = new sapBilling();
var result = new RepairForm();
var rh = new RepairHeader();
var rp = new RepairAppointment();
ICollection <RepairItems> ri = new List <RepairItems>();
ICollection <RepairRaw> rr = new List <RepairRaw>();
try
{
afs_repair_header h = b3gRepair.GetRepairHeader(repair_code);
if (h == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Repair data not found"));
}
;
rh.repair_code = h.REPAIR_CODE;
rh.repair_date = h.REPAIR_DATE;
rh.so_number = h.SO_NUMBER;
rh.soldto_code = h.SOLDTO_CODE;
rh.soldto_name = h.SOLDTO_NAME;
rh.status = h.STATUS;
rh.transport_amount = h.TRANSPORT_AMOUNT;
rh.contact_tel = h.CONTACT_TEL;
rh.remark = h.REMARK;
rh.created_by = h.CREATED_BY;
rh.created_date = h.CREATED_DATE;
rh.update_by = h.UPDATE_BY;
rh.update_date = h.UPDATE_DATE;
var vbak = sapSaleOrder.GetVBAK(client, h.SO_NUMBER);
rh.so_date = DateTime.ParseExact(vbak.ERDAT, "yyyyMMdd", null);
//rh.soldto_code = vbak.KUNNR;
////Get Customer Detail
var kna1 = sapCustomer.GetKNA1(vbak.MANDT, rh.soldto_code);
//rh.soldto_name = kna1.NAME1 + kna1.NAME2;
//Get Customer Address
var adrc = sapCustomer.GetADRC(kna1.MANDT, kna1.ADRNR);
rh.soldto_address = sapCustomer.ConcateAddress(adrc.Where(w => w.NATION == " ").FirstOrDefault());
//Get Partner Customer
var vbpa = sapSaleOrder.GetVBPA(vbak.MANDT, vbak.VBELN, "000000");
//Ship-To Address
var partner = vbpa.Where(w => w.PARVW == "WE").FirstOrDefault();
rh.shipto_code = partner.KUNNR;
kna1 = sapCustomer.GetKNA1(vbak.MANDT, partner.KUNNR);
adrc = sapCustomer.GetADRC(kna1.MANDT, kna1.ADRNR);
rh.shipto_address = sapCustomer.ConcateAddress(adrc.Where(w => w.NATION == " ").FirstOrDefault());
//Get Sale Rep name
partner = vbpa.Where(w => w.PARVW == "ZR").FirstOrDefault();
rh.salerep_code = partner.KUNNR;
var salerep = sapCustomer.GetKNA1(partner.MANDT, partner.KUNNR);
rh.salerep_name = salerep.NAME1 + salerep.NAME2;
//Get Billing
var vbrks = sapBilling.GetVBRKbySONumber(vbak.MANDT, vbak.VBELN);
var vbrk = vbrks.OrderBy(o => o.FKDAT).FirstOrDefault();
rh.billing_date = DateTime.ParseExact(vbrk.FKDAT, "yyyyMMdd", null);
ICollection <afs_repair_items> items = b3gRepair.GetRepairItem(repair_code);
if (items == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Repair item data not found"));
}
;
//Items
foreach (var item in items)
{
//Get Sale Order item
var vbap = sapSaleOrder.GetVBAP(vbak.MANDT, item.SO_NUMBER, item.SO_ITEM);
if (vbap == null)
{
vbap = new VBAP();
}
//Get Images
List <RepairImages> ims = new List <RepairImages>();
var images = b3gRepair.GetRepairImage(item.REPAIR_ITEM_ID);
if (images == null)
{
images = new List <afs_repair_images>();
}
foreach (var img in images)
{
var im = new RepairImages();
im.repair_image_id = img.REPAIR_IMAGE_ID;
im.repair_code = img.REPAIR_CODE;
im.repair_item_id = img.REPAIR_ITEM_ID;
im.so_number = img.SO_NUMBER;
im.so_item = img.SO_ITEM;
im.filename = img.FILENAME;
im.base64 = img.BASE64;
ims.Add(im);
}
ri.Add(new RepairItems
{
select = true,
repair_item_id = item.REPAIR_ITEM_ID,
repair_code = item.REPAIR_CODE,
so_number = item.SO_NUMBER,
so_item = item.SO_ITEM,
article_number = vbap.MATNR,
article_name = vbap.ARKTX,
repair_item_type = item.REPAIR_ITEM_TYPE,
qty = item.REPAIR_QTY,
repair_remark = item.REPAIR_REMARK,
repair_desc = item.REPAIR_DESC,
repair_type = item.REPAIR_TYPE,
waranty = item.WARANTY,
images = ims
});
}
//Appointment
afs_repair_appointment p = b3gRepair.GetRepairAppointment(repair_code);
if (p != null)
{
rp.repair_code = p.REPAIR_CODE;
rp.repair_appoint_id = p.REPAIR_APPOINT_ID;
rp.appointment_date = p.APPOINTMENT_DATE;
rp.appointment_time = p.APPOINTMENT_TIME;
rp.target_date = p.TARGET_DATE;
rp.technician_team = p.TECHNICIAN_TEAM;
rp.price_amount = p.PRICE_AMOUNT;
rp.price_extra = p.PRICE_EXTRA;
rp.remark_customer = p.REMARK_CUSTOMER;
rp.created_by = p.CREATED_BY;
rp.created_date = p.CREATED_DATE;
rp.update_by = p.UPDATE_BY;
rp.update_date = p.UPDATE_DATE;
}
;
//Raw
ICollection <afs_repair_raw> raws = b3gRepair.GetRepairRaw(repair_code);
if (raws != null)
{
foreach (var raw in raws)
{
rr.Add(new RepairRaw
{
repair_raw_id = raw.REPAIR_RAW_ID,
repair_code = raw.REPAIR_CODE,
raw_name = raw.RAW_NAME,
raw_qty = raw.RAW_QTY,
status = raw.STATUS,
raw_date = raw.RAW_DATE,
remark = raw.REMARK,
created_by = raw.CREATED_BY,
created_date = raw.CREATED_DATE,
update_by = raw.UPDATE_BY,
update_date = raw.UPDATE_DATE
});
}
}
result.header = rh;
result.items = ri;
result.appoint = rp;
result.raws = rr;
return(result.header == null || result.items == null
? Request.CreateErrorResponse(HttpStatusCode.NotFound, "Repair data not found")
: Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage shipmentplan(ShipmentPlanSearchModel searchdata)
{
try
{
using (var context = new SAPContext())
{
var items = (from h in context.afs_shipment_h
join i in context.afs_shipment_carries on h.SHIPMENT_NUMBER equals i.SHIPMENT_NUMBER
join vttk in context.VTTK on h.SHIPMENT_NUMBER equals vttk.TKNUM
where h.CLIENT == client
select new
{
transport_date = h.TRANSPORT_DATE,
shipment_number = h.SHIPMENT_NUMBER,
car_license = vttk.ADD01,
containerid = vttk.SIGNI,
time_range = i.TIME_RANGE,
so_number = i.SALEORDER_NUMBER,
point_desc = i.POINT_DESC,
remark = i.REMARK,
status = h.STATUS
}).ToList();
//remove filter
if (!string.IsNullOrEmpty(searchdata.transport_date))
{
var tdate = DateTime.ParseExact(searchdata.transport_date, "dd/MM/yyyy", null);
items.RemoveAll(w => w.transport_date != tdate);
}
if (!string.IsNullOrEmpty(searchdata.ShipmentNo))
{
items.RemoveAll(w => w.shipment_number != searchdata.ShipmentNo);
}
if (!string.IsNullOrEmpty(searchdata.CarLicense))
{
items.RemoveAll(w => w.car_license != searchdata.CarLicense);
}
if (!string.IsNullOrEmpty(searchdata.ContainerID))
{
items.RemoveAll(w => !w.containerid.Contains(searchdata.ContainerID));
}
if (!string.IsNullOrEmpty(searchdata.SONumber))
{
items.RemoveAll(w => w.so_number != searchdata.SONumber);
}
//assign Sale Order
ShipmentPlanModel result = new ShipmentPlanModel();
List <ShipmentPlanModel> results = new List <ShipmentPlanModel>();
var SaleOrderService = new sapSaleOrder();
var BranchService = new sapBranch();
foreach (var item in items)
{
result = new ShipmentPlanModel();
result.transport_date = item.transport_date;
result.shipment_number = item.shipment_number;
result.car_license = item.car_license;
result.containerid = item.containerid;
result.time_range = item.time_range;
switch (result.time_range)
{
case "8.00-9.00":
result.time_sort = 1;
break;
case "9.00-10.00":
result.time_sort = 2;
break;
case "10.00-11.00":
result.time_sort = 3;
break;
case "11.00-12.00":
result.time_sort = 4;
break;
case "12.00-13.00":
result.time_sort = 5;
break;
case "13.00-14.00":
result.time_sort = 6;
break;
case "14.00-15.00":
result.time_sort = 7;
break;
case "15.00-16.00":
result.time_sort = 8;
break;
case "16.00-17.00":
result.time_sort = 9;
break;
default:
break;
}
result.so_number = item.so_number;
result.point_desc = item.point_desc;
result.remark = item.remark;
result.status = item.status;
if (!string.IsNullOrEmpty(result.so_number))
{
var vbak = SaleOrderService.GetVBAK(client, result.so_number);
if (vbak != null)
{
result.saleoffice_code = vbak.VKBUR;
if (!string.IsNullOrEmpty(result.saleoffice_code))
{
var branch = BranchService.GetZBRANCH(client, result.saleoffice_code);
if (branch != null)
{
result.saleoffice_name = branch.HOST_DESC;
}
}
var vbap = SaleOrderService.GetVBAP(vbak.MANDT, vbak.VBELN);
result.so_amount = vbap.Select(x => x.NETWR + x.MWSBP).Sum();
result.article_count = vbap.GroupBy(g => g.MATNR).Count();
result.article_sum_qty = vbap.Select(x => x.KWMENG).Sum();
}
}
results.Add(result);
}
return(Request.CreateResponse(HttpStatusCode.OK, results));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage PostSearh(RepairSearchModel search)
{
var sapSaleOrder = new sapSaleOrder();
var sapCustomer = new sapCustomer();
var sapBilling = new sapBilling();
search.fetchdata = search.fetchdata == null ? new fetchdata() : search.fetchdata;
var result = new RepairForm();
var rh = new RepairHeader();
ICollection <RepairItems> ri = new List <RepairItems>();
try
{
var vbak = sapSaleOrder.GetVBAK(client, search.sonumber);
if (vbak == null || vbak.VBTYP != "C")
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "VBAK not found"));
}
;
rh.so_number = vbak.VBELN;
rh.so_date = DateTime.ParseExact(vbak.ERDAT, "yyyyMMdd", null);
rh.soldto_code = vbak.KUNNR;
//Get Customer Detail
var kna1 = sapCustomer.GetKNA1(vbak.MANDT, vbak.KUNNR);
rh.soldto_name = kna1.NAME1 + kna1.NAME2;
//Get Customer Address
var adrc = sapCustomer.GetADRC(kna1.MANDT, kna1.ADRNR);
rh.soldto_address = sapCustomer.ConcateAddress(adrc.Where(w => w.NATION == " ").FirstOrDefault());
//Get Partner Customer
var vbpa = sapSaleOrder.GetVBPA(vbak.MANDT, vbak.VBELN, "000000");
//Ship-To Address
var partner = vbpa.Where(w => w.PARVW == "WE").FirstOrDefault();
rh.shipto_code = partner.KUNNR;
kna1 = sapCustomer.GetKNA1(vbak.MANDT, partner.KUNNR);
adrc = sapCustomer.GetADRC(kna1.MANDT, kna1.ADRNR);
rh.shipto_address = sapCustomer.ConcateAddress(adrc.Where(w => w.NATION == " ").FirstOrDefault());
//Get Sale Rep name
partner = vbpa.Where(w => w.PARVW == "ZR").FirstOrDefault();
rh.salerep_code = partner.KUNNR;
var salerep = sapCustomer.GetKNA1(partner.MANDT, partner.KUNNR);
rh.salerep_name = salerep.NAME1 + salerep.NAME2;
//Get Sale Order item
var vbap = sapSaleOrder.GetVBAP(vbak.MANDT, vbak.VBELN);
foreach (var item in vbap)
{
ri.Add(new RepairItems
{
select = false,
so_number = item.VBELN,
so_item = item.POSNR,
article_number = item.MATNR,
article_name = item.ARKTX,
qty = item.KWMENG
});
}
//Get Billing
var vbrks = sapBilling.GetVBRKbySONumber(vbak.MANDT, vbak.VBELN);
if (vbrks == null || vbrks.Count == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Billing not found"));
}
var vbrk = vbrks.OrderBy(o => o.FKDAT).FirstOrDefault();
rh.billing_date = DateTime.ParseExact(vbrk.FKDAT, "yyyyMMdd", null);
result.header = rh;
result.items = ri;
return(result.header == null || result.items == null
? Request.CreateErrorResponse(HttpStatusCode.NotFound, "Sale Order not found")
: Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}