public List <Districts> GetDistricts() { using (var con = new ConnectionGateway().GetConnection()) { return(con.Query <Districts>(sql: "[General].[GetDistricts]", param: null, commandType: CommandType.StoredProcedure).ToList()); } }
public ServiceProvider GetProvider(int id) { var parameter = new DynamicParameters(); parameter.Add(name: "@Id", value: id, dbType: DbType.Int32, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Query <ServiceProvider>(sql: "[Service].[USP_ServiceProvider]", param: parameter, commandType: CommandType.StoredProcedure).FirstOrDefault()); } }
public List <Category> GetCategory(int categoryType) { var parameter = new DynamicParameters(); parameter.Add(name: "@CategoryType", value: categoryType, dbType: DbType.Int16, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Query <Category>(sql: "[General].[USP_GetCategory]", param: parameter, commandType: CommandType.StoredProcedure).ToList()); } }
public ServiceProvider ServiceProviderLogin(string email, string password) { var parameter = new DynamicParameters(); parameter.Add(name: "@Email", value: email, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Password", value: password, dbType: DbType.String, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Query <ServiceProvider>(sql: @"[Service].[USP_ServiceProviderLogin]", param: parameter, commandType: CommandType.StoredProcedure).FirstOrDefault()); } }
public int DeleteServiceProvider(int id, int deletedBy) { var parameter = new DynamicParameters(); parameter.Add(name: "@Id", value: id, dbType: DbType.Int32, direction: ParameterDirection.Input); parameter.Add(name: "@DeletedBy", value: deletedBy, dbType: DbType.Int32, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Execute(sql: "[Admin].[USP_DeleteServiceProvider]", param: parameter, commandType: CommandType.StoredProcedure)); } }
public List <ServiceProvider> GetServiceProviders(int isPermitted, int isActive) { var parameter = new DynamicParameters(); parameter.Add(name: "@IsPermitted", value: isPermitted, dbType: DbType.Int16, direction: ParameterDirection.Input); parameter.Add(name: "@IsActive", value: isActive, dbType: DbType.Int16, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Query <ServiceProvider>(sql: "[Service].[GetServiceProviders]", param: parameter, commandType: CommandType.StoredProcedure).ToList()); } }
public int SaveCategory(Category category) { var parameter = new DynamicParameters(); parameter.Add(name: "@Name", value: category.Name, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@CategoryType", value: category.CategoryType, dbType: DbType.Int16, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Execute(sql: "[General].[USP_InsertCategory]", param: parameter, commandType: CommandType.StoredProcedure)); } }
public int UpdateProvider(ServiceProvider serviecProvider) { var parameter = new DynamicParameters(); parameter.Add(name: "@Id", value: serviecProvider.Id, dbType: DbType.Int32, direction: ParameterDirection.Input); parameter.Add(name: "@Name", value: serviecProvider.Name, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Email", value: serviecProvider.Email, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Mobile", value: serviecProvider.Mobile, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Address", value: serviecProvider.Address, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@DistrictId", value: serviecProvider.DistrictId, dbType: DbType.Int32, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Execute(sql: @"[Service].[USP_UpdateServiceProviderInfo]", param: parameter, commandType: CommandType.StoredProcedure)); } }
public int SaveUser(Users user) { var parameter = new DynamicParameters(); parameter.Add(name: "@Name", value: user.Name, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Email", value: user.Email, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Mobile", value: user.Mobile, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Password", value: user.Password, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@InstituteName", value: user.InstituteName, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@Address", value: user.Address, dbType: DbType.String, direction: ParameterDirection.Input); parameter.Add(name: "@DistrictId", value: user.DistrictId, dbType: DbType.Int32, direction: ParameterDirection.Input); using (var con = new ConnectionGateway().GetConnection()) { return(con.Execute(sql: @"[General].[USP_InsertUser]", param: parameter, commandType: CommandType.StoredProcedure)); } }