public async Task AddAgentTypeMaster(AgentTypeMaster prodData)
        {
            var maxId = await WithConnection(async c =>
            {
                return(await c.QueryAsync <int>("SELECT max(AgentTypeID) FROM AgentTypeMaster"));
            });

            //Setting Primary Key
            if (maxId.SingleOrDefault() == 0)
            {
                prodData.AgentTypeID = 1;
            }
            else
            {
                prodData.AgentTypeID = 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.InsertAgentTypeMaster, prodData));
            });
        }
        public async Task <IHttpActionResult> Create(AgentTypeMaster prodData)
        {
            if (prodData != null)
            {
                await AgentTypeMasterDA.AddAgentTypeMaster(prodData);

                return(Ok());
            }
            return(BadRequest("Request cannot be NULL"));
        }