public static DataSet ShowRole(string UserName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select Roles.Role from Users inner join Roles on Users.IDRole = Roles.IDRole where Users.UserName = N'" +
UserName + "'", CommandType.Text));
}
public static DataSet ShowCountOrder(string UserName, string PassWord, string OrderStateName)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select dbo.CountOrder(N'" + UserName + "',N'" + OrderStateName + "')", CommandType.Text));
}
public static DataSet SubCategory_Show(string IDCategory)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select SubCategory.SubCategoryName as SubCategoryName from SubCategory where SubCategory.IDCategory = '" + IDCategory + "'", CommandType.Text));
}
public static DataSet SignIn(string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select dbo.SignIn(N'" + UserName + "',N'" + PassWord + "')", CommandType.Text));
}
public static DataSet District_Show(int Id)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select District.Type + ' ' + District.Name as DistrictName from District where District.ProvinceId = N'" + Id + "'", CommandType.Text));
}
public static DataSet IDProvince_Find(string ProvinceName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select dbo.IDProvince_Find(N'" + ProvinceName + "')", CommandType.Text));
}
public static DataSet Top5Customer()
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select * from dbo.Top5Customer()", CommandType.Text));
}
public static DataSet ShowItem(string UserName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select ItemName, SalePrice, Image from Items", CommandType.Text));
}
public static DataSet ShowCart(string UserName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select * from dbo.ShowCart(N'" + UserName + "')", CommandType.Text));
}
public static DataSet ShowTotalPrice(string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select dbo.ShowTotalPrice(N'" + UserName + "')", CommandType.Text));
}
public static DataSet All_Address_Show(string IDUser, string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select * from Address_Users where IDUser = N'" + IDUser + "'", CommandType.Text));
}
public static DataSet IDUser_Find(string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select IDUser from Users where Users.Username = N'" + UserName + "'", CommandType.Text));
}
public static DataSet IDSubCategory_Find(string SubCategoryName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select IDSubCategory from SubCategory where SubCategory.SubCategoryName = N'" + SubCategoryName + "'", CommandType.Text));
}
public static DataSet ImageUser(string UserName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select Users.Image from Users where Users.UserName = N'" + UserName + "'", CommandType.Text));
}
public static DataSet PriceItem(string ItemName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select SalePrice from Items where Items.ItemName = N'" + ItemName + "'", CommandType.Text));
}
public static DataSet User_Infor(string UserName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select UserName,FullName,Gender,DateofBirth,PhoneNumber,Email,Image from Users where Users.UserName = N'" + UserName + "'", CommandType.Text));
}
public static DataSet FindItems_ItemName(string ItemName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select * from dbo.FindItems_ItemName(N'" + ItemName + "')", CommandType.Text));
}
public static DataSet Statistic_Revenue(string UserName, string PassWord, DateTime DateStart, DateTime DateEnd)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select * from dbo.Statistic_Revenue('" + DateStart + "','" + DateEnd + "')", CommandType.Text));
}
public static DataSet FindItems_SubCategory(string SubCategory)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select * from dbo.FindItems_SubCategory(N'" + SubCategory + "')", CommandType.Text));
}
public static DataSet Province_Show()
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select Province.Type + ' ' + Province.Name as ProvinceName from Province", CommandType.Text));
}
public static DataSet UserManagement()
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select * from UserManagement", CommandType.Text));
}
public static DataSet IDDistrict_Find(string DistrictName)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select District.Id from District where District.Name = N'" + DistrictName + "'", CommandType.Text));
}
public static DataSet ImportDetailsManagement(string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select * from ImportDetailsManagement", CommandType.Text));
}
public static DataSet Ward_Show(int Id)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select Ward.Type + ' ' + Ward.Name as WardName from Ward where Ward.DistrictID = N'" + Id + "'", CommandType.Text));
}
public static DataSet OrderManagementDetail(string UserName, string PassWord, string IDBill)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select * from dbo.OrderManagementDetail (N'" + IDBill + "')", CommandType.Text));
}
public static DataSet Items_Show(string UserName, string PassWord)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.ExecuteQueryDataSet("select Items.ItemName as ItemName from Items", CommandType.Text));
}
public static DataSet Category_Show()
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.ExecuteQueryDataSet("select Category.CategoryName as CategoryName from Category", CommandType.Text));
}