public static Model.mdlResultList UpdateReturOrderDetail(List <Model.mdlReturOrderDetailParam> lParamlist) { var mdlResultList = new List <Model.mdlResult>(); foreach (var lParam in lParamlist) { if (lParam.QuantityReal == "0" || lParam.QuantityReal == "") { var mdlResult = new Model.mdlResult(); mdlResult.Result = "|| " + "Update Retur Order Detail : " + lParam.ReturNumber + " and ProductID : " + lParam.ProductID + " || " + " Cancelled"; mdlResultList.Add(mdlResult); } else { var mdlResult = new Model.mdlResult(); List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@ReturNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReturNumber }, new SqlParameter() { ParameterName = "@ProductID", SqlDbType = SqlDbType.NVarChar, Value = lParam.ProductID }, new SqlParameter() { ParameterName = "@UOM", SqlDbType = SqlDbType.NVarChar, Value = lParam.UOM }, new SqlParameter() { ParameterName = "@Quantity", SqlDbType = SqlDbType.Decimal, Value = lParam.Quantity }, new SqlParameter() { ParameterName = "@QuantityReal", SqlDbType = SqlDbType.Decimal, Value = lParam.QuantityReal }, new SqlParameter() { ParameterName = "@ArticleNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.ArticleNumber }, new SqlParameter() { ParameterName = "@ReasonID", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReasonID } }; string query = @"UPDATE ReturOrderDetail SET UOM = @UOM, Quantity=@Quantity, QuantityReal=@QuantityReal, ArticleNumber=@ArticleNumber, ReasonID = @ReasonID WHERE ReturNumber = @ReturNumber AND ProductID = @ProductID"; mdlResult.Result = "|| " + "Update Retur Order " + lParam.ReturNumber + " || " + lParam.ProductID + " || " + Manager.DataFacade.DTSQLVoidCommand(query, sp); if (mdlResult.Result.Contains("SQLSuccess") == true) { } else { string ResultSubstring; if (mdlResult.Result.Length > 500) { ResultSubstring = mdlResult.Result.Substring(0, 500); mdlResult.Result = ResultSubstring; } } mdlResultList.Add(mdlResult); } } var mdlResultListnew = new Model.mdlResultList(); mdlResultListnew.ResultList = mdlResultList; return(mdlResultListnew); }
public static Model.mdlResultList UploadUpdateDeliveryOrderDetail(List <Model.mdlDeliveryOrderDetailParam> lDODetailParamlist, TransactionScope scope) { var mdlResultList = new List <Model.mdlResult>(); var mdlResult = new Model.mdlResult(); var listDODetail = new List <Model.mdlDBDeliveryOrderDetail>(); foreach (var lDODetailParam in lDODetailParamlist) { var mdlDODetail = new Model.mdlDBDeliveryOrderDetail(); mdlDODetail.DONumber = lDODetailParam.DONumber; mdlDODetail.ProductID = lDODetailParam.ProductID; mdlDODetail.UOM = lDODetailParam.UOM; mdlDODetail.Quantity = 0; mdlDODetail.QuantityReal = Convert.ToInt32(lDODetailParam.QuantityReal); mdlDODetail.ProductGroup = ""; mdlDODetail.LotNumber = ""; mdlDODetail.ReasonID = ""; mdlDODetail.BoxID = ""; listDODetail.Add(mdlDODetail); } var listUpdateCol = new List <string>(); listUpdateCol.Add("QuantityReal"); var listOnCol = new List <string>(); listOnCol.Add("DONumber"); listOnCol.Add("ProductID"); listOnCol.Add("UOM"); mdlResult.Result = Manager.DataFacade.DTSQLListUpdate(listDODetail, "DeliveryOrderDetail", listUpdateCol, listOnCol); if (mdlResult.Result == "1") { } else { string ResultSubstring; if (mdlResult.Result.Length > 500) { ResultSubstring = mdlResult.Result.Substring(0, 500); mdlResult.Result = ResultSubstring; // } scope.Dispose(); } mdlResultList.Add(mdlResult); var mdlResultListnew = new Model.mdlResultList(); mdlResultListnew.ResultList = mdlResultList; return(mdlResultListnew); }
public static Core.Model.mdlResultList UploadJson(Core.Model.mdlUploadJsonParam lParamlist) { var mdlResultList = new Model.mdlResultList(); var listResult = new List <Model.mdlResult>(); var mdlResult = new Model.mdlResult(); try { using (TransactionScope scope = new TransactionScope()) { int err = 0; mdlResultList = DeliveryOrderFacade.UpdateDeliveryOrder(lParamlist.UploadJson.ListDeliveryOrder); mdlResultList = DeliveryOrderFacade.UpdateDeliveryOrderDetail(lParamlist.UploadJson.ListDeliveryOrderDetail); mdlResultList = VisitFacade.InsertVisit(lParamlist.UploadJson.ListVisit); if (mdlResultList.ResultList.FirstOrDefault().Result.Contains("IDExist") || mdlResultList.ResultList.FirstOrDefault().Result == "0") { err = 1; } mdlResultList = VisitFacade.InsertVisitDetail(lParamlist.UploadJson.ListVisitDetail); if (mdlResultList.ResultList.FirstOrDefault().Result.Contains("IDExist") || mdlResultList.ResultList.FirstOrDefault().Result == "0") { err = 1; } mdlResultList = CostFacade.InsertDailyCost(lParamlist.UploadJson.ListCost); if (mdlResultList.ResultList.FirstOrDefault().Result.Contains("IDExist") || mdlResultList.ResultList.FirstOrDefault().Result == "0") { err = 1; } mdlResultList = CustomerImageFacade.InsertCustomerImage(lParamlist.UploadJson.ListCustomerImage); if (mdlResultList.ResultList.FirstOrDefault().Result.Contains("IDExist") || mdlResultList.ResultList.FirstOrDefault().Result == "0") { err = 1; } mdlResultList = LogVisitFacade.InsertLogVisit(lParamlist.UploadJson.ListLogVisit); if (mdlResultList.ResultList.FirstOrDefault().Result.Contains("IDExist") || mdlResultList.ResultList.FirstOrDefault().Result == "0") { err = 1; } if (err == 0) { mdlResult.Result = "1"; scope.Complete(); } else { mdlResult.Result = "0"; } } listResult.Add(mdlResult); mdlResultList.ResultList = listResult; return(mdlResultList); } catch (TransactionAbortedException ex) { mdlResult.Result = "0"; listResult.Add(mdlResult); mdlResultList.ResultList = listResult; return(mdlResultList); } }
public static Model.mdlResultList UploadUpdateDeliveryOrder(List <Model.mdlDeliveryOrderParam> lDOParamlist, TransactionScope scope) //005,009 { var mdlResultList = new List <Model.mdlResult>(); var listDO = new List <Model.DeliveryOrder>(); var mdlResult = new Model.mdlResult(); foreach (var lDOParam in lDOParamlist) { var mdlDO = new Model.DeliveryOrder(); //Have To Be Filled mdlDO.DONumber = lDOParam.DONumber; mdlDO.CallPlanID = lDOParam.CallPlanID; mdlDO.CustomerID = lDOParam.CustomerID; mdlDO.WarehouseID = lDOParam.WarehouseID; //Have To Be Filled //Updated Data mdlDO.DOStatus = lDOParam.DOStatus; mdlDO.Signature = lDOParam.Signature; mdlDO.IsPrint = Convert.ToBoolean(lDOParam.IsPrint); mdlDO.LastDate = DateTime.Now; mdlDO.LastUpdateBy = lDOParam.EmployeeID; mdlDO.VisitID = lDOParam.VisitID; //Updated Data //additional mdlDO.CreatedDate = DateTime.Now; mdlDO.DODate = DateTime.Now; mdlDO.Description = ""; mdlDO.BranchID = lDOParam.BranchID; mdlDO.VehicleID = lDOParam.VehicleID; mdlDO.EmployeeID = lDOParam.EmployeeID; mdlDO.Remark = ""; mdlDO.CreatedBy = ""; //additional listDO.Add(mdlDO); } var listUpdateCol = new List <string>(); listUpdateCol.Add("DOStatus"); listUpdateCol.Add("Signature"); listUpdateCol.Add("IsPrint"); listUpdateCol.Add("LastDate"); listUpdateCol.Add("LastUpdateBy"); listUpdateCol.Add("VisitID"); var listOnCol = new List <string>(); listOnCol.Add("DONumber"); listOnCol.Add("CallPlanID"); listOnCol.Add("CustomerID"); mdlResult.Result = Manager.DataFacade.DTSQLListUpdate(listDO, "DeliveryOrder", listUpdateCol, listOnCol); if (mdlResult.Result == "1") { } else { string ResultSubstring; if (mdlResult.Result.Length > 500) { ResultSubstring = mdlResult.Result.Substring(0, 500); mdlResult.Result = ResultSubstring; // } scope.Dispose(); } mdlResultList.Add(mdlResult); var mdlResultListnew = new Model.mdlResultList(); mdlResultListnew.ResultList = mdlResultList; return(mdlResultListnew); }
public static Model.mdlResultList InsertBBMRatio(List <Model.mdlBBMRatioParam> lParamlist) { var mdlResultList = new List <Model.mdlResult>(); foreach (var lParam in lParamlist) { var mdlResult = new Model.mdlResult(); bool lCheckRatioBBM = CheckbyRatioID(lParam.RatioID); if (lCheckRatioBBM == false) { mdlResult.Result = "|| RatioID : " + lParam.RatioID + " " + "|| IDExist ||"; mdlResultList.Add(mdlResult); } else { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@RatioID", SqlDbType = SqlDbType.NVarChar, Value = lParam.RatioID }, new SqlParameter() { ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID }, new SqlParameter() { ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID }, new SqlParameter() { ParameterName = "@VehicleID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleID }, new SqlParameter() { ParameterName = "@Km", SqlDbType = SqlDbType.NVarChar, Value = lParam.Km }, new SqlParameter() { ParameterName = "@Liter", SqlDbType = SqlDbType.NVarChar, Value = lParam.Liter }, new SqlParameter() { ParameterName = "@Harga", SqlDbType = SqlDbType.NVarChar, Value = lParam.Harga }, new SqlParameter() { ParameterName = "@Latitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Latitude }, new SqlParameter() { ParameterName = "@Longitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Longitude }, new SqlParameter() { ParameterName = "@Date", SqlDbType = SqlDbType.NVarChar, Value = lParam.Date } }; string query = @"INSERT INTO RatioBBM (RatioID, BranchID, EmployeeID, VehicleID, Km,Liter, Harga, Latitude, Longitude, Date) " + "VALUES (@RatioID, @BranchID, @EmployeeID, @VehicleID, @Km,@Liter, @Harga, @Latitude, @Longitude, @Date) "; mdlResult.Result = Manager.DataFacade.DTSQLVoidCommand(query, sp); if (mdlResult.Result == "1") { } else { string ResultSubstring; if (mdlResult.Result.Length > 500) { ResultSubstring = mdlResult.Result.Substring(0, 500); mdlResult.Result = ResultSubstring; } } mdlResultList.Add(mdlResult); } } var mdlResultListnew = new Model.mdlResultList(); mdlResultListnew.ResultList = mdlResultList; return(mdlResultListnew); }