public int?AddSupplier(Supplier supplier, List <ValidationMessage> validationMessages)
{
try
{
using (IDbConnection conn = OpenConnection())
{
var parameters = new DynamicParameters();
parameters.Add("@Id", supplier.Id);
parameters.Add("@StationId", supplier.StationId);
parameters.Add("@UserId", supplier.UserId);
parameters.Add("@Address", supplier.Address);
parameters.Add("@MobileNumber", supplier.MobileNumber);
parameters.Add("@LogNumber", supplier.LogNumber);
parameters.Add("@FirstName", supplier.FirstName);
parameters.Add("@LastName", supplier.LastName);
parameters.Add("@IsActive", supplier.IsActive);
return(conn.Query <int?>("USP_UpsertSupplier", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault());
}
}
catch (SqlException sqlException)
{
SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin");
return(null);
}
}
public int?AddUser(UserDetails userDetails, List <ValidationMessage> validationMessages)
{
try
{
using (IDbConnection conn = OpenConnection())
{
byte[] encData_byte;
encData_byte = System.Text.Encoding.UTF8.GetBytes(userDetails.Password);
string encodedData = Convert.ToBase64String(encData_byte);
var parameters = new DynamicParameters();
parameters.Add("@Id", userDetails.Id);
parameters.Add("@UserName", userDetails.Username);
parameters.Add("@Email", userDetails.Email);
parameters.Add("@Password", encodedData);
parameters.Add("@IsActive", userDetails.IsActive);
parameters.Add("@IsAdmin", userDetails.IsAdmin);
return(conn.Query <int?>("USP_UpsertUser", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault());
}
}
catch (SqlException sqlException)
{
SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to create the user, please contact Admin");
return(null);
}
}
public List <Station> GetStationsList(List <ValidationMessage> validationMessages)
{
try
{
using (IDbConnection conn = OpenConnection())
{
return(conn.Query <Station>("USP_GetStationsList").ToList());
}
}
catch (SqlException sqlException)
{
SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin");
return(new List <Station>());
}
}
public List <Supplier> GetSuppliersList(int stationId, List <ValidationMessage> validationMessages)
{
try
{
using (IDbConnection conn = OpenConnection())
{
var parameters = new DynamicParameters();
parameters.Add("@StationId", stationId);
return(conn.Query <Supplier>("USP_GetSuppliers", parameters, commandType: CommandType.StoredProcedure).ToList());
}
}
catch (SqlException sqlException)
{
SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin");
return(new List <Supplier>());
}
}
public bool?DeleteSupplier(int suplierId, List <ValidationMessage> validationMessages)
{
try
{
using (IDbConnection conn = OpenConnection())
{
var parameters = new DynamicParameters();
parameters.Add("@SuplierId", suplierId);
parameters.Add("@IsActive", false);
conn.Query <bool?>("USP_DeleteSuplier", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault();
return(true);
}
}
catch (SqlException sqlException)
{
SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin");
return(false);
}
}
