public static bool Register_Customer(string UserName, string PassWord, string FullName, string Gender, DateTime DateofBirth,
string PhoneNumber, string Email, string Image, string Province, string District, string Ward, string Street, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.MyExecuteNonQuery("execute RegisterCustomer N'" + UserName + "',N'" + PassWord + "',N'" + FullName + "',N'" + Gender + "',N'" + DateofBirth + "',N'" + PhoneNumber + "',N'" + Email + "',N'" + Image + "',N'" + Province + "',N'" + District + "',N'" + Ward + "',N'" + Street + "'", CommandType.Text, ref err));
}
public static bool Register_Seller(string UserName, string UserNameSeller, string PassWord, string PassWordSeller, string FullName, string Gender, DateTime DateofBirth,
string PhoneNumber, string Email, string Image, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("execute RegisterSeller N'" + UserNameSeller + "',N'" + PassWordSeller + "',N'" + FullName + "',N'" + Gender + "',N'" + DateofBirth + "',N'" + PhoneNumber + "',N'" + Email + "',N'" + Image + "'", CommandType.Text, ref err));
}
public static bool AddItem(string UserName, string PassWord, string ItemName, float ImportPrice, float SalePrice, string Description, string Orgin,
string IDCategory, string IDSubcategory, string Image, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec AddItems N'" + ItemName + "'," + ImportPrice + "," + SalePrice + ",N'" + Description +
"',N'" + Orgin + "',N'" + IDCategory + "',N'" + IDSubcategory + "',N'" + Image + "'", CommandType.Text, ref err));
}
public static bool ImportItems(string ItemName, string UserName, string PassWord, float Quantity, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec ImportItems N'" + ItemName + "',N'" + UserName + "'," + Quantity, CommandType.Text, ref err));
}
public static bool ChangePassWord(string UserName, string PassWordOld, string PassWordNew, string err)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.MyExecuteNonQuery("exec ChangePassWord N'" + UserName + "',N'" + PassWordOld + "',N'" + PassWordNew + "'", CommandType.Text, ref err));
}
public static bool DeleteItem(string UserName, string PassWord, string ItemName, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop();
return(_db.MyExecuteNonQuery("exec DeleteItems N'" + ItemName + "'", CommandType.Text, ref err));
}
public static bool ChangeState(string UserName, string PassWord, string IDBill, string OrderStateName, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec ChangeState N'" + UserName + "', N'" + IDBill + "',N'" + OrderStateName + "'", CommandType.Text, ref err));
}
public static bool DeleteUser(string UserNameUser, string UserName, string PassWord, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec DeleteUser N'" + UserNameUser + "'", CommandType.Text, ref err));
}
public static bool AddCart(string UserName, string PassWord, string ItemName, float SalePrice, float Quantity, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec AddCart N'" + UserName + "',N'" + ItemName + "'," + SalePrice + ", " + Quantity, CommandType.Text, ref err));
}
public static bool ChangeDefauleAddress_User(string UserName, string PassWord, string IDAddress_User, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec ChangeDefauleAddress_User N'" + UserName + "',N'" + IDAddress_User + "'", CommandType.Text, ref err));
}
public static bool Add_AddressForUser(string UserName, string PassWord, string IDUser, string Province, string District, string Ward, string Street, string PhoneNumber, string FullName, ref string err)
{
Database_VegetableShop _db = new Database_VegetableShop(UserName, PassWord);
return(_db.MyExecuteNonQuery("exec AddAddressForUser N'" + IDUser + "',N'" + Province + "',N'" + District + "',N'" + Ward + "',N'" + Street + "',N'" + PhoneNumber + "',N'" + FullName + "'", CommandType.Text, ref err));
}
