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