public static whwh1 GetWarehouse(string WarehouseCode)
{
var connection = ApiService.dbConnection;
whwh1 myWarehouse = null;
try
{
// select whwh1
myWarehouse = connection.QueryFirst <whwh1>(qryWarehouse.selectwhwh1, new { WarehouseCode });
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(myWarehouse);
}
public static int SaveWarehouse(whwh1 myWarehouse)
{
var connection = ApiService.dbConnection;
int afRowCnt = 0;
try
{
// get existing whwh1
int whCnt = connection.ExecuteScalar <int>(qryWarehouse.selectWhCount, new { WarehouseCode = myWarehouse.WarehouseCode });
// check existing whwh1
if (whCnt <= 0)
{
// set audit values
myWarehouse.CreateBy = ApiService.UserId;
myWarehouse.CreateDateTime = ApiService.ClientDate;
myWarehouse.UpdateBy = ApiService.UserId;
myWarehouse.UpdateDateTime = ApiService.ClientDate;
myWarehouse.WorkStation = ApiService.HostName;
// insert whwh1
afRowCnt = connection.Execute(qryWarehouse.insertwhwh1,
new
{
WarehouseCode = myWarehouse.WarehouseCode,
StoreTypeCode = myWarehouse.StoreTypeCode,
Address = myWarehouse.Address,
CityCode = myWarehouse.CityCode,
ContactName = myWarehouse.ContactName,
CountryCode = myWarehouse.CountryCode,
LicensedFlag = myWarehouse.LicensedFlag,
Telephone = myWarehouse.Telephone,
WarehouseName = myWarehouse.WarehouseName,
WorkStation = myWarehouse.WorkStation,
StatusCode = myWarehouse.StatusCode,
CreateBy = myWarehouse.CreateBy,
UpdateBy = myWarehouse.UpdateDateTime
}, null, null, CommandType.StoredProcedure);
}
else
{
// set audit values
myWarehouse.UpdateBy = ApiService.UserId;
myWarehouse.UpdateDateTime = ApiService.ClientDate;
myWarehouse.WorkStation = ApiService.HostName;
// update whwh2
afRowCnt = connection.Execute(qryWarehouse.updatewhwh1,
new
{
WarehouseCode = myWarehouse.WarehouseCode,
StoreTypeCode = myWarehouse.StoreTypeCode,
Address = myWarehouse.Address,
CityCode = myWarehouse.CityCode,
ContactName = myWarehouse.ContactName,
CountryCode = myWarehouse.CountryCode,
LicensedFlag = myWarehouse.LicensedFlag,
Telephone = myWarehouse.Telephone,
WarehouseName = myWarehouse.WarehouseName,
WorkStation = myWarehouse.WorkStation,
StatusCode = myWarehouse.StatusCode,
UpdateBy = myWarehouse.UpdateBy
}, null, null, CommandType.StoredProcedure);
}
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(afRowCnt);
}