public static whst1 GetStoreType(string StoreTypeCode)
{
var connection = ApiService.dbConnection;
whst1 myStoreType = null;
try
{
connection.Open();
myStoreType = connection.QueryFirst <whst1>(qryStoreType.selectStoreType, new { StoreTypeCode });
}
catch (Exception) { return(null); }
finally { connection.Close(); }
return(myStoreType);
}
public IHttpActionResult SaveStoreType(whst1 StoreType)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
int afRowCnt = StoreTypeHelper.SaveStoreType(StoreType);
if (afRowCnt == 0)
{
return(BadRequest());
}
return(Ok());
}
public static int SaveStoreType(whst1 StoreType)
{
var connection = ApiService.dbConnection;
int afRecCnt = 0;
try
{
connection.Open();
string storeProcName;
int storeTypeCnt = connection.ExecuteScalar <int>(qryStoreType.selectStoreTypeCount, new { StoreTypeCode = StoreType.StoreTypeCode });
if (storeTypeCnt <= 0)
{
// set audit values
StoreType.WorkStation = ApiService.HostName;
StoreType.CreateBy = ApiService.UserId;
StoreType.CreateDateTime = ApiService.ClientDate;
StoreType.UpdateBy = ApiService.UserId;
StoreType.UpdateDateTime = ApiService.ClientDate;
// insert store type
storeProcName = qryStoreType.insertStoreType;
}
else
{
// set audit values
StoreType.WorkStation = ApiService.HostName;
StoreType.UpdateBy = ApiService.UserId;
StoreType.UpdateDateTime = ApiService.ClientDate;
// update store type
storeProcName = qryStoreType.updateStoreType;
}
var param = connection.GetStoreProcParams(storeProcName, StoreType);
afRecCnt = connection.Execute(storeProcName, param, null, null, CommandType.StoredProcedure);
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(afRecCnt);
}
