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