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