public async Task AddASMMaster(AsmMaster prodData) { var maxId = await WithConnection(async c => { return await c.QueryAsync<int>("SELECT max(ASMIndex) FROM AsmMaster"); }); //Setting Primary Key if (maxId.SingleOrDefault() == 0) { prodData.ASMIndex = 1; } else { prodData.ASMIndex = 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.InsertASMMaster, prodData); }); }
public async Task<IHttpActionResult> Create(AsmMaster prodData) { if (prodData != null) { await AsmMasterDA.AddASMMaster(prodData); return Ok(); } return BadRequest("Request cannot be NULL"); }