public int Register(string username, string password)
{
var oData = new Data();
var usernameSelect = new SqlParameter("@username", username);
var usernamePar = new SqlParameter("@username", username);
var passwordPar = new SqlParameter("@password", password);
var selectParameters = new SqlParameter[]
{
usernameSelect,
};
var vecParams = new SqlParameter[]
{
usernamePar,
passwordPar
};
var userExists = oData.GetDataTable("SELECT * FROM Users WHERE Username = isNull(@username, Username)", selectParameters).Rows.Count;
if (userExists > 0)
{
throw new Exception("An user with that Username already exists.");
}
return((int)oData.ExecuteWithoutResults("INSERT INTO Users (Username, Password) VALUES (@username, @password)", vecParams));
}
public int DeleteBrand(int id)
{
var oData = new Data();
var parameter = new SqlParameter("@id", id);
var vecParams = new SqlParameter[]
{
parameter
};
return(oData.ExecuteWithoutResults("DELETE Brand WHERE Id = @id", vecParams));
}
public int CreateBrand(string name)
{
var oData = new Data();
var namePar = new SqlParameter("@name", name);
var vecParams = new SqlParameter[]
{
namePar
};
return((int)oData.ExecuteWithoutResults("INSERT INTO Brand (Name) VALUES (@name)", vecParams));
}
public int EditCategory(int id, string name)
{
var oData = new Data();
var idPar = new SqlParameter("@id", id);
var namePar = new SqlParameter("@name", name);
var vecParams = new SqlParameter[]
{
idPar, namePar
};
return((int)oData.ExecuteWithoutResults("UPDATE Category SET name = @name WHERE Id = @id", vecParams));
}
public int CreateProduct(string name, double price, bool isAvailable, int brandId, int categoryId)
{
var oData = new Data();
var namePar = new SqlParameter("@name", name);
var pricePar = new SqlParameter("@price", price);
var isAvailablePar = new SqlParameter("@isAvailable", isAvailable);
var brandIdPar = new SqlParameter("@brandId", brandId);
var categoryIdPar = new SqlParameter("@categoryId", categoryId);
var vecParams = new SqlParameter[]
{
namePar, pricePar, isAvailablePar, brandIdPar, categoryIdPar
};
return((int)oData.ExecuteWithoutResults("INSERT INTO Product (Name, Price, IsAvailable, BrandId, CategoryId) VALUES (@name, @price, @isAvailable, @brandId, @categoryId)", vecParams));
}
public int EditProduct(int id, string name, double price, bool isAvailable, int brandId, int categoryId)
{
var oData = new Data();
var idPar = new SqlParameter("@id", id);
var namePar = new SqlParameter("@name", name);
var pricePar = new SqlParameter("@price", price);
var isAvailablePar = new SqlParameter("@isAvailable", isAvailable);
var brandIdPar = new SqlParameter("@brandId", brandId);
var categoryIdPar = new SqlParameter("@categoryId", categoryId);
var vecParams = new SqlParameter[]
{
idPar, namePar, pricePar, isAvailablePar, brandIdPar, categoryIdPar
};
return((int)oData.ExecuteWithoutResults("" +
"UPDATE Product SET " +
"name = @name, " +
"price = @price, " +
"IsAvailable = @isAvailable, " +
"BrandId = @brandId, " +
"CategoryId = @categoryId " +
"WHERE Id = @id", vecParams));
}
