public static Model.mdlResultList InsertCustomerImageType(List <Model.mdlCustomerImageType> lCustomerImageType)
{
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
mdlResult.Result = Manager.DataFacade.DTSQLListInsert(lCustomerImageType, "CustomerImageType");
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);
}
public static Model.mdlResultList InsertPOSMStock(List <Model.mdlPOSMStock> lPOSMStockParam)
{
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
mdlResult.Result = Manager.DataFacade.DTSQLListInsert(lPOSMStockParam, "POSMStock");
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);
}
public static Model.mdlResultList InsertCompetitorActivityVisit(List <Model.mdlCompetitorActivityVisit> lCompetitorActivityVisitParam)
{
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
mdlResult.Result = Manager.DataFacade.DTSQLListInsert(lCompetitorActivityVisitParam, "CompetitorActivityVisit");
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);
}
public static Model.mdlResultList InsertLogVisit(List <Model.mdlLogVisitParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@Date", SqlDbType = SqlDbType.NVarChar, Value = lParam.Date
},
new SqlParameter()
{
ParameterName = "@Type", SqlDbType = SqlDbType.NVarChar, Value = lParam.Type
},
};
string query = @"INSERT INTO LogVisit (VisitID, CustomerID, Date, Type) " +
"VALUES (@VisitID, @CustomerID, @Date, @Type) "; //004
mdlResult.Result = Manager.DataFacade.DTSQLVoidCommand(query, sp); //010
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);
}
public static Model.mdlResultList UploadInsertDailyCost(List <Model.mdlDailyCostParam> lParamlist, TransactionScope scope)
{
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
bool lCheckDailyCostID = CheckbyDailyCostID(lParamlist.FirstOrDefault().CostID);
if (lCheckDailyCostID == false)
{
mdlResult.Result = "|| DailyCostID : " + lParamlist.FirstOrDefault().DailyCostID + " " + "|| IDExist ||";
mdlResultList.Add(mdlResult);
}
else
{
mdlResult.Result = Manager.DataFacade.DTSQLListInsert(lParamlist, "DailyCost");
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 InsertCustomerImage(List <Model.mdlCustomerImageParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
string UploadImagePath = ConfigurationManager.AppSettings["imagePath"];
DateTime dateTime = DateTime.UtcNow.Date;
string day = dateTime.ToString("dd");
string month = dateTime.ToString("MM");
string year = dateTime.ToString("yyyy");
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
bool lCheckImageID = CheckbyCustomerImageID(lParam.ImageID);
if (lCheckImageID == false)
{
DeleteCustomerImage(lParam.ImageID);
//mdlResult.Result = "|| ImageID : " + lParam.ImageID + " " + "|| IDExist ||"; //008
//mdlResultList.Add(mdlResult);
}
//WRITE IMAGE TO SPECIFIC FOLDER
//byte[] data = System.Convert.FromBase64String(lParam.ImageBase64);
//System.IO.MemoryStream ms = new System.IO.MemoryStream(data);
//System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
//string url = "C:\\inetpub\\wwwroot\\FABER_Transport\\Images\\CustomerImage\\" + lParam.ImageType + "\\" + lParam.ImageID + ".jpg";
//File.WriteAllBytes(url, data);
string newUploadImagePath = UploadImagePath.Replace("//", "\\") + year + "\\" + month + "\\" + day + "\\" + lParam.ImageBase64;
if (lParam.Longitude == null)
{
lParam.Longitude = "0";
}
if (lParam.Latitude == null)
{
lParam.Latitude = "0";
}
List <SqlParameter> sp = new List <SqlParameter>();
sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ImageID", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageID
},
new SqlParameter()
{
ParameterName = "@ImageDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageDate
},
new SqlParameter()
{
ParameterName = "@ImageBase64", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageBase64
},
new SqlParameter()
{
ParameterName = "@ImageType", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageType
},
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@WarehouseID", SqlDbType = SqlDbType.NVarChar, Value = lParam.WarehouseID
},
new SqlParameter()
{
ParameterName = "@DocNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.DocNumber
},
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@ImagePath", SqlDbType = SqlDbType.NVarChar, Value = ""
},
new SqlParameter()
{
ParameterName = "@Longitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Longitude
},
new SqlParameter()
{
ParameterName = "@Latitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Latitude
}
};
string query = @"INSERT INTO CustomerImage (ImageID, ImageDate, ImageBase64, ImageType, CustomerID,WarehouseID, DocNumber, VisitID, ImagePath, Longitude, Latitude) " +
"VALUES (@ImageID, @ImageDate, @ImageBase64, @ImageType, @CustomerID,@WarehouseID, @DocNumber, @VisitID, @ImagePath, @Longitude, @Latitude) "; //004
mdlResult.Result = Manager.DataFacade.DTSQLVoidCommand(query, sp); //010
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);
}
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 InsertDailyCost(List <Model.mdlDailyCostParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
//bool lCheckDailyCostID = CheckbyDailyCostID(lParamlist.FirstOrDefault().DailyCostID);
foreach (var cost in lParamlist)
{
bool lCheckDailyCostID = CheckbyDailyCostID(cost.DailyCostID);
if (lCheckDailyCostID == false)
{
mdlResult.Result = "|| DailyCostID : " + lParamlist.FirstOrDefault().DailyCostID + " " + "|| IDExist ||";
mdlResultList.Add(mdlResult);
}
else
{
cost.CreatedBy = cost.EmployeeID;
cost.CreatedDate = DateTime.Now;
cost.LastUpdatedBy = cost.EmployeeID;
cost.LastUpdatedDate = DateTime.Now;
var listCost = new List <Model.mdlDailyCostParam>();
listCost.Add(cost);
mdlResult.Result = Manager.DataFacade.DTSQLListInsert(listCost, "DailyCost");
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);
}
public static Model.mdlResultList UpdateReturOrder(List <Model.mdlReturOrderParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
if (lParam.ReturStatus == "")
{
var mdlResult = new Model.mdlResult();
mdlResult.Result = "|| " + "Update Retur Order : " + lParam.ReturNumber + " and CustomerID : " + lParam.CustomerID + " || " + " 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 = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@ReturStatus", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReturStatus
},
new SqlParameter()
{
ParameterName = "@ReturDate", SqlDbType = SqlDbType.DateTime, Value = lParam.ReturDate
},
new SqlParameter()
{
ParameterName = "@Description", SqlDbType = SqlDbType.NVarChar, Value = lParam.Description
},
new SqlParameter()
{
ParameterName = "@Signature", SqlDbType = SqlDbType.NVarChar, Value = lParam.Signature
},
new SqlParameter()
{
ParameterName = "@IsPrint", SqlDbType = SqlDbType.NVarChar, Value = lParam.IsPrint
},
new SqlParameter()
{
ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = lParam.Remark
}, //003
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID
},
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID
},
new SqlParameter()
{
ParameterName = "@ReceivedDate", SqlDbType = SqlDbType.DateTime, Value = lParam.ReceivedDate
}
};
string query = @"UPDATE ReturOrder SET
CustomerID = @CustomerID,
ReturStatus = @ReturStatus,
ReturDate = @ReturDate,
Description = @Description,
Signature = @Signature,
IsPrint = @IsPrint,
Remark = @Remark,
EmployeeID = @EmployeeID,
VisitID = @VisitID,
BranchID = @BranchID,
ReceivedDate = @ReceivedDate
WHERE ReturNumber = @ReturNumber ";
mdlResult.Result = "|| " + "Update Retur Order : " + lParam.ReturNumber + " and CustomerID : " + lParam.CustomerID + " || " + 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 InsertReturOrderDetail(List <Model.mdlReturOrderDetailParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
if (lParam.Quantity == "" || lParam.Quantity == null)
{
lParam.Quantity = "0";
}
var mdlResult = new Model.mdlResult();
bool lCheckReturNumberAndProductID = CheckbyReturNumberAndProductID(lParam.ReturNumber, lParam.ProductID);
if (lCheckReturNumberAndProductID == false)
{
mdlResult.Result = " || ReturNumber : " + lParam.ReturNumber + " and ProductID : " + lParam.ProductID + " " + "|| IDExist ||";
mdlResultList.Add(mdlResult);
}
else
{
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 = @"INSERT INTO ReturOrderDetail (ReturNumber, ProductID, UOM, Quantity, QuantityReal, ArticleNumber,ReasonID) " +
"VALUES (@ReturNumber, @ProductID, @UOM, @Quantity, @QuantityReal, @ArticleNumber, @ReasonID)";
mdlResult.Result = " || ReturNumber : " + lParam.ReturNumber + " and ProductID : " + 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 InsertReturOrder(List <Model.mdlReturOrderParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
bool lCheckReturNumber = CheckbyReturNumber(lParam.ReturNumber);
if (lCheckReturNumber == false)
{
mdlResult.Result = " || ReturNumber : " + lParam.ReturNumber + " " + "|| IDExist ||";
mdlResultList.Add(mdlResult);
}
else
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ReturNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReturNumber
},
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID
},
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID
},
new SqlParameter()
{
ParameterName = "@ReturDate", SqlDbType = SqlDbType.Date, Value = lParam.ReturDate
},
new SqlParameter()
{
ParameterName = "@ReturStatus", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReturStatus
},
new SqlParameter()
{
ParameterName = "@Description", SqlDbType = SqlDbType.NVarChar, Value = lParam.Description
},
new SqlParameter()
{
ParameterName = "@Signature", SqlDbType = SqlDbType.NVarChar, Value = lParam.Signature
},
new SqlParameter()
{
ParameterName = "@IsPrint", SqlDbType = SqlDbType.NVarChar, Value = lParam.IsPrint
},
new SqlParameter()
{
ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = lParam.Remark
},
new SqlParameter()
{
ParameterName = "@ReceivedDate", SqlDbType = SqlDbType.DateTime, Value = lParam.ReceivedDate
},
new SqlParameter()
{
ParameterName = "@IsNewRetur", SqlDbType = SqlDbType.NVarChar, Value = lParam.IsNewRetur
}
};
string query = @"INSERT INTO ReturOrder (ReturNumber, CustomerID, EmployeeID, VisitID, BranchID, ReturDate, ReturStatus, Description, Signature, IsPrint, Remark, ReceivedDate, IsNewRetur) " +
"VALUES (@ReturNumber, @CustomerID, @EmployeeID, @VisitID, @BranchID, @ReturDate, @ReturStatus, @Description, @Signature, @IsPrint, @Remark, @ReceivedDate, @IsNewRetur)";
mdlResult.Result = "|| " + "Insert Retur Number " + lParam.ReturNumber + " || " + 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 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 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);
}
//BulkCopy Method
//public static Model.mdlResultList InsertCostVisit(List<Model.mdlCostVisit> lParamlist)
//{
// var mdlResultList = new List<Model.mdlResult>();
// var mdlResult = new Model.mdlResult();
// //bool lCheckDailyCostID = CheckbyDailyCostID(lParamlist.FirstOrDefault().DailyCostID);
// foreach (var cost in lParamlist)
// {
// bool lCheckDailyCostID = CheckCostVisitID(cost.VisitID,cost.CostID);
// if (lCheckDailyCostID == false)
// {
// mdlResult.Result = "|| VisitID : " + cost.VisitID + " and CostID : " + cost.CostID + " || Already Exist ||";
// mdlResultList.Add(mdlResult);
// }
// else
// {
// var listCost = new List<Model.mdlCostVisit>();
// listCost.Add(cost);
// mdlResult.Result = Manager.DataFacade.DTSQLListInsert(listCost, "CostVisit");
// 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;
//}
//SQL INSERT METHOD
public static Model.mdlResultList InsertCostVisit(List <Model.mdlCostVisit> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
bool lCheckDailyCostID = CheckCostVisitID(lParam.VisitID, lParam.CostID);
if (lCheckDailyCostID == false)
{
mdlResult.Result = "|| VisitID : " + lParam.VisitID + " and CostID : " + lParam.CostID + " || Already Exist ||";
mdlResultList.Add(mdlResult);
}
else
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@CostID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CostID
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID
},
new SqlParameter()
{
ParameterName = "@Value", SqlDbType = SqlDbType.NVarChar, Value = lParam.Value
}
};
string query = @"INSERT INTO CostVisit (VisitID, CostID, Value, EmployeeID, BranchID) " +
"VALUES (@VisitID, @CostID, @Value, @EmployeeID, @BranchID) ";
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);
}
public static Model.mdlResultList InsertTracking(Model.mdlTrackingParam lParam)
{
var newMdlResultList = new Model.mdlResultList();
var mdlResultList = new List <Model.mdlResult>();
var mdlResult = new Model.mdlResult();
bool lCheckImageID = CheckbyTrackingID(lParam.TrackingID);
if (lCheckImageID == false)
{
mdlResult.Result = "|| TrackingID : " + lParam.TrackingID + " " + "|| IDExist ||"; //006
}
else
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@TrackingID", SqlDbType = SqlDbType.NVarChar, Value = lParam.TrackingID
},
new SqlParameter()
{
ParameterName = "@TrackingDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.TrackingDate
},
new SqlParameter()
{
ParameterName = "@VehicleID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleID
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID
},
new SqlParameter()
{
ParameterName = "@Longitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Longitude
},
new SqlParameter()
{
ParameterName = "@Latitude", SqlDbType = SqlDbType.NVarChar, Value = lParam.Latitude
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID
},
};
string query = @"INSERT INTO LiveTracking (TrackingID, TrackingDate, VehicleID, EmployeeID, Longitude, Latitude, BranchID) " +
"VALUES (@TrackingID, @TrackingDate, @VehicleID, @EmployeeID, @Longitude, @Latitude, @BranchID) ";
mdlResult.Result = "|| " + "Insert Tracking ID " + lParam.TrackingID + " || " + Manager.DataFacade.DTSQLVoidCommand(query, sp);
if (mdlResult.Result.Contains("1") == true)
{
mdlResultList.Add(mdlResult);
}
else
{
string ResultSubstring;
if (mdlResult.Result.Length > 500)
{
ResultSubstring = mdlResult.Result.Substring(0, 500);
//mdlResult.Result = ResultSubstring;
mdlResultList.Add(mdlResult);
}
}
}
newMdlResultList.ResultList = mdlResultList;
return(newMdlResultList);
}
public static Model.mdlResultList UploadInsertCustomerImage(List <Model.mdlCustomerImageParam> lParamlist, TransactionScope scope)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
bool lCheckImageID = CheckbyCustomerImageID(lParam.ImageID);
if (lCheckImageID == false)
{
DeleteCustomerImage(lParam.ImageID);
//mdlResult.Result = "|| ImageID : " + lParam.ImageID + " " + "|| IDExist ||"; //008
//mdlResultList.Add(mdlResult);
}
else
{
//WRITE IMAGE TO SPECIFIC FOLDER
//byte[] data = System.Convert.FromBase64String(lParam.ImageBase64);
//System.IO.MemoryStream ms = new System.IO.MemoryStream(data);
//System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
//string url = "C:\\inetpub\\wwwroot\\FABER_Transport\\Images\\CustomerImage\\" + lParam.ImageType + "\\" + lParam.ImageID + ".jpg";
//File.WriteAllBytes(url, data);
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ImageID", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageID
},
new SqlParameter()
{
ParameterName = "@ImageDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageDate
},
new SqlParameter()
{
ParameterName = "@ImageBase64", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageBase64
},
new SqlParameter()
{
ParameterName = "@ImageType", SqlDbType = SqlDbType.NVarChar, Value = lParam.ImageType
},
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@WarehouseID", SqlDbType = SqlDbType.NVarChar, Value = lParam.WarehouseID
},
new SqlParameter()
{
ParameterName = "@DocNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.DocNumber
}, //004
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
}, //002
new SqlParameter()
{
ParameterName = "@ImagePath", SqlDbType = SqlDbType.NVarChar, Value = ""
}
};
string query = @"INSERT INTO CustomerImage (ImageID, ImageDate, ImageBase64, ImageType, CustomerID,WarehouseID, DocNumber, VisitID, ImagePath) " +
"VALUES (@ImageID, @ImageDate, @ImageBase64, @ImageType, @CustomerID,@WarehouseID, @DocNumber, @VisitID, @ImagePath) "; //004
mdlResult.Result = Manager.DataFacade.DTSQLVoidCommand(query, sp); //010
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 UploadDeposit(List <Model.mdlDepositParam> lParamlist)
{
var mdlResultList = new List <Model.mdlResult>();
foreach (var lParam in lParamlist)
{
var mdlResult = new Model.mdlResult();
List <SqlParameter> sp = new List <SqlParameter>()
{
//header
new SqlParameter()
{
ParameterName = "@DepositID", SqlDbType = SqlDbType.NVarChar, Value = lParam.DepositID
},
new SqlParameter()
{
ParameterName = "@VisitID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VisitID
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.EmployeeID
},
new SqlParameter()
{
ParameterName = "@Status", SqlDbType = SqlDbType.NVarChar, Value = lParam.Status
},
new SqlParameter()
{
ParameterName = "@ReceivedDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.ReceivedDate
},
new SqlParameter()
{
ParameterName = "@Description", SqlDbType = SqlDbType.NVarChar, Value = lParam.Description
},
new SqlParameter()
{
ParameterName = "@CustomerID", SqlDbType = SqlDbType.NVarChar, Value = lParam.CustomerID
},
new SqlParameter()
{
ParameterName = "@CreatedBy", SqlDbType = SqlDbType.NVarChar, Value = lParam.CreatedBy
},
//new SqlParameter() {ParameterName = "@CreatedDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.CreatedDate},
new SqlParameter()
{
ParameterName = "@LastUpdateBy", SqlDbType = SqlDbType.NVarChar, Value = lParam.LastUpdateBy
},
//new SqlParameter() {ParameterName = "@LastDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.LastDate}
//detail
new SqlParameter()
{
ParameterName = "@Note", SqlDbType = SqlDbType.NVarChar, Value = lParam.Note
},
new SqlParameter()
{
ParameterName = "@Amount", SqlDbType = SqlDbType.Decimal, Value = lParam.Amount
},
new SqlParameter()
{
ParameterName = "@Seq", SqlDbType = SqlDbType.NVarChar, Value = lParam.Seq
},
new SqlParameter()
{
ParameterName = "@DepositTypeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.DepositTypeID
}
};
String query = @"BEGIN TRAN
DELETE FROM [DepositDetail]
WHERE DepositID = @DepositID
INSERT INTO[DepositDetail] (
DepositID
,Note
,Amount
,Seq
,DepositTypeID
)
VALUES(
@DepositID
,@Note
,@Amount
,@Seq
,@DepositTypeID
)
UPDATE [Deposit] SET
VisitID = @VisitID
,EmployeeID = @EmployeeID
,Status = @Status
,ReceivedDate = @ReceivedDate
,Description = @Description
,CustomerID = @CustomerID
,LastUpdateBy = @LastUpdateBy
,LastDate = GETDATE()
WHERE DepositID = @DepositID
IF @@rowcount = 0
BEGIN
INSERT INTO [Deposit] (
DepositID
,VisitID
,EmployeeID
,Status
,ReceivedDate
,Description
,CustomerID
,CreatedBy
,CreatedDate
,IsSMS
)
VALUES (
@DepositID
,@VisitID
,@EmployeeID
,@Status
,@ReceivedDate
,@Description
,@CustomerID
,@CreatedBy
,GETDATE()
,0
)
END
COMMIT TRAN";
mdlResult.Result = Manager.DataFacade.DTSQLVoidCommand(query, sp);
if (mdlResult.Result == "1")
{
// setelah upload berhasil akan memanggil API sms gateway
// sebelumnya cek dahulu apakah status smsnya berhasil atau tidak
List <SqlParameter> sp_checkstatus = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@DepositID", SqlDbType = SqlDbType.NVarChar, Value = lParam.DepositID
}
};
string query_checkstatus = "SELECT IsSMS FROM DEPOSIT WHERE DepositID = @DepositID ";
DataTable dtCheck = DataFacade.DTSQLCommand(query_checkstatus, sp_checkstatus);
int statusSMS = 0;
foreach (DataRow rowCheck in dtCheck.Rows)
{
statusSMS = Convert.ToInt32(rowCheck["IsSMS"].ToString());
}
if (statusSMS == 1)
{
// do nothing
mdlResult.ResultValue = "UPLOAD SUCCESS";
}
else
{
// ambil company name
string CompanyName = "";
List <SqlParameter> spCompany = new List <SqlParameter>()
{
};
string qryCompany = "SELECT * FROM Company WHERE CompanyID = 'BPR'";
DataTable dtCompany = DataFacade.DTSQLCommand(qryCompany, spCompany);
foreach (DataRow rowCompany in dtCompany.Rows)
{
CompanyName = rowCompany["CompanyName"].ToString();
}
//default testing
string MsisdnSmsGateway = "82298332125";
//string MsisdnSmsGateway = lParam.CustomerMobilephone1;
string rekeningNo = lParam.BankAccountNumber;
string lTime = DateTime.Now.ToString("yyyyMMddhhmmss");
double value = lParam.Amount;
string valueDeli = String.Format(CultureInfo.InvariantCulture, "{0:0,0}", value);
string urlAPI = ConfigurationManager.AppSettings["UrlAPISmsGateway"];
string UserSmsGateway = ConfigurationManager.AppSettings["UserSmsGateway"];
string PasswordSmsGateway = ConfigurationManager.AppSettings["PasswordSmsGateway"];
string SenderIDSmsGateway = ConfigurationManager.AppSettings["SenderIDSmsGateway"];
string MessageSmsGateway = CompanyName + "\n" +
"SUKSES No=" + lParam.DepositID + "\n" +
"Setoran" + "\n" +
"Rek=" + rekeningNo + "\n" +
"an." + lParam.CustomerName + "\n" +
"Tgl=" + lTime + "\n" +
"Nom=Rp." + valueDeli;
var dict = new Dictionary <string, string>();
dict.Add("user", UserSmsGateway);
dict.Add("password", PasswordSmsGateway);
dict.Add("senderid", SenderIDSmsGateway);
dict.Add("message", MessageSmsGateway);
dict.Add("msisdn", MsisdnSmsGateway);
string paramSMS = StringFacade.urlencodeString(dict);
string resultSMS = StringFacade.PostAPISMSGateway(urlAPI, paramSMS);
var DesResult = JsonConvert.DeserializeObject <Model.mdlResultSmsGateway>(resultSMS);
if (DesResult.status == "SUCCESS")
{
mdlResult.ResultValue = "UPLOAD SUCCESS";
//ketika sms berhasil, update status isSMS
List <SqlParameter> sp_sms = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@DepositID", SqlDbType = SqlDbType.NVarChar, Value = lParam.DepositID
}
};
string query_sms = "UPDATE DEPOSIT SET IsSMS = 1 WHERE DepositID = @DepositID";
var mdlResultSms = new Model.mdlResult();
Manager.DataFacade.DTSQLVoidCommand(query_sms, sp_sms);
//simpan juga log smsnya
LogFacade.InsertLogSMS_Service(urlAPI, paramSMS, resultSMS);
}
else
{
mdlResult.ResultValue = "UPLOAD SUCCESS but SMS FAILED";
}
}
}
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 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);
}