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