public string Job_Type_Update(
int Job_Type_ID
, string Job_Type_Name
, int User_ID
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Job_Type_ID", SqlDbType.Int);
param[0].Value = Job_Type_ID;
param[1] = new SqlParameter("@Job_Type_Name", SqlDbType.NVarChar, 50);
param[1].Value = Job_Type_Name;
param[2] = new SqlParameter("@User_ID", SqlDbType.Int);
param[2].Value = User_ID;
string F;
F = DAL.ExecuteCommand("Sp_Job_Type_Update", param);
DAL.Close();
return(F);
}
public void UpdateStore(int ID, string Name,
string Phone, string Fax, string Address)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@Phone", SqlDbType.NVarChar, 50);
param[2].Value = Phone;
param[3] = new SqlParameter("@Fax", SqlDbType.NVarChar, 50);
param[3].Value = Fax;
param[4] = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
param[4].Value = Address;
DAL.ExecuteCommand("UpdateStore", param);
DAL.Close();
}
public void UpdateEmployee(int ID, string Name,
string Phone, string Address, int PositionID, int StoreID)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@EmpID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@EmpName", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@EmpPhone", SqlDbType.NVarChar, 50);
param[2].Value = Phone;
param[3] = new SqlParameter("@EmpAddress", SqlDbType.NVarChar, 50);
param[3].Value = Address;
param[4] = new SqlParameter("@EmppositionID", SqlDbType.Int);
param[4].Value = PositionID;
param[5] = new SqlParameter("@EmpStoreID", SqlDbType.Int);
param[5].Value = StoreID;
DAL.ExecuteCommand("Update_Employee", param);
DAL.Close();
}
public void Add_Product(int ID_Product, string Name_Product,
int Min_Product, int Max_Product, int Type_Product, int ID_Category, int ID_Company)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@ID_Product", SqlDbType.Int);
param[0].Value = ID_Product;
param[1] = new SqlParameter("@Name_Product", SqlDbType.NVarChar, 50);
param[1].Value = Name_Product;
param[2] = new SqlParameter("@Min_Product", SqlDbType.Int);
param[2].Value = Min_Product;
param[3] = new SqlParameter("@Max_Product", SqlDbType.Int);
param[3].Value = Max_Product;
param[4] = new SqlParameter("@Type_Product", SqlDbType.Int);
param[4].Value = Type_Product;
param[5] = new SqlParameter("@ID_Category", SqlDbType.Int);
param[5].Value = ID_Category;
param[6] = new SqlParameter("@ID_Company", SqlDbType.Int);
param[6].Value = ID_Company;
DAL.ExecuteCommand("ADDPRODUCT", param);
DAL.Close();
}
public void UpdateInvoice(int ID, DateTime date,
int type, int empno, int cocuno, string Total)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@Date", SqlDbType.DateTime);
param[1].Value = date;
param[2] = new SqlParameter("@Typeno", SqlDbType.Int);
param[2].Value = type;
param[3] = new SqlParameter("@empno", SqlDbType.Int);
param[3].Value = empno;
param[4] = new SqlParameter("@cocuno", SqlDbType.Int);
param[4].Value = cocuno;
param[5] = new SqlParameter("@Total", SqlDbType.NVarChar, 50);
param[5].Value = Total;
DAL.ExecuteCommand("UpdateInvoice", param);
DAL.Close();
}
public void AddCustomer(int ID, string Name,
string Phone, string Address, int TypeID)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@CustomerID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@CustomerPhone", SqlDbType.NVarChar, 50);
param[2].Value = Phone;
param[3] = new SqlParameter("@CustomerAddress", SqlDbType.NVarChar, 50);
param[3].Value = Address;
param[4] = new SqlParameter("@CocuTypeID", SqlDbType.Int);
param[4].Value = TypeID;
DAL.ExecuteCommand("AddCustomer", param);
DAL.Close();
}
public void Updatesender(int ID, string Name, int DepID, string username, string pw, int type)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@senderID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@senderName", SqlDbType.NVarChar, 25);
param[1].Value = Name;
param[2] = new SqlParameter("@deptID", SqlDbType.Int);
param[2].Value = DepID;
param[3] = new SqlParameter("@username", SqlDbType.NVarChar, 25);
param[3].Value = username;
param[4] = new SqlParameter("@pw", SqlDbType.NVarChar, 15);
param[4].Value = pw;
param[5] = new SqlParameter("@type", SqlDbType.Int);
param[5].Value = type;
DAL.ExecuteCommand("Update_sender", param);
DAL.Close();
}
public void Updateworker(int ID, string Name,
string Phone, string Address, int MajorID, string username, string pw, int type)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@workerID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@workerName", SqlDbType.NVarChar, 25);
param[1].Value = Name;
param[2] = new SqlParameter("@workerphone", SqlDbType.NVarChar, 15);
param[2].Value = Phone;
param[3] = new SqlParameter("@workerAdress", SqlDbType.NVarChar, 30);
param[3].Value = Address;
param[4] = new SqlParameter("@majorID", SqlDbType.Int);
param[4].Value = MajorID;
param[5] = new SqlParameter("@username", SqlDbType.NVarChar, 25);
param[5].Value = username;
param[6] = new SqlParameter("@pw", SqlDbType.NVarChar, 15);
param[6].Value = pw;
param[7] = new SqlParameter("@type", SqlDbType.Int);
param[7].Value = type;
DAL.ExecuteCommand("Update_worker", param);
DAL.Close();
}
public string Users_Update(
int Users_ID
, string Users_Name
, string Users_Password
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Users_ID", SqlDbType.Int);
param[0].Value = Users_ID;
param[1] = new SqlParameter("@Users_Name", SqlDbType.NVarChar, 50);
param[1].Value = Users_Name;
param[2] = new SqlParameter("@Users_Password", SqlDbType.NVarChar, 50);
param[2].Value = Users_Password;
string F;
F = DAL.ExecuteCommand("Sp_Users_Update", param);
DAL.Close();
return(F);
}
public string Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@Anm", SqlDbType.NVarChar, 20);
param[1].Value = Anm;
param[2] = new SqlParameter("@Enm", SqlDbType.NVarChar, 20);
param[2].Value = Enm;
param[3] = new SqlParameter("@Rate", SqlDbType.Decimal);
param[3].Value = Rate;
string F;
F = DAL.ExecuteCommand("Currency_Update", param);
DAL.Close();
return(F);
}
public string Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[14];
param[0] = new SqlParameter("@Tran_ID", SqlDbType.VarChar, 10);
param[0].Value = Tran_ID;
param[1] = new SqlParameter("@Branche_ID", SqlDbType.VarChar, 3);
param[1].Value = Branche_ID;
param[2] = new SqlParameter("@Store_ID", SqlDbType.Int);
param[2].Value = Store_ID;
param[3] = new SqlParameter("@CC1_ID", SqlDbType.Int);
param[3].Value = CC1_ID;
param[4] = new SqlParameter("@CC2_ID", SqlDbType.Int);
param[4].Value = CC2_ID;
param[5] = new SqlParameter("@Tran_Date", SqlDbType.DateTime);
param[5].Value = Tran_Date;
param[6] = new SqlParameter("@To_Branche", SqlDbType.VarChar, 3);
param[6].Value = To_Branche;
param[7] = new SqlParameter("@To_Store", SqlDbType.Int);
param[7].Value = To_Store;
param[8] = new SqlParameter("@Emp_ID", SqlDbType.NVarChar, 50);
param[8].Value = Emp_ID;
param[9] = new SqlParameter("@Tran_Notes", SqlDbType.NVarChar, 50);
param[9].Value = Tran_Notes;
param[10] = new SqlParameter("@Tran_Total_CPrice", SqlDbType.Decimal);
param[10].Value = Tran_Total_CPrice;
param[11] = new SqlParameter("@Tran_Total_PPrice", SqlDbType.Decimal);
param[11].Value = Tran_Total_PPrice;
param[12] = new SqlParameter("@User_ID", SqlDbType.Int);
param[12].Value = User_ID;
param[13] = new SqlParameter("@dt_IO", SqlDbType.Structured);
param[13].Value = dt_IO;
string F;
F = DAL.ExecuteCommand("Tran_Update", param);
DAL.Close();
return(F);
}
public string Emp_Update(
int Emp_ID
, string Emp_Name
, int Job_ID
, int Emp_Phone
, int Emp_Mobile
, string Emp_Address
, int Emp_Personal_ID
, decimal Emp_Basic_Salary
, string Emp_Notes
, int User_ID
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@Emp_ID", SqlDbType.Int);
param[0].Value = Emp_ID;
param[1] = new SqlParameter("@Emp_Name", SqlDbType.NVarChar, 50);
param[1].Value = Emp_Name;
param[2] = new SqlParameter("@Job_ID", SqlDbType.Int);
param[2].Value = Job_ID;
param[3] = new SqlParameter("@Emp_Phone", SqlDbType.Int);
param[3].Value = Emp_Phone;
param[4] = new SqlParameter("@Emp_Mobile", SqlDbType.Int);
param[4].Value = Emp_Mobile;
param[5] = new SqlParameter("@Emp_Address", SqlDbType.NVarChar, 50);
param[5].Value = Emp_Address;
param[6] = new SqlParameter("@Emp_Personal_ID", SqlDbType.Int);
param[6].Value = Emp_Personal_ID;
param[7] = new SqlParameter("@Emp_Basic_Salary", SqlDbType.Decimal);
param[7].Value = Emp_Personal_ID;
param[8] = new SqlParameter("@Emp_Notes", SqlDbType.NVarChar);
param[8].Value = Emp_Notes;
param[9] = new SqlParameter("@User_ID", SqlDbType.Int);
param[9].Value = User_ID;
string F;
F = DAL.ExecuteCommand("Sp_Emp_Update", param);
DAL.Close();
return(F);
}
public DataTable invoicedetailsmax()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("invoicedetaismax", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_Purchase()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GetAllPurchase", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_Customer()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Customer", null);
DAL.Close();
return(Dt);
}
public DataTable dgv()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("dgv", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_Company()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GetAllCompany", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_stockitem()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_stockitem", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_assigned()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Reportsassigned", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_recevedbymanage()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_recevedbymanager", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_ondoing()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Reportsondoning", null);
DAL.Close();
return(Dt);
}
public DataTable Max_Productno()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Max_Productno", null);
DAL.Close();
return(Dt);
}
public DataTable maxsenderReport()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Max_report", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_Position()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Position", null);
DAL.Close();
return(Dt);
}
public DataTable maxproject()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Max_project", null);
DAL.Close();
return(Dt);
}
public DataTable maxcategory()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Max_category", null);
DAL.Close();
return(Dt);
}
public DataTable maxsale()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("maxsale", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_notdone()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Reportsnotdone", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_Employee()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Employee", null);
DAL.Close();
return(Dt);
}
public DataTable Get_All_category()
{
DAL.DAL DAL = new DAL.DAL();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Category", null);
DAL.Close();
return(Dt);
}