public string Insert()
{
DAL.DAL dal = new DAL.DAL();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
param[0].Value = Name;
param[1] = new SqlParameter("@Password", SqlDbType.NVarChar, 50);
param[1].Value = Password;
string F;
F = dal.ExecuteCommand("Insert Into Users (Name,Password) Values (@Name , @Password)", param);
return(F);
}
public void Updateitem(string ID, string Name, int Min, int Catno)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@item_no", SqlDbType.NVarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@item_name", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@item_min", SqlDbType.Int);
param[2].Value = Min;
param[3] = new SqlParameter("@categoryno", SqlDbType.Int);
param[3].Value = Catno;
DAL.ExecuteCommand("Update_item", param);
DAL.Close();
}
public void Updatestore(int ID, string Name, string loc)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@storeno", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@storename", SqlDbType.NVarChar, 25);
param[1].Value = Name;
param[2] = new SqlParameter("@storeloc", SqlDbType.NVarChar, 50);
param[2].Value = loc;
DAL.ExecuteCommand("Update_store", param);
DAL.Close();
}
public void Updatecategory(int ID, string Name, string abb)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@categoryno", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@categoryname", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@abbreviation", SqlDbType.NVarChar, 10);
param[2].Value = abb;
DAL.ExecuteCommand("Update_category", param);
DAL.Close();
}
public string Jor_Close()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@Date", SqlDbType.DateTime);
param[0].Value = Date;
param[1] = new SqlParameter("@Notes", SqlDbType.NVarChar, 50);
param[1].Value = Notes;
param[2] = new SqlParameter("@Branche_ID", SqlDbType.VarChar, 3);
param[2].Value = Branche_ID;
param[3] = new SqlParameter("@CC1_ID", SqlDbType.VarChar, 50);
param[3].Value = CC1_ID;
param[4] = new SqlParameter("@CC2_ID", SqlDbType.VarChar, 50);
param[4].Value = CC2_ID;
param[5] = new SqlParameter("@User_ID", SqlDbType.Int);
param[5].Value = User_ID;
param[6] = new SqlParameter("@Currency", SqlDbType.Int);
param[6].Value = Currency;
param[7] = new SqlParameter("@Currency_Rate", SqlDbType.Decimal);
param[7].Value = Currency_Rate;
param[8] = new SqlParameter("@ALL_Branches", SqlDbType.Bit);
param[8].Value = ALL_Branches;
string F;
F = DAL.ExecuteCommand("Jor_Close", param);
DAL.Close();
return(F);
}
public void updatefinalReport(int ID, string report, string name, int status)
{
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("@report", SqlDbType.NVarChar, 20);
param[1].Value = report;
param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 250);
param[2].Value = name;
param[3] = new SqlParameter("@status", SqlDbType.Int);
param[3].Value = status;
DAL.ExecuteCommand("Update_finalreport", param);
DAL.Close();
}
public string Update()
{
DAL.DAL dal = new DAL.DAL();
SqlParameter[] param = new SqlParameter[3];
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("@Password", SqlDbType.NVarChar, 50);
param[2].Value = Password;
string F;
F = dal.ExecuteCommand("Update Users Set Name = @Name , Password = @Password Where ID = @ID", param);
return(F);
}
public string Insert_Store()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Store_Name", SqlDbType.NVarChar, 50);
param[0].Value = Store_Name;
param[1] = new SqlParameter("@Branche_ID", SqlDbType.VarChar, 3);
param[1].Value = Branche_ID;
param[2] = new SqlParameter("@User_ID", SqlDbType.Int);
param[2].Value = User_ID;
return(DAL.ExecuteCommand("Stores_Insert", param));
DAL.Close();
}
public void AddsenderReport(int ID, int dept, DateTime date, string title, string details)
{
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("@deptid", SqlDbType.Int);
param[1].Value = dept;
param[2] = new SqlParameter("@date", SqlDbType.DateTime);
param[2].Value = date;
param[3] = new SqlParameter("@title", SqlDbType.NVarChar, 20);
param[3].Value = title;
param[4] = new SqlParameter("@details", SqlDbType.NVarChar, 250);
param[4].Value = details;
DAL.ExecuteCommand("Add_sender_report", param);
DAL.Close();
}
public string Item_Units_Delete_Check()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Item_ID", SqlDbType.VarChar, 10);
param[0].Value = Item_ID;
param[1] = new SqlParameter("@unit_id", SqlDbType.Int);
param[1].Value = unit_id;
string F;
F = DAL.ExecuteCommand("Item_Units_Delete_Check", param);
DAL.Close();
return(F);
}
public string Units_Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@anm", SqlDbType.NVarChar, 20);
param[0].Value = unit_anm;
param[1] = new SqlParameter("@enm", SqlDbType.NVarChar, 20);
param[1].Value = unit_enm;
string F;
F = DAL.ExecuteCommand("Units_Insert", param);
DAL.Close();
return(F);
}
public string Descriptions_Names_Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = des_id;
param[1] = new SqlParameter("@name", SqlDbType.NVarChar, 15);
param[1].Value = des_name;
string F;
F = DAL.ExecuteCommand("Descriptions_Names_Update", param);
DAL.Close();
return(F);
}
public string Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@CC_Name", SqlDbType.NVarChar, 50);
param[0].Value = CC_Name;
param[1] = new SqlParameter("@Parent_ID", SqlDbType.VarChar);
param[1].Value = Parent_ID;
param[2] = new SqlParameter("@CC_Level", SqlDbType.Int);
param[2].Value = CC_Level;
param[3] = new SqlParameter("@Branche", SqlDbType.VarChar, 3);
param[3].Value = Branche;
param[4] = new SqlParameter("@CC1", SqlDbType.Bit);
param[4].Value = CC1;
param[5] = new SqlParameter("@CC2", SqlDbType.Bit);
param[5].Value = CC2;
param[6] = new SqlParameter("@Notes", SqlDbType.NVarChar);
param[6].Value = Notes;
param[7] = new SqlParameter("@User_ID", SqlDbType.Int);
param[7].Value = User_ID;
string F;
F = DAL.ExecuteCommand("CC_Insert", param);
DAL.Close();
return(F);
}
public void Updateuser(int ID, string Name, string pw, int autho)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@UserID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@UserName", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@UserPsw", SqlDbType.NVarChar, 10);
param[2].Value = pw;
param[3] = new SqlParameter("@Autho_typno", SqlDbType.Int);
param[3].Value = autho;
DAL.ExecuteCommand("Update_users", param);
DAL.Close();
}
public void Updatemp(int ID, string Name, int position, int admin)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
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("@EmppositionID", SqlDbType.Int);
param[2].Value = position;
param[3] = new SqlParameter("@EmpadminID", SqlDbType.Int);
param[3].Value = admin;
DAL.ExecuteCommand("Update_Employee", param);
DAL.Close();
}
public string Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@Ven_ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@Ven_Name", SqlDbType.NVarChar, 50);
param[1].Value = Name;
param[2] = new SqlParameter("@Ven_Address", SqlDbType.NVarChar, 50);
param[2].Value = Address;
param[3] = new SqlParameter("@Ven_Mobile", SqlDbType.VarChar, 20);
param[3].Value = Mobile;
param[4] = new SqlParameter("@Ven_Phone", SqlDbType.VarChar, 20);
param[4].Value = Phone;
param[5] = new SqlParameter("@Ven_Notes", SqlDbType.NVarChar, 50);
param[5].Value = Notes;
param[6] = new SqlParameter("@Ven_ACC", SqlDbType.VarChar, 50);
param[6].Value = Ven_ACC;
param[7] = new SqlParameter("@User_ID", SqlDbType.Int);
param[7].Value = User_ID;
string F;
F = DAL.ExecuteCommand("Ven_Update", param);
DAL.Close();
return(F);
}
public string Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@Rep_Name", SqlDbType.NVarChar, 50);
param[0].Value = Name;
param[1] = new SqlParameter("@Content", SqlDbType.NVarChar, 500);
param[1].Value = Content;
param[2] = new SqlParameter("@Row_Count", SqlDbType.Int);
param[2].Value = Row_Count;
param[3] = new SqlParameter("@Row_Index", SqlDbType.Bit);
param[3].Value = Row_Index;
param[4] = new SqlParameter("@Font_Size", SqlDbType.Int);
param[4].Value = Font_Size;
param[5] = new SqlParameter("@Rep_View", SqlDbType.NVarChar, 15);
param[5].Value = Rep_View;
param[6] = new SqlParameter("@User_ID", SqlDbType.Int);
param[6].Value = User_ID;
param[7] = new SqlParameter("@Rep_D", SqlDbType.Structured);
param[7].Value = Rep_D;
string F;
F = DAL.ExecuteCommand("Rep_Insert", param);
DAL.Close();
return(F);
}
public void UpdateInvoiceDetails(int ID, int item,
int Qty, string Cost, string Expdate, string Price, string Percentage, string total, int invoiceID)
{
DAL.DAL DAL = new DAL.DAL();
DAL.Open();
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@item", SqlDbType.Int);
param[1].Value = item;
param[2] = new SqlParameter("@Qty", SqlDbType.Int);
param[2].Value = Qty;
param[3] = new SqlParameter("@Cost", SqlDbType.NVarChar, 50);
param[3].Value = Cost;
param[4] = new SqlParameter("@Expdate", SqlDbType.NVarChar, 50);
param[4].Value = Expdate;
param[5] = new SqlParameter("@Price", SqlDbType.NVarChar, 50);
param[5].Value = Price;
param[6] = new SqlParameter("@Percentage", SqlDbType.NVarChar, 50);
param[6].Value = Percentage;
param[7] = new SqlParameter("@total", SqlDbType.NVarChar, 50);
param[7].Value = total;
param[8] = new SqlParameter("@invoiceID", SqlDbType.Int);
param[8].Value = invoiceID;
DAL.ExecuteCommand("UpdateInvoiceDetails", param);
DAL.Close();
}
public string Description_Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@des_name", SqlDbType.NVarChar, 50);
param[0].Value = des_item_name;
param[1] = new SqlParameter("@des_Notes", SqlDbType.NVarChar, 100);
param[1].Value = des_item_notes;
param[2] = new SqlParameter("@des_type", SqlDbType.Int);
param[2].Value = des_item_type;
string F;
F = DAL.ExecuteCommand("Items_Description_Insert", param);
DAL.Close();
return(F);
}
public string Job_Type_Insert(
string Job_Type_Name
, int User_ID
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Job_Type_Name", SqlDbType.NVarChar, 50);
param[0].Value = Job_Type_Name;
param[1] = new SqlParameter("@User_ID", SqlDbType.Int);
param[1].Value = User_ID;
string F;
F = DAL.ExecuteCommand("Sp_Job_Type_Insert", param);
DAL.Close();
return(F);
}
public string Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Anm", SqlDbType.NVarChar, 20);
param[0].Value = Anm;
param[1] = new SqlParameter("@Enm", SqlDbType.NVarChar, 20);
param[1].Value = Enm;
param[2] = new SqlParameter("@Rate", SqlDbType.Decimal);
param[2].Value = Rate;
string F;
F = DAL.ExecuteCommand("Currency_Insert", param);
DAL.Close();
return(F);
}
public string Jor_B_Insert(
string Branche
, int Bill_Type
, int B_Type
, int User_ID
, DataTable dt_Jor_B
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Branche", SqlDbType.VarChar, 3);
param[0].Value = Branche;
param[1] = new SqlParameter("@Bill_Type", SqlDbType.Int);
param[1].Value = Bill_Type;
param[2] = new SqlParameter("@B_Type", SqlDbType.Int);
param[2].Value = B_Type;
param[3] = new SqlParameter("@User_ID", SqlDbType.Int);
param[3].Value = User_ID;
param[4] = new SqlParameter("@dt_Jor_B", SqlDbType.Structured);
param[4].Value = dt_Jor_B;
string F;
F = DAL.ExecuteCommand("Sp_Jor_B_Insert", param);
DAL.Close();
return(F);
}
public string Jor_D_Insert(
int Branche_ID
, int Store_ID
, int CC1_ID
, int CC2_ID
, string Ven_ID
, string Jor_D_B_Type
, string Jor_D_Jor_D_No
, DateTime Jor_D_Jor_D_Date
, DateTime Jor_D_Date
, string Jor_D_Notes
, decimal Jor_D_Total
, decimal Jor_D_Total_Dis_Rate
, decimal Jor_D_Total_Dis_Value
, decimal Jor_D_Net
, decimal Jor_D_Total_SPrice
, int User_ID
, DataTable dt_Items
)
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@Branche_ID", SqlDbType.Int);
param[0].Value = Branche_ID;
param[1] = new SqlParameter("@Store_ID", SqlDbType.Int);
param[1].Value = Store_ID;
param[2] = new SqlParameter("@CC1_ID", SqlDbType.Int);
param[2].Value = CC1_ID;
param[3] = new SqlParameter("@CC2_ID", SqlDbType.Int);
param[3].Value = CC2_ID;
param[4] = new SqlParameter("@Ven_ID", SqlDbType.NVarChar, 50);
param[4].Value = Ven_ID;
param[5] = new SqlParameter("@Jor_D_B_Type", SqlDbType.NVarChar, 50);
param[5].Value = Jor_D_B_Type;
param[6] = new SqlParameter("@Jor_D_Jor_D_No", SqlDbType.NVarChar, 50);
param[6].Value = Jor_D_Jor_D_No;
param[7] = new SqlParameter("@Jor_D_Jor_D_Date", SqlDbType.DateTime);
param[7].Value = Jor_D_Jor_D_Date;
param[8] = new SqlParameter("@Jor_D_Date", SqlDbType.DateTime);
param[8].Value = Jor_D_Date;
param[9] = new SqlParameter("@Jor_D_Notes", SqlDbType.NVarChar, 50);
param[9].Value = Jor_D_Notes;
param[10] = new SqlParameter("@Jor_D_Total", SqlDbType.Decimal);
param[10].Value = Jor_D_Total;
param[11] = new SqlParameter("@Jor_D_Total_Dis_Rate", SqlDbType.Decimal);
param[11].Value = Jor_D_Total_Dis_Rate;
param[12] = new SqlParameter("@Jor_D_Total_Dis_Value", SqlDbType.Decimal);
param[12].Value = Jor_D_Total_Dis_Value;
param[13] = new SqlParameter("@Jor_D_Net", SqlDbType.Decimal);
param[13].Value = Jor_D_Net;
param[14] = new SqlParameter("@Jor_D_Total_SPrice", SqlDbType.Decimal);
param[14].Value = Jor_D_Total_SPrice;
param[15] = new SqlParameter("@User_ID", SqlDbType.Int);
param[15].Value = User_ID;
param[16] = new SqlParameter("@dt_Items", SqlDbType.Structured);
param[16].Value = dt_Items;
string F;
F = DAL.ExecuteCommand("Sp_Jor_D_Insert", param);
DAL.Close();
return(F);
}
public string Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[18];
param[0] = new SqlParameter("@SalRe_ID", SqlDbType.VarChar, 10);
param[0].Value = Bill_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.VarChar, 50);
param[3].Value = CC1_ID;
param[4] = new SqlParameter("@CC2_ID", SqlDbType.VarChar, 50);
param[4].Value = CC2_ID;
param[5] = new SqlParameter("@Cust_ID", SqlDbType.NVarChar, 50);
param[5].Value = Cust_ID;
param[6] = new SqlParameter("@SalRe_B_Type", SqlDbType.Int);
param[6].Value = B_Type;
param[7] = new SqlParameter("@SalRe_Date", SqlDbType.DateTime);
param[7].Value = SalRe_Date;
param[8] = new SqlParameter("@Currency", SqlDbType.Int);
param[8].Value = Currency;
param[9] = new SqlParameter("@Currency_Rate", SqlDbType.Decimal);
param[9].Value = Currency_Rate;
param[10] = new SqlParameter("@SalRe_OSalRe", SqlDbType.VarChar, 50);
param[10].Value = SalRe_OSalRe;
param[11] = new SqlParameter("@SalRe_Notes", SqlDbType.NVarChar, 50);
param[11].Value = Notes;
param[12] = new SqlParameter("@SalRe_Total", SqlDbType.Decimal);
param[12].Value = Total;
param[13] = new SqlParameter("@SalRe_Total_Dis_Rate", SqlDbType.Decimal);
param[13].Value = Total_Dis_Rate;
param[14] = new SqlParameter("@SalRe_Total_Dis_Value", SqlDbType.Decimal);
param[14].Value = Total_Dis_Value;
param[15] = new SqlParameter("@SalRe_Net", SqlDbType.Decimal);
param[15].Value = Net;
param[16] = new SqlParameter("@User_ID", SqlDbType.Int);
param[16].Value = User_ID;
param[17] = new SqlParameter("@dt_SalRe_IO", SqlDbType.Structured);
param[17].Value = dt_IO;
string F;
F = DAL.ExecuteCommand("SalRe_Update", param);
DAL.Close();
return(F);
}
public string Update()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[36];
param[0] = new SqlParameter("@Item_ID", SqlDbType.VarChar, 50);
param[0].Value = Item_ID;
param[1] = new SqlParameter("@anm", SqlDbType.NVarChar, 50);
param[1].Value = anm;
param[2] = new SqlParameter("@enm", SqlDbType.NVarChar, 50);
param[2].Value = enm;
param[3] = new SqlParameter("@Max_Quan", SqlDbType.Decimal);
param[3].Value = Max_Quan;
param[4] = new SqlParameter("@Min_Quan", SqlDbType.Decimal);
param[4].Value = Min_Quan;
param[5] = new SqlParameter("@Alarm_Quan", SqlDbType.Decimal);
param[5].Value = Alarm_Quan;
param[6] = new SqlParameter("@des1", SqlDbType.Int);
param[6].Value = des1;
param[7] = new SqlParameter("@des2", SqlDbType.Int);
param[7].Value = des2;
param[8] = new SqlParameter("@des3", SqlDbType.Int);
param[8].Value = des3;
param[9] = new SqlParameter("@des4", SqlDbType.Int);
param[9].Value = des4;
param[10] = new SqlParameter("@des5", SqlDbType.Int);
param[10].Value = des5;
param[11] = new SqlParameter("@des6", SqlDbType.Int);
param[11].Value = des6;
param[12] = new SqlParameter("@des7", SqlDbType.Int);
param[12].Value = des7;
param[13] = new SqlParameter("@des8", SqlDbType.NVarChar, 20);
param[13].Value = des8;
param[14] = new SqlParameter("@des9", SqlDbType.NVarChar, 20);
param[14].Value = des9;
param[15] = new SqlParameter("@des10", SqlDbType.NVarChar, 20);
param[15].Value = des10;
param[16] = new SqlParameter("@image", SqlDbType.VarBinary);
param[16].Value = image;
param[17] = new SqlParameter("@is_commodity", SqlDbType.Bit);
param[17].Value = is_commodity;
param[18] = new SqlParameter("@is_complex", SqlDbType.Bit);
param[18].Value = is_complex;
param[19] = new SqlParameter("@SPrice_complex_Type", SqlDbType.Int);
param[19].Value = SPrice_complex_Type;
param[20] = new SqlParameter("@SPrice_complex2_Val", SqlDbType.Decimal);
param[20].Value = SPrice_complex2_Val;
param[21] = new SqlParameter("@SPrice_complex3_Val", SqlDbType.Decimal);
param[21].Value = SPrice_complex3_Val;
param[22] = new SqlParameter("@bonus", SqlDbType.Decimal);
param[22].Value = bonus;
param[23] = new SqlParameter("@bonus_range", SqlDbType.Decimal);
param[23].Value = bonus_range;
param[24] = new SqlParameter("@Currency_ID", SqlDbType.Int);
param[24].Value = Currency_ID;
param[25] = new SqlParameter("@sales_tax", SqlDbType.Int);
param[25].Value = sales_tax;
param[26] = new SqlParameter("@is_searchable", SqlDbType.Bit);
param[26].Value = is_searchable;
param[27] = new SqlParameter("@Parent_ID", SqlDbType.VarChar, 50);
param[27].Value = Parent_ID;
param[28] = new SqlParameter("@Is_Parent", SqlDbType.Bit);
param[28].Value = Is_Parent;
param[29] = new SqlParameter("@level", SqlDbType.Int);
param[29].Value = level;
param[30] = new SqlParameter("@user_id", SqlDbType.Int);
param[30].Value = user_id;
param[31] = new SqlParameter("@dt_Item_Unit", SqlDbType.Structured);
param[31].Value = dt_Item_Unit;
param[32] = new SqlParameter("@dt_Item_Price", SqlDbType.Structured);
param[32].Value = dt_Item_Price;
param[33] = new SqlParameter("@dt_Item_Barcode", SqlDbType.Structured);
param[33].Value = dt_Item_Barcode;
param[34] = new SqlParameter("@dt_Item_Ven", SqlDbType.Structured);
param[34].Value = dt_Item_Ven;
param[35] = new SqlParameter("@dt_Item_Alt", SqlDbType.Structured);
param[35].Value = dt_Item_Alt;
string F;
F = DAL.ExecuteCommand("Items_Update", param);
DAL.Close();
return(F);
}
public string Update_Level_Set()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[30];
param[0] = new SqlParameter("@n1", SqlDbType.Int);
param[0].Value = n1;
param[1] = new SqlParameter("@n2", SqlDbType.Int);
param[1].Value = n2;
param[2] = new SqlParameter("@n3", SqlDbType.Int);
param[2].Value = n3;
param[3] = new SqlParameter("@n4", SqlDbType.Int);
param[3].Value = n4;
param[4] = new SqlParameter("@n5", SqlDbType.Int);
param[4].Value = n5;
param[5] = new SqlParameter("@n6", SqlDbType.Int);
param[5].Value = n6;
param[6] = new SqlParameter("@n7", SqlDbType.Int);
param[6].Value = n7;
param[7] = new SqlParameter("@n8", SqlDbType.Int);
param[7].Value = n8;
param[8] = new SqlParameter("@n9", SqlDbType.Int);
param[8].Value = n9;
param[9] = new SqlParameter("@n10", SqlDbType.Int);
param[9].Value = n10;
param[10] = new SqlParameter("@cc1", SqlDbType.Int);
param[10].Value = cc1;
param[11] = new SqlParameter("@cc2", SqlDbType.Int);
param[11].Value = cc2;
param[12] = new SqlParameter("@cc3", SqlDbType.Int);
param[12].Value = cc3;
param[13] = new SqlParameter("@cc4", SqlDbType.Int);
param[13].Value = cc4;
param[14] = new SqlParameter("@cc5", SqlDbType.Int);
param[14].Value = cc5;
param[15] = new SqlParameter("@cc6", SqlDbType.Int);
param[15].Value = cc6;
param[16] = new SqlParameter("@cc7", SqlDbType.Int);
param[16].Value = cc7;
param[17] = new SqlParameter("@cc8", SqlDbType.Int);
param[17].Value = cc8;
param[18] = new SqlParameter("@cc9", SqlDbType.Int);
param[18].Value = cc9;
param[19] = new SqlParameter("@cc10", SqlDbType.Int);
param[19].Value = cc10;
param[20] = new SqlParameter("@i1", SqlDbType.Int);
param[20].Value = i1;
param[21] = new SqlParameter("@i2", SqlDbType.Int);
param[21].Value = i2;
param[22] = new SqlParameter("@i3", SqlDbType.Int);
param[22].Value = i3;
param[23] = new SqlParameter("@i4", SqlDbType.Int);
param[23].Value = i4;
param[24] = new SqlParameter("@i5", SqlDbType.Int);
param[24].Value = i5;
param[25] = new SqlParameter("@i6", SqlDbType.Int);
param[25].Value = i6;
param[26] = new SqlParameter("@i7", SqlDbType.Int);
param[26].Value = i7;
param[27] = new SqlParameter("@i8", SqlDbType.Int);
param[27].Value = i8;
param[28] = new SqlParameter("@i9", SqlDbType.Int);
param[28].Value = i9;
param[29] = new SqlParameter("@i10", SqlDbType.Int);
param[29].Value = i10;
string F;
F = DAL.ExecuteCommand("G_Level_Set_Update", param);
DAL.Close();
return(F);
}
public string Insert()
{
DAL.DAL DAL = new DAL.DAL();
DAL.open();
SqlParameter[] param = new SqlParameter[19];
param[0] = new SqlParameter("@Branche_ID", SqlDbType.VarChar, 3);
param[0].Value = Branche_ID;
param[1] = new SqlParameter("@Store_ID", SqlDbType.Int);
param[1].Value = Store_ID;
param[2] = new SqlParameter("@CC1_ID", SqlDbType.VarChar, 50);
param[2].Value = CC1_ID;
param[3] = new SqlParameter("@CC2_ID", SqlDbType.VarChar, 50);
param[3].Value = CC2_ID;
param[4] = new SqlParameter("@Ven_ID", SqlDbType.NVarChar, 50);
param[4].Value = Ven_ID;
param[5] = new SqlParameter("@Pur_B_Type", SqlDbType.Int);
param[5].Value = Pur_B_Type;
param[6] = new SqlParameter("@Pur_Pur_No", SqlDbType.NVarChar, 50);
param[6].Value = Pur_Pur_No;
param[7] = new SqlParameter("@Pur_Pur_Date", SqlDbType.DateTime);
param[7].Value = Pur_Pur_Date;
param[8] = new SqlParameter("@Pur_Date", SqlDbType.DateTime);
param[8].Value = Pur_Date;
param[9] = new SqlParameter("@Pur_Notes", SqlDbType.NVarChar, 50);
param[9].Value = Pur_Notes;
param[10] = new SqlParameter("@Currency", SqlDbType.Int);
param[10].Value = Currency;
param[11] = new SqlParameter("@Currency_Rate", SqlDbType.Decimal);
param[11].Value = Currency_Rate;
param[12] = new SqlParameter("@Pur_Total", SqlDbType.Decimal);
param[12].Value = Pur_Total;
param[13] = new SqlParameter("@Pur_Total_Dis_Rate", SqlDbType.Decimal);
param[13].Value = Pur_Total_Dis_Rate;
param[14] = new SqlParameter("@Pur_Total_Dis_Value", SqlDbType.Decimal);
param[14].Value = Pur_Total_Dis_Value;
param[15] = new SqlParameter("@Pur_Net", SqlDbType.Decimal);
param[15].Value = Pur_Net;
param[16] = new SqlParameter("@Pur_Total_SPrice", SqlDbType.Decimal);
param[16].Value = Pur_Total_SPrice;
param[17] = new SqlParameter("@User_ID", SqlDbType.Int);
param[17].Value = User_ID;
param[18] = new SqlParameter("@dt_Items", SqlDbType.Structured);
param[18].Value = dt_Items;
string F;
F = DAL.ExecuteCommand("Pur_Insert", param);
DAL.Close();
return(F);
}