public async Task AddGiAgencyMaster(GiAgencyMaster prodData) { var maxId = await WithConnection(async c => { return await c.QueryAsync<int>("SELECT max(AgencyIndex) FROM GI_AgencyMaster"); }); //Setting Primary Key if (maxId.SingleOrDefault() == 0) { prodData.AgencyIndex = 1; } else { prodData.AgencyIndex = maxId.SingleOrDefault() + 1; } //Filling Other Records like User Id, Creation & Update Date prodData.CreateUserIndex = 1; //Later Logged in User prodData.UpdateUserIndex = 1; //Later Logged in User prodData.CreateDateTime = DateTime.Now; prodData.UpdateDateTime = DateTime.Now; await WithConnection(async c => { return await c.QueryAsync<int>(SQLConstants.InsertGiAgencyMaster, prodData); }); }
public async Task<IHttpActionResult> Create(GiAgencyMaster prodData) { if (prodData != null) { await GiAgencyMasterDA.AddGiAgencyMaster(prodData); return Ok(); } return BadRequest("Request cannot be NULL"); }