public HttpResponseMessage Save(RepairForm postdata)
{
try
{
var b3gRepair = new b3gRepair();
using (var context = new SAPContext())
{
afs_repair_header h = new afs_repair_header();
h = context.afs_repair_header.Where(t => t.REPAIR_CODE == postdata.header.repair_code).FirstOrDefault();
if (h != null)
{
context.Entry(h).State = EntityState.Modified;
}
else
{
h = new afs_repair_header();
}
h.TRANSPORT_AMOUNT = postdata.header.transport_amount;
h.CONTACT_TEL = postdata.header.contact_tel;
h.REMARK = postdata.header.remark;
h.STATUS = postdata.header.status;
h.UPDATE_BY = postdata.header.update_by;
h.UPDATE_DATE = DateTime.Now;
if (string.IsNullOrEmpty(h.REPAIR_CODE))
{
h.REPAIR_CODE = b3gRepair.GetNextDocumentNumber();
h.REPAIR_DATE = DateTime.Now;
h.SO_NUMBER = postdata.header.so_number;
h.SOLDTO_CODE = postdata.header.soldto_code;
h.SOLDTO_NAME = postdata.header.soldto_name;
h.CREATED_BY = postdata.header.created_by;
h.CREATED_DATE = DateTime.Now;
context.afs_repair_header.Add(h);
}
context.SaveChanges();
//Set return value
postdata.header.repair_code = h.REPAIR_CODE;
postdata.header.repair_date = h.REPAIR_DATE;
postdata.header.created_by = h.CREATED_BY;
postdata.header.created_date = h.CREATED_DATE;
postdata.header.update_by = h.UPDATE_BY;
postdata.header.update_date = h.UPDATE_DATE;
List <afs_repair_items> i = new List <afs_repair_items>();
foreach (var item in postdata.items)
{
afs_repair_items v = new afs_repair_items();
v = context.afs_repair_items.Where(t => t.REPAIR_ITEM_ID == item.repair_item_id).FirstOrDefault();
if (v != null)
{
context.Entry(v).State = EntityState.Modified;
}
else
{
v = new afs_repair_items();
}
v.REPAIR_ITEM_TYPE = item.repair_item_type;
v.REPAIR_QTY = item.qty;
v.REPAIR_REMARK = item.repair_remark;
v.REPAIR_DESC = item.repair_desc;
v.REPAIR_TYPE = item.repair_type;
v.WARANTY = item.waranty;
v.UPDATE_BY = postdata.header.update_by;
v.UPDATE_DATE = DateTime.Now;
if (item.repair_item_id == 0)
{
v.REPAIR_CODE = h.REPAIR_CODE;
v.SO_NUMBER = item.so_number;
v.SO_ITEM = item.so_item;
v.CREATED_BY = postdata.header.created_by;
v.CREATED_DATE = DateTime.Now;
context.afs_repair_items.Add(v);
}
context.SaveChanges();
//Set return value
item.select = true;
item.repair_item_id = v.REPAIR_ITEM_ID;
item.repair_code = v.REPAIR_CODE;
if (item.images != null)
{
List <afs_repair_images> m = new List <afs_repair_images>();
foreach (var img in item.images)
{
afs_repair_images im = new afs_repair_images();
im = context.afs_repair_images.Where(t => t.REPAIR_IMAGE_ID == img.repair_image_id).FirstOrDefault();
if (im != null)
{
context.Entry(im).State = EntityState.Modified;
}
else
{
im = new afs_repair_images();
}
im.FILENAME = img.filename;
im.BASE64 = img.base64;
if (img.repair_image_id == 0)
{
im.REPAIR_CODE = h.REPAIR_CODE;
im.REPAIR_ITEM_ID = v.REPAIR_ITEM_ID;
im.SO_NUMBER = item.so_number;
im.SO_ITEM = item.so_item;
context.afs_repair_images.Add(im);
}
context.SaveChanges();
//Set return value
img.repair_image_id = im.REPAIR_IMAGE_ID;
img.repair_code = im.REPAIR_CODE;
img.repair_item_id = im.REPAIR_ITEM_ID;
}
}
}
;
}
return(Request.CreateResponse(HttpStatusCode.OK, postdata));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage SaveAppointment(RepairForm postdata)
{
try
{
var b3gRepair = new b3gRepair();
using (var context = new SAPContext())
{
afs_repair_header h = new afs_repair_header();
h = context.afs_repair_header.Where(t => t.REPAIR_CODE == postdata.header.repair_code).FirstOrDefault();
if (h != null)
{
context.Entry(h).State = EntityState.Modified;
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Repair data not found"));
}
//set status
h.STATUS = postdata.header.status;
if (postdata.header.status != "COMPLETE")
{
if (postdata.raws.Where(w => w.status == "มีอะไหล่").Count() == postdata.raws.Count())
{
h.STATUS = "PROCESS";
}
else
{
h.STATUS = "PREPARE";
};
}
;
h.UPDATE_BY = postdata.header.update_by;
h.UPDATE_DATE = DateTime.Now;
context.SaveChanges();
//Set return value
postdata.header.update_by = h.UPDATE_BY;
postdata.header.update_date = h.UPDATE_DATE;
//นัดหมายลูกค้า
if (postdata.appoint != null)
{
afs_repair_appointment p = new afs_repair_appointment();
p = context.afs_repair_appointment.Where(t => t.REPAIR_APPOINT_ID == postdata.appoint.repair_appoint_id).FirstOrDefault();
if (p != null)
{
context.Entry(p).State = EntityState.Modified;
}
else
{
p = new afs_repair_appointment();
}
p.APPOINTMENT_DATE = postdata.appoint.appointment_date; //DateTime.ParseExact(postdata.appoint.appointment_date, "dd/MM/yyyy", null);
p.APPOINTMENT_TIME = postdata.appoint.appointment_time;
p.TARGET_DATE = postdata.appoint.target_date; // DateTime.ParseExact(postdata.appoint.target_date, "dd/MM/yyyy", null);
p.TECHNICIAN_TEAM = postdata.appoint.technician_team;
p.PRICE_AMOUNT = postdata.appoint.price_amount;
p.PRICE_EXTRA = postdata.appoint.price_extra;
p.REMARK_CUSTOMER = postdata.appoint.remark_customer;
p.UPDATE_BY = postdata.header.update_by;
p.UPDATE_DATE = DateTime.Now;
if (p.REPAIR_APPOINT_ID == 0)
{
p.REPAIR_CODE = postdata.header.repair_code;
p.CREATED_BY = postdata.header.created_by;
p.CREATED_DATE = DateTime.Now;
context.afs_repair_appointment.Add(p);
}
context.SaveChanges();
//Set return value
postdata.appoint.repair_appoint_id = p.REPAIR_APPOINT_ID;
postdata.appoint.repair_code = postdata.header.repair_code;
}
List <afs_repair_raw> i = new List <afs_repair_raw>();
foreach (var item in postdata.raws)
{
afs_repair_raw v = new afs_repair_raw();
v = context.afs_repair_raw.Where(t => t.REPAIR_RAW_ID == item.repair_raw_id).FirstOrDefault();
if (v != null)
{
context.Entry(v).State = EntityState.Modified;
}
else
{
v = new afs_repair_raw();
}
v.RAW_NAME = item.raw_name;
v.RAW_QTY = item.raw_qty;
v.STATUS = item.status;
if (item.raw_date.HasValue)
{
v.RAW_DATE = item.raw_date.Value; //DateTime.ParseExact(item.raw_date, "dd/MM/yyyy", null);
}
;
v.REMARK = item.remark;
v.UPDATE_BY = postdata.header.update_by;
v.UPDATE_DATE = DateTime.Now;
if (item.repair_raw_id == 0)
{
v.REPAIR_CODE = postdata.header.repair_code;
v.CREATED_BY = postdata.header.created_by;
v.CREATED_DATE = DateTime.Now;
context.afs_repair_raw.Add(v);
}
context.SaveChanges();
//Set return value
item.repair_raw_id = v.REPAIR_RAW_ID;
item.repair_code = postdata.header.repair_code;
}
;
}
return(Request.CreateResponse(HttpStatusCode.OK, postdata));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.InnerException.Message));
}
}
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));
}
}
