public int Add(string commodityName, string calculationUnit)
{
name = new string[2];
value = new object[2];
name[0] = "@CommodityName";
value[0] = commodityName;
name[1] = "@CalculationUnit";
value[1] = calculationUnit;
return(db.Excute("sp_Commodity_Insert", name, value, 2));
}
public int SendMessage(string username)
{
name = new string[2];
value = new object[2];
name[0] = "@Username";
value[0] = username;
name[1] = "@Message";
value[1] = "Forgot password";
return(db.Excute("sp_Account_UpdateMessage", name, value, 2));
}
public int Add(string supplierName, string phoneNumber, string address)
{
name = new string[3];
value = new object[3];
name[0] = "@SupplierName";
value[0] = supplierName;
name[1] = "@PhoneNumber";
value[1] = phoneNumber;
name[2] = "@Address";
value[2] = address;
return(db.Excute("sp_Supplier_Insert", name, value, 3));
}
public int Add(string fullName, bool gender, DateTime birthday, string mobilePhone)
{
name = new string[4];
value = new object[4];
name[0] = "@FullName";
value[0] = fullName;
name[1] = "@Gender";
value[1] = gender;
name[2] = "@Birthday";
value[2] = birthday;
name[3] = "@MobilePhone";
value[3] = mobilePhone;
return(db.Excute("sp_Employee_Insert", name, value, 4));
}
public int Add(DateTime date, string employeeID)
{
name = new string[2];
value = new object[2];
name[0] = "@Date";
value[0] = date;
name[1] = "@EmployeeID";
value[1] = employeeID;
return(db.Excute("sp_GoodsIssueNote_Insert", name, value, 2));
}
public int Add(DateTime date, string supplierID, string employeeID)
{
name = new string[3];
value = new object[3];
name[0] = "@Date";
value[0] = date;
name[1] = "@SupplierID";
value[1] = supplierID;
name[2] = "@EmployeeID";
value[2] = employeeID;
return(db.Excute("sp_GoodsReceiptNote_Insert", name, value, 3));
}