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);
}
