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