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