public JsonResult SyncDataToSQLite(List <CMSDeliveryWModels> SyncUpData) { List <CMSDeliveryWModels> SyncDownDatas = new List <CMSDeliveryWModels>(); var cmsService = new MobileService(); if (SyncUpData != null) { foreach (var row in SyncUpData) { var cri = new MobileCri(); cri.Delivery_ID = row.Delivery_ID; cri.Sync_Current_Data = true; var result = cmsService.GetCMSDelivery(cri); if (result.Code == ReturnCode.SUCCESS) { var deliverys = result.Object as List <CMS_Delivery>; if (deliverys != null && deliverys.Count > 0) { CMS_Delivery get_delivery = new CMS_Delivery(); get_delivery = deliverys.FirstOrDefault(); if (get_delivery != null) { CMSDeliveryWModels _delivery = new CMSDeliveryWModels(); _delivery.Local_Delivery_ID = row.Local_Delivery_ID; _delivery.Delivery_ID = get_delivery.Delivery_ID; _delivery.Delivery_Order_No = get_delivery.Delivery_Order_No; _delivery.Record_Status = get_delivery.Record_Status; //Boolean in Sqlite (0,Fail) , (1,true) if (get_delivery.Completed.HasValue && get_delivery.Completed.Value) { _delivery.Completed = 1; } else { _delivery.Completed = 0; } SyncDownDatas.Add(_delivery); } } } } } return(Json(SyncDownDatas, JsonRequestBehavior.AllowGet)); }
public JsonResult SyncDownDeliveryByRecord(string DeliveryID) { var SyncData = new CMSDeliveryWModels(); var cmsService = new MobileService(); var cri = new MobileCri(); cri.Delivery_ID = NumUtil.ParseInteger(DeliveryID); cri.Sync_Not_Completed = true; cri.Is_Active = true; var result = cmsService.GetCMSDelivery(cri); if (result.Code == ReturnCode.SUCCESS) { var DOlist = result.Object as List <CMS_Delivery>; if (DOlist != null && DOlist.Count > 0) { var d = DOlist.FirstOrDefault(); if (d != null) { SyncData.Delivery_ID = d.Delivery_ID; SyncData.Delivery_Order_No = d.Delivery_Order_No; SyncData.Update_On = DateUtil.ToDisplayDateTime(d.Update_On); SyncData.Record_Status = d.Record_Status; List <CMSDeliveryDetailWModels> details = new List <CMSDeliveryDetailWModels>(); foreach (var row2 in d.CMS_Delivery_Detail as List <CMS_Delivery_Detail> ) { var detail = new CMSDeliveryDetailWModels(); detail.CMS_Delivery_Detail_ID = row2.CMS_Delivery_Detail_ID; if (!string.IsNullOrEmpty(row2.Product_Code)) { detail.Product_ID = 1; //remove after improve code in mobile detail.Product_Code = row2.Product_Code.Trim(); detail.Product_Name = ""; } detail.No_Of_Containers = row2.No_Of_Containers.HasValue ? row2.No_Of_Containers.Value : 1; details.Add(detail); } SyncData.DeliveryDetail = details; } } } return(Json(SyncData, JsonRequestBehavior.AllowGet)); }
public JsonResult SyncDeliverys() { List <CMSDeliveryWModels> SyncDatas = new List <CMSDeliveryWModels>(); var cmsService = new MobileService(); var cri = new MobileCri(); cri.Sync_Not_Completed = true; cri.Is_Active = true; var result = cmsService.GetCMSDelivery(cri); if (result.Code == ReturnCode.SUCCESS) { var DOlist = result.Object as List <CMS_Delivery>; if (DOlist != null && DOlist.Count > 0) { foreach (var row in DOlist) { var data = new CMSDeliveryWModels(); data.Delivery_ID = row.Delivery_ID; data.Delivery_Order_No = row.Delivery_Order_No; data.Update_On = DateUtil.ToDisplayDateTime(row.Update_On); data.Record_Status = row.Record_Status; List <CMSDeliveryDetailWModels> details = new List <CMSDeliveryDetailWModels>(); foreach (var row2 in row.CMS_Delivery_Detail as List <CMS_Delivery_Detail> ) { var detail = new CMSDeliveryDetailWModels(); detail.CMS_Delivery_Detail_ID = row2.CMS_Delivery_Detail_ID; if (!string.IsNullOrEmpty(row2.Product_Code)) { detail.Product_ID = 1; //remove after improve code in mobile detail.Product_Code = row2.Product_Code; detail.Product_Name = ""; } detail.No_Of_Containers = row2.No_Of_Containers.HasValue ? row2.No_Of_Containers.Value : 1; details.Add(detail); } data.DeliveryDetail = details; SyncDatas.Add(data); } } } return(Json(SyncDatas, JsonRequestBehavior.AllowGet)); }
public void TestSyncUp(string pDeliveryID = "", string pDrumCode = "", string pDeliveryDetailID = "") { var currentdate = StoredProcedure.GetCurrentDate(); var cmsService = new MobileService(); CMS_Delivery _Delivery = new CMS_Delivery(); var cri = new MobileCri(); cri.Delivery_ID = NumUtil.ParseInteger(pDeliveryID); var result = cmsService.GetCMSDelivery(cri); if (result.Code == ReturnCode.SUCCESS) { var deliverys = result.Object as List <CMS_Delivery>; if (deliverys != null && deliverys.Count() == 1) { _Delivery = deliverys.FirstOrDefault(); _Delivery.Delivery_ID = _Delivery.Delivery_ID; _Delivery.Delivery_Order_No = _Delivery.Delivery_Order_No; _Delivery.Completed = true; _Delivery.Update_By = "Test"; _Delivery.Update_On = currentdate; List <CMS_Delivery_Detail> _Details = new List <CMS_Delivery_Detail>(); CMS_Delivery_Detail _Detail = new CMS_Delivery_Detail(); _Detail.CMS_Delivery_Detail_ID = NumUtil.ParseInteger(pDeliveryDetailID);; _Detail.Delivery_ID = _Delivery.Delivery_ID; _Detail.Drum_Code = pDrumCode; _Detail.Update_By = "Test"; _Detail.Update_On = currentdate; _Detail.Date_Delivered = currentdate; _Details.Add(_Detail); _Delivery.CMS_Delivery_Detail = _Details; } } var result2 = cmsService.UpdateCMSDelivery(_Delivery); }
public JsonResult SyncUpDeliverysByRecord(CMSDeliveryWModels SyncUpData) { var currentdate = StoredProcedure.GetCurrentDate(); var cmsService = new MobileService(); Boolean IsPass = false; var _result = new wResult(); if (SyncUpData != null) { IsPass = false; CMS_Delivery _Delivery = new CMS_Delivery(); var cri = new MobileCri(); cri.Delivery_ID = SyncUpData.Delivery_ID; var result = cmsService.GetCMSDelivery(cri); if (result.Code == ReturnCode.SUCCESS) { var deliverys = result.Object as List <CMS_Delivery>; if (deliverys != null && deliverys.Count() == 1) { IsPass = true; _Delivery = deliverys.FirstOrDefault(); _Delivery.Delivery_ID = SyncUpData.Delivery_ID; _Delivery.Delivery_Order_No = SyncUpData.Delivery_Order_No; _Delivery.Completed = true; _Delivery.Update_By = SyncUpData.Update_By; _Delivery.Update_On = currentdate; List <CMS_Delivery_Detail> _Details = new List <CMS_Delivery_Detail>(); if (SyncUpData.DeliveryDetail != null) { foreach (var row2 in SyncUpData.DeliveryDetail) { CMS_Delivery_Detail _Detail = new CMS_Delivery_Detail(); _Detail.CMS_Delivery_Detail_ID = row2.CMS_Delivery_Detail_ID; _Detail.Delivery_ID = row2.Delivery_ID; _Detail.Drum_Code = row2.Drum_Code.Trim(); _Detail.Update_By = SyncUpData.Update_By; _Detail.Update_On = currentdate; _Detail.Date_Delivered = DateUtil.ToDate(row2.Date_Delivered); _Details.Add(_Detail); } _Delivery.CMS_Delivery_Detail = _Details; } } if (!IsPass) { _result.status = "1"; _result.message = "Error! can not found Delivery"; return(Json(new { Data = _result }, JsonRequestBehavior.AllowGet)); } var result2 = cmsService.UpdateCMSDelivery(_Delivery); if (result2.Code == ReturnCode.SUCCESS) { _result.status = "200"; _result.message = "Update successfully"; } else { _result.status = "1"; _result.message = "Error! can not update data"; } } } else { _result.status = "1"; _result.message = "Error! can not update data"; } return(Json(new { Data = _result }, JsonRequestBehavior.AllowGet)); }