public async Task <ActionResult <VendorEnquiry> > Register(VendorEnquiry vendorEnquiry)
        {
            try
            {
                var result = await Task.FromResult(vendorEnquiryRepository.VendorEnquiry(vendorEnquiry));

                //throw new Exception("Exception while fetching...");
                logger.LogInformation("end");
                return(Ok(result));
            }
            catch (Exception ex)
            {
                logger.LogError($"Exception at Login Method: {ex}");
                return(StatusCode(500, "Internal server error"));
            }
        }
        public int VendorEnquiry(VendorEnquiry vendorEnquiry)
        {
            var dbParam = new DynamicParameters();

            dbParam.Add("Name", vendorEnquiry.Name, DbType.String);
            dbParam.Add("MobileNumber", vendorEnquiry.MobileNumber, DbType.String);
            dbParam.Add("EmailID", vendorEnquiry.EmailID, DbType.String);
            dbParam.Add("Description", vendorEnquiry.Description, DbType.String);
            dbParam.Add("CityID", vendorEnquiry.CityID, DbType.Int32);
            dbParam.Add("result", null, DbType.Int32, ParameterDirection.ReturnValue);
            var result = dapper.Execute("[dbo].[SP_InsertVendorEnquiry]"
                                        , dbParam,
                                        commandType: CommandType.StoredProcedure);

            return(result);
        }