public IHttpActionResult saveAsnOrder(whar1 AsnOrder)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
int TrxNo = AsnOrderHelper.SaveAsnOrder(AsnOrder);
if (TrxNo <= 0)
{
return(BadRequest());
}
return(Ok(TrxNo));
}
public static whar1 GetAsnOrder(int TrxNo)
{
var connection = ApiService.dbConnection;
whar1 myAsnOrder = null;
try
{
connection.Open();
myAsnOrder = connection.QueryFirstOrDefault <whar1>(qryAsnOrder.selectAsnOrder, new { TrxNo });
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(myAsnOrder);
}
public static int SaveAsnOrder(whar1 AsnOrder)
{
var connection = ApiService.dbConnection;
int TrxNo = AsnOrder.TrxNo;
string AsnOrderNo = AsnOrder.AsnOrderNo;
string SupplierAsnNo = AsnOrder.SupplierAsnNo;
string SupplierCode = AsnOrder.SupplierCode;
DateTime?AsnOrderDate = AsnOrder.AsnOrderDate;
string Remark = AsnOrder.Remark;
string WarehouseCode = AsnOrder.WarehouseCode;
string WorkStation = ApiService.HostName;
string StatusCode = AsnOrder.StatusCode;
string CreateBy = ApiService.UserId;
string UpdateBy = ApiService.UserId;
try
{
connection.Open();
if (TrxNo <= 0)
{
//insert asn Order
TrxNo = connection.ExecuteScalar <int>(qryAsnOrder.insertAsnOrder,
new
{
AsnOrderNo,
SupplierAsnNo,
SupplierCode,
AsnOrderDate,
Remark,
WarehouseCode,
WorkStation,
StatusCode,
CreateBy,
UpdateBy
},
null, null, CommandType.StoredProcedure);
}
else
{
//update asn order
connection.Execute(qryAsnOrder.updateAsnOrder,
new
{
TrxNo,
AsnOrderNo,
SupplierAsnNo,
SupplierCode,
AsnOrderDate,
Remark,
WarehouseCode,
WorkStation,
StatusCode,
UpdateBy
},
null, null, CommandType.StoredProcedure);
}
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(TrxNo);
}
