private int AddShipNumber(List <ShipmentNumber> shipmentNumbers)
{
var cmdList = new List <SqlCommand>();
foreach (var number in shipmentNumbers)
{
cmdList.Add(SqlExtension.GetInsertSqlCmd("PrescoShipment", number));
}
var rval = SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList);
return(rval);
}
private int UpdateShipNumber(List <ShipmentNumber> shipmentNumbers)
{
var cmdlist = new List <SqlCommand>();
foreach (var shipnumber in shipmentNumbers)
{
shipnumber.Status = (int)ShipNumberStatus.Used;
shipnumber.UDate = DateTime.Now;
cmdlist.Add(SqlExtension.GetUpdateSqlCmd("PrescoShipment", shipnumber, new List <string> {
"Id"
}, "Id=@Id"));
}
var rval = SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdlist);
return(rval);
}
public int UpdateShipmentStatus(List <PrescoShipment> shipStatusRequests)
{
var updatelist = GetUpdateShipments(shipStatusRequests);
var updateCmd = new List <SqlCommand>();
foreach (var shiphistory in updatelist)
{
var shipment = new Shipment {
ST12 = shiphistory.SSH05, ST02 = shiphistory.SSH03
};
updateCmd.Add(SqlExtension.GetUpdateSqlCmd("Shipment", shipment, new List <string> {
"ST02", "ST03", "ST13"
}, "ST02=@ST02", null));
updateCmd.Add(InsertShipmentHistory(shiphistory));
}
return(SqlDbmanager.ExecuteNonQryMutiSqlCmd(updateCmd));
}
private int AddOrderLog(List <OrderRequest> request, APIHelper aPIHelper)
{
var cmdList = new List <SqlCommand>();
var prescoAPILog = MapAPILog(aPIHelper);
foreach (var item in request)
{
var orderlog = new PrescoOrderLog();
orderlog.SysId = Guid.NewGuid();
orderlog.PrescoAPILogID = prescoAPILog.SysId;
orderlog.PrescoShipID = item.ShipNo;
orderlog.GMShipID = item.OrderNo;
cmdList.Add(SqlExtension.GetInsertSqlCmd("Prescoorderlog", orderlog));
}
cmdList.Add(SqlExtension.GetInsertSqlCmd("PrescoAPILog", prescoAPILog));
var rval = SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList);
return(rval);
}
private void AddMolPayTransaction(List <TransactionAPIResponse> transactionAPIResponses, MolPayMember member)
{
var cmdList = new List <SqlCommand>();
foreach (var response in transactionAPIResponses)
{
response.SysId = Guid.NewGuid();
if (response.SettlementDate.Contains("0000-00-00"))
{
response.SettlementDate = null;
}
if (response.PaidDate.Contains("0000-00-00"))
{
response.PaidDate = null;
}
response.MemberName = member.MemberName;
response.MemberId = member.MemberId;
cmdList.Add(SqlExtension.GetInsertSqlCmd("MolPayTransaction", response));
}
SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList);
}
