public void P_IAS_insert_PREQ_TYPES
(
int PR_TYPE,
string PR_A_NAME,
string PR_E_NAME
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@PR_TYPE", SqlDbType.Int);
param[0].Value = PR_TYPE;
param[1] = new SqlParameter("@PR_A_NAME", SqlDbType.NVarChar);
param[1].Value = PR_A_NAME;
param[2] = new SqlParameter("@PR_E_NAME", SqlDbType.NVarChar);
param[2].Value = PR_E_NAME;
param[3] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[3].Value = PL.main.Use_id;
DAL.Executecommade("P_IAS_insert_PREQ_TYPES", param);
}
public void P_AC_inser_ACCOUNT_AN__CURR
(
string currency_Key,
string Account_ID,
string N_AN,
bool used
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@currency_Key", SqlDbType.NVarChar);
param[0].Value = currency_Key;
param[1] = new SqlParameter("@Account_ID", SqlDbType.NVarChar);
param[1].Value = Account_ID;
param[2] = new SqlParameter("@N_AN", SqlDbType.NVarChar);
param[2].Value = N_AN;
param[3] = new SqlParameter("@Used", SqlDbType.Bit);
param[3].Value = used;
DAL.Executecommade("P_AC_inser_ACCOUNT_AN__CURR", param);
}
public void P_SUP_insert_VENDOR_GROUP
(
int V_GROUP_CODE,
string V_GROUP_A_NAME,
string V_GROUP_E_NAME,
string V_ACCOUNT_ID
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@V_GROUP_CODE", SqlDbType.Int);
param[0].Value = V_GROUP_CODE;
param[1] = new SqlParameter("@V_GROUP_A_NAME", SqlDbType.NVarChar);
param[1].Value = V_GROUP_A_NAME;
param[2] = new SqlParameter("@V_GROUP_E_NAME", SqlDbType.NVarChar);
param[2].Value = V_GROUP_E_NAME;
param[3] = new SqlParameter("@V_ACCOUNT_ID", SqlDbType.NVarChar);
param[3].Value = V_ACCOUNT_ID;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("P_SUP_insert_VENDOR_GROUP", param);
}
public void P_Ath_insert_Cash_Bank_User
(
int User_ID
, string A_CODE
, bool Show,
bool Add)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@User_ID", SqlDbType.Int);
param[0].Value = User_ID;
param[1] = new SqlParameter("@A_CODE", SqlDbType.NVarChar, 30);
param[1].Value = A_CODE;
param[2] = new SqlParameter("@Show", SqlDbType.Bit);
param[2].Value = Show;
param[3] = new SqlParameter("@Add", SqlDbType.Bit);
param[3].Value = Add;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("P_Ath_insert_Cash_Bank_User", param);
DAL.Close();
}
//public DataTable get_account_curr(string Account_ID)
public void p_AC_insert_Account_type(int Type_ID,
string A_N,
string E_N,
bool Affected_by_operations
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Type_ID", SqlDbType.Int);
param[0].Value = Type_ID;
param[1] = new SqlParameter("@A_N", SqlDbType.NVarChar, (20));
param[1].Value = A_N;
param[2] = new SqlParameter("@E_N", SqlDbType.NVarChar, (20));
param[2].Value = E_N;
param[3] = new SqlParameter("@Affected_by_operations", SqlDbType.Bit);
param[3].Value = Affected_by_operations;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("p_AC_insert_Account_type", param);
}
public void p_INV_Insert_inventory_group(
int Inventory_Group_ID,
string @Group_A_N,
string @Group_A_E,
int @Account_ID,
string @py_user)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Inventory_Group_ID ", SqlDbType.Int);
param[0].Value = Inventory_Group_ID;
param[1] = new SqlParameter("@Group_A_N", SqlDbType.NVarChar);
param[1].Value = Group_A_N;
param[2] = new SqlParameter("@Group_A_E", SqlDbType.NVarChar);
param[2].Value = Group_A_E;
param[3] = new SqlParameter("@Account_ID", SqlDbType.NVarChar);
param[3].Value = Account_ID;
param[4] = new SqlParameter("@py_user", SqlDbType.NVarChar, 50);
param[4].Value = py_user;
DAL.Executecommade("p_INV_Insert_inventory_group", param);
}
// create proc p_INV_insert_Movmant_Line
//@line_num int,
//@Movmant_ID int,
// @Product_ID int
// ,@UnitCost money
// , @Units_ID int
// ,@Quantity float
public void p_INV_insert_Product_Movmant_Line(
int line_num,
int Movmant_ID,
string Product_ID,
decimal UnitCost,
string Units_ID,
decimal Quantity,
decimal Quantity_out
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@line_num ", SqlDbType.Int);
param[0].Value = line_num;
param[1] = new SqlParameter("@Movmant_ID", SqlDbType.Int);
param[1].Value = Movmant_ID;
param[2] = new SqlParameter("@Product_ID", SqlDbType.NVarChar, 30);
param[2].Value = Product_ID;
param[3] = new SqlParameter("@UnitCost", SqlDbType.Money);
param[3].Value = UnitCost;
param[4] = new SqlParameter("@Units_ID", SqlDbType.NVarChar, 10);
param[4].Value = Units_ID;
param[5] = new SqlParameter("@Quantity", SqlDbType.Float);
param[5].Value = Quantity;
param[6] = new SqlParameter("@Quantity_out", SqlDbType.Float);
param[6].Value = Quantity_out;
DAL.Executecommade("p_INV_insert_Product_Movmant_Line", param);
}
public void p_AM_insert_Managements(int Management_ID,
string A_N,
string E_N,
string Location
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Management_ID", SqlDbType.Int);
param[0].Value = Management_ID;
param[1] = new SqlParameter("@A_N", SqlDbType.NVarChar, (20));
param[1].Value = A_N;
param[2] = new SqlParameter("@E_N", SqlDbType.NVarChar, (20));
param[2].Value = E_N;
param[3] = new SqlParameter("@Location", SqlDbType.NVarChar);
param[3].Value = Location;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("p_AM_insert_Managements", param);
}
public void P_AM_insert_Distinct(
int Distinct_id,
int Gov_ID,
string A_N,
string E_N
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Distinct_id", SqlDbType.Int);
param[0].Value = Distinct_id;
param[1] = new SqlParameter("@Gov_ID", SqlDbType.Int);
param[1].Value = Gov_ID;
param[2] = new SqlParameter("@A_N", SqlDbType.NVarChar, 32);
param[2].Value = A_N;
param[3] = new SqlParameter("@E_N", SqlDbType.NVarChar, 50);
param[3].Value = E_N;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("P_AM_insert_Distinct", param);
}
public void P_AC_insert_ACCOUNT_AN
(string Account_ID,
string N_AN,
string A_N
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Account_ID", SqlDbType.NVarChar);
param[0].Value = Account_ID;
param[1] = new SqlParameter("@N_AN", SqlDbType.NVarChar);
param[1].Value = N_AN;
param[2] = new SqlParameter("@A_N", SqlDbType.NVarChar);
param[2].Value = A_N;
param[3] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[3].Value = PL.main.Use_id;
DAL.Executecommade("P_AC_insert_ACCOUNT_AN", param);
}
public void P_SUP_insert_VENDOR_CLASS
(
int V_CLASS,
string V_CLASS_NAME,
string V_CLASS_E_NAME
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@V_CLASS", SqlDbType.Int);
param[0].Value = V_CLASS;
param[1] = new SqlParameter("@V_CLASS_NAME", SqlDbType.NVarChar);
param[1].Value = V_CLASS_NAME;
param[2] = new SqlParameter("@V_CLASS_E_NAME", SqlDbType.NVarChar);
param[2].Value = V_CLASS_E_NAME;
param[3] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[3].Value = PL.main.Use_id;
DAL.Executecommade("P_SUP_insert_VENDOR_CLASS", param);
}
public void P_AM_insert_Country(
int Country_ID,
string Country_A_N,
string Country_E_N,
int status,
int currency_ID
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@Country_ID", SqlDbType.Int);
param[0].Value = Country_ID;
param[1] = new SqlParameter("@Country_A_N", SqlDbType.NVarChar);
param[1].Value = Country_A_N;
param[2] = new SqlParameter("@Country_E_N", SqlDbType.NVarChar);
param[2].Value = Country_E_N;
param[3] = new SqlParameter("@status", SqlDbType.Int);
param[3].Value = status;
param[4] = new SqlParameter("@currency_ID", SqlDbType.Int);
param[4].Value = currency_ID;
param[5] = new SqlParameter("@py_user", SqlDbType.NVarChar, 50);
param[5].Value = PL.main.Use_id;
DAL.Executecommade("P_AM_insert_Country", param);
}
public void P_AC_insert_Account(
string Account_ID,
string Account_Parent_ID,
string A_N,
string E_N,
int ACcount_Level,
int Type_ID,
int Account_Group_ID,
int Class_ID,
int stutas,
int Rapport_ID,
string Note)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[12];
param[0] = new SqlParameter("@Account_ID", SqlDbType.NVarChar, 15);
param[0].Value = Account_ID;
param[1] = new SqlParameter("@Account_Parent_ID", SqlDbType.NVarChar, 10);
param[1].Value = Account_Parent_ID;
param[2] = new SqlParameter("@A_N", SqlDbType.NVarChar, (50));
param[2].Value = A_N;
param[3] = new SqlParameter("@E_N", SqlDbType.NVarChar, (50));
param[3].Value = E_N;
param[4] = new SqlParameter("@ACcount_Level", SqlDbType.Int);
param[4].Value = ACcount_Level;
param[5] = new SqlParameter("@Type_ID", SqlDbType.Int);
param[5].Value = Type_ID;
param[6] = new SqlParameter("@Account_Group_ID", SqlDbType.Int);
param[6].Value = Account_Group_ID;
param[7] = new SqlParameter("@Class_ID", SqlDbType.Int);
param[7].Value = Class_ID;
param[8] = new SqlParameter("@stutas", SqlDbType.Int);
param[8].Value = stutas;
param[9] = new SqlParameter("@Rapport_ID", SqlDbType.Int);
param[9].Value = Rapport_ID;
param[10] = new SqlParameter("@Note", SqlDbType.NVarChar);
param[10].Value = Note;
param[11] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[11].Value = PL.main.Use_id;
DAL.Executecommade("P_AC_insert_Account", param);
}
public void P_AC_insert_Account_LMT
(
string Account_ID,
string A_N,
string currency_Key,
int MIN_AMT,
int MAX_AMT,
int MIN_TRNS_AMT,
int MAX_TRNS_AMT
, bool EXCEED_LMT
, bool DR_CR
, string LMT_DESC
, bool INACTIVE
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[12];
param[0] = new SqlParameter("@Account_ID", SqlDbType.NVarChar, 15);
param[0].Value = Account_ID;
param[1] = new SqlParameter("@A_N", SqlDbType.NVarChar, 10);
param[1].Value = A_N;
param[2] = new SqlParameter("@currency_Key", SqlDbType.NVarChar, (50));
param[2].Value = currency_Key;
param[3] = new SqlParameter("@MIN_AMT", SqlDbType.Int);
param[3].Value = MIN_AMT;
param[4] = new SqlParameter("@MAX_AMT", SqlDbType.Int);
param[4].Value = MAX_AMT;
param[5] = new SqlParameter("@MIN_TRNS_AMT", SqlDbType.Int);
param[5].Value = MIN_TRNS_AMT;
param[6] = new SqlParameter("@MAX_TRNS_AMT", SqlDbType.Int);
param[6].Value = MAX_TRNS_AMT;
param[7] = new SqlParameter("@EXCEED_LMT", SqlDbType.Bit);
param[7].Value = EXCEED_LMT;
param[8] = new SqlParameter("@DR_CR", SqlDbType.Bit);
param[8].Value = DR_CR;
param[9] = new SqlParameter("@LMT_DESC", SqlDbType.NVarChar);
param[9].Value = LMT_DESC;
param[10] = new SqlParameter("@INACTIVE", SqlDbType.Bit);
param[10].Value = INACTIVE;
param[11] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[11].Value = PL.main.Use_id;
DAL.Executecommade("P_AC_insert_Account_LMT", param);
}
public void P_INV_insert_Peoduct_Movmant(
int Movmant_num,
int Invontory_ID,
int Invontory_dis_ID,
string MovementDate,
int Documant_Type_ID,
bool real,
string Note,
string Reason,
bool deported,
bool stops
, int Cost_center
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[13];
param[0] = new SqlParameter("@Movmant_num ", SqlDbType.Int);
param[0].Value = Movmant_num;
param[1] = new SqlParameter("@Invontory_ID", SqlDbType.Int);
param[1].Value = Invontory_ID;
param[2] = new SqlParameter("@Invontory_dis_ID", SqlDbType.Int);
param[2].Value = Invontory_dis_ID;
param[3] = new SqlParameter("@FYear", SqlDbType.Int);
param[3].Value = PL.main.Fyear;
param[4] = new SqlParameter("@MovementDate", SqlDbType.Date);
param[4].Value = MovementDate;
param[5] = new SqlParameter("@Documant_Type_ID", SqlDbType.Int);
param[5].Value = Documant_Type_ID;
param[6] = new SqlParameter("@real", SqlDbType.Bit);
param[6].Value = real;
param[7] = new SqlParameter("@Note", SqlDbType.NVarChar);
param[7].Value = Note;
param[8] = new SqlParameter("@Reason", SqlDbType.NVarChar);
param[8].Value = Reason;
param[9] = new SqlParameter("@deported", SqlDbType.Bit);
param[9].Value = deported;
param[10] = new SqlParameter("@stops", SqlDbType.Bit);
param[10].Value = stops;
param[11] = new SqlParameter("@Cost_center", SqlDbType.Int);
param[11].Value = Cost_center;
param[12] = new SqlParameter("@by_user", SqlDbType.NVarChar);
param[12].Value = PL.main.Use_id;
DAL.Executecommade("P_INV_insert_Peoduct_Movmant", param);
}
public void proc_Delete_User(string username)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@username", SqlDbType.NChar, 10);
param[0].Value = username;
DAL.Executecommade("proc_Delete_User", param);
DAL.Close();
}
// ALTER proc[dbo].[p_AM_insert_Currency]
// @currency_ID int
//,@currency_Key varchar(4)
// ,@currency_name nvarchar(50)
// ,@currency_name_e varchar(50)
// ,@CURR_SNAME nvarchar(50)
// ,@part_name nvarchar(50)
// ,@locally bit
// , @stor_currency bit
// ,@price_tans money
// , @by_user nvarchar(50)
public void p_AM_insert_Currency(int currency_ID,
string currency_Key,
string currency_name,
string currency_name_e,
string CURR_SNAME,
string part_name,
bool locally,
bool stor_currency,
bool Used,
string price_tans)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@currency_ID", SqlDbType.Int);
param[0].Value = currency_ID;
param[1] = new SqlParameter("@currency_Key", SqlDbType.NVarChar, (4));
param[1].Value = currency_Key;
param[2] = new SqlParameter("@currency_name", SqlDbType.NVarChar, (20));
param[2].Value = currency_name;
param[3] = new SqlParameter("@currency_name_e", SqlDbType.NVarChar, 20);
param[3].Value = currency_name_e;
param[4] = new SqlParameter("@CURR_SNAME", SqlDbType.NVarChar, 20);
param[4].Value = CURR_SNAME;
param[5] = new SqlParameter("@part_name", SqlDbType.NVarChar, 50);
param[5].Value = part_name;
param[6] = new SqlParameter("@locally", SqlDbType.Bit);
param[6].Value = locally;
param[7] = new SqlParameter("@stor_currency", SqlDbType.NVarChar, 50);
param[7].Value = stor_currency;
param[8] = new SqlParameter("@Used", SqlDbType.Bit);
param[8].Value = Used;
param[9] = new SqlParameter("@price_tans", SqlDbType.Money);
param[9].Value = price_tans;
param[10] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[10].Value = PL.main.Use_id;
DAL.Executecommade("p_AM_insert_Currency", param);
}
public void p_AM_insert_Company(
int Company_ID,
string Company_A_N,
string Company_E_N,
string A_N
, string E_N
, string Note
, int Group_ID
, int Country_ID
, byte[] Image
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@Company_ID", SqlDbType.Int);
param[0].Value = Company_ID;
param[1] = new SqlParameter("@Company_A_N", SqlDbType.NVarChar, 30);
param[1].Value = Company_A_N;
param[2] = new SqlParameter("@Company_E_N", SqlDbType.NVarChar, 30);
param[2].Value = Company_E_N;
param[3] = new SqlParameter("@A_N", SqlDbType.NVarChar, 5);
param[3].Value = A_N;
param[4] = new SqlParameter("@E_N", SqlDbType.NVarChar, 5);
param[4].Value = E_N;
param[5] = new SqlParameter("@Note", SqlDbType.NVarChar, 50);
param[5].Value = Note;
param[6] = new SqlParameter("@Group_ID", SqlDbType.Int);
param[6].Value = Group_ID;
param[7] = new SqlParameter("@Country_ID", SqlDbType.Int);
param[7].Value = Country_ID;
param[8] = new SqlParameter("@Image", SqlDbType.Image);
param[8].Value = @Image;
param[9] = new SqlParameter("@py_user", SqlDbType.NVarChar, 50);
param[9].Value = PL.main.Use_id;
DAL.Executecommade("p_AM_insert_Company", param);
}
// [dbo].[P_AC_insert_Account_Request]
// @Account_ID nvarchar(15)
// , @Account_Parent_ID nvarchar(10)
// ,@A_N nvarchar(50)
// ,@E_N nvarchar(50)
// , @ACcount_Level int
// ,@Type_ID int
// , @Account_Group_ID int
// , @Class_ID int
//,@Note nvarchar(max)
//,@add_status bit
// , @by_user nvarchar(50)
public void P_AC_insert_Account_Request
(string Account_ID,
string Account_Parent_ID,
string A_N,
string E_N,
int Type_ID,
int Account_Group_ID,
int Class_ID,
bool add_status
, string Note
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@Account_ID", SqlDbType.NVarChar, 15);
param[0].Value = Account_ID;
param[1] = new SqlParameter("@Account_Parent_ID", SqlDbType.NVarChar, 10);
param[1].Value = Account_Parent_ID;
param[2] = new SqlParameter("@A_N", SqlDbType.NVarChar, (50));
param[2].Value = A_N;
param[3] = new SqlParameter("@E_N", SqlDbType.NVarChar, (50));
param[3].Value = E_N;
param[4] = new SqlParameter("@Type_ID", SqlDbType.Int);
param[4].Value = Type_ID;
param[5] = new SqlParameter("@Account_Group_ID", SqlDbType.Int);
param[5].Value = Account_Group_ID;
param[6] = new SqlParameter("@Class_ID", SqlDbType.Int);
param[6].Value = Class_ID;
param[7] = new SqlParameter("@add_status", SqlDbType.Bit);
param[7].Value = add_status;
param[8] = new SqlParameter("@Note", SqlDbType.NVarChar);
param[8].Value = Note;
param[9] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[9].Value = PL.main.Use_id;
DAL.Executecommade("P_AC_insert_Account_Request", param);
}
public void proc_Edit_User(string Username, string Password, string Employee_ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
param[0].Value = Username;
param[1] = new SqlParameter("@Password", SqlDbType.NVarChar, 50);
param[1].Value = Password;
param[2] = new SqlParameter("@id", SqlDbType.NChar, 10);
param[2].Value = Employee_ID;
DAL.Executecommade("proc_Edit_User", param);
DAL.Close();
}
//@FYear int
// ,@Inst_num int
// ,@inst_type int
// ,@line_num int
// ,@Product_ID nvarchar(30)
// ,@UnitCost money
// ,@Units_ID nvarchar(10)
// ,@Quantity float
// ,@Quantity_out float
public void p_INV_insert_Product_Movmant_Line(
int Inst_num,
int inst_type,
int line_num,
string Product_ID,
decimal UnitCost,
string Units_ID,
decimal Quantity,
decimal Quantity_out
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@FYear ", SqlDbType.Int);
param[0].Value = PL.main.Fyear;
param[1] = new SqlParameter("@Inst_num", SqlDbType.Int);
param[1].Value = Inst_num;
param[2] = new SqlParameter("@inst_type", SqlDbType.Int);
param[2].Value = inst_type;
param[3] = new SqlParameter("@line_num", SqlDbType.Int);
param[3].Value = line_num;
param[4] = new SqlParameter("@Product_ID", SqlDbType.NVarChar);
param[4].Value = Product_ID;
param[5] = new SqlParameter("@UnitCost", SqlDbType.Money);
param[5].Value = UnitCost;
param[6] = new SqlParameter("@Units_ID", SqlDbType.NVarChar);
param[6].Value = Units_ID;
param[7] = new SqlParameter("@Quantity", SqlDbType.Float);
param[7].Value = Quantity;
param[8] = new SqlParameter("@Quantity_out", SqlDbType.Float);
param[8].Value = Quantity_out;
DAL.Executecommade("p_INV_insert_Product_Movmant_Line", param);
}
public void P_AC_insert_Account_Currency(
string currency_Key,
string Account_ID,
bool used
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@currency_Key", SqlDbType.NVarChar);
param[0].Value = currency_Key;
param[1] = new SqlParameter("@Account_ID", SqlDbType.NVarChar);
param[1].Value = Account_ID;
param[2] = new SqlParameter("@Used", SqlDbType.Bit);
param[2].Value = used;
DAL.Executecommade("P_AC_insert_Account_Currency", param);
}
public void p_AM_insert_Product_type(
int Type_ID,
string A_N,
string E_N
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Type_ID", SqlDbType.Int);
param[0].Value = Type_ID;
param[1] = new SqlParameter("@A_N", SqlDbType.NVarChar);
param[1].Value = A_N;
param[2] = new SqlParameter("@E_N", SqlDbType.NVarChar);
param[2].Value = E_N;
param[3] = new SqlParameter("@py_user", SqlDbType.NVarChar, 50);
param[3].Value = PL.main.Use_id;
DAL.Executecommade("p_AM_insert_Product_type", param);
}
// create proc[dbo].[P_Ath_insert_invantory_User]
// @Inventory_ID int
//,@User_ID int
//,@Show bit
//, @Add bit
//,@by_user nvarchar(50)
public void P_Ath_insert_invantory_User(int Inventory_ID, int user_id, bool Show, bool Add)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Inventory_ID", SqlDbType.Int);
param[0].Value = Inventory_ID;
param[1] = new SqlParameter("@User_ID", SqlDbType.Int);
param[1].Value = user_id;
param[2] = new SqlParameter("@Show", SqlDbType.Bit);
param[2].Value = Show;
param[3] = new SqlParameter("@Add", SqlDbType.Bit);
param[3].Value = Add;
param[4] = new SqlParameter("@by_user", SqlDbType.NVarChar);
param[4].Value = PL.main.Use_id;
DAL.Executecommade("P_Ath_insert_invantory_User", param);
DAL.Close();
}
//p_AC_insert_Account_group
public void p_AC_insert_Account_group(int Group_ID,
string A_N,
string E_N
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Group_ID", SqlDbType.Int);
param[0].Value = Group_ID;
param[1] = new SqlParameter("@A_N", SqlDbType.NVarChar, (20));
param[1].Value = A_N;
param[2] = new SqlParameter("@E_N", SqlDbType.NVarChar, (20));
param[2].Value = E_N;
param[3] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[3].Value = PL.main.Use_id;
DAL.Executecommade("p_AC_insert_Account_group", param);
}
public void P_INV_insert_Sup_order(
int Inst_num
, int Invontory_ID
, int S_C_Num
, int S_C_type
, string Car_num
, string Driver_A_N
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Inst_num ", SqlDbType.Int);
param[0].Value = Inst_num;
param[1] = new SqlParameter("@Invontory_ID", SqlDbType.Int);
param[1].Value = Invontory_ID;
param[2] = new SqlParameter("@FYear", SqlDbType.Int);
param[2].Value = PL.main.Fyear;
param[3] = new SqlParameter("@S_C_Num", SqlDbType.Int);
param[3].Value = S_C_Num;
param[4] = new SqlParameter("@S_C_type", SqlDbType.Int);
param[4].Value = S_C_type;
param[5] = new SqlParameter("@Car_num", SqlDbType.NVarChar);
param[5].Value = Car_num;
param[6] = new SqlParameter("@Driver_A_N", SqlDbType.NVarChar);
param[6].Value = Driver_A_N;
DAL.Executecommade("P_INV_insert_Sup_order", param);
}
public void P_INV_insert_tr_inv(
int Inst_num
, int inst_type
, int Invontory_ID
, int Invontory_dis_ID
, int S_C_Num
, int S_C_type
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@Inst_num ", SqlDbType.Int);
param[0].Value = Inst_num;
param[1] = new SqlParameter("@inst_type ", SqlDbType.Int);
param[1].Value = inst_type;
param[2] = new SqlParameter("@Invontory_ID", SqlDbType.Int);
param[2].Value = Invontory_ID;
param[3] = new SqlParameter("@Invontory_dis_ID", SqlDbType.Int);
param[3].Value = Invontory_dis_ID;
param[4] = new SqlParameter("@S_C_Num", SqlDbType.Int);
param[4].Value = S_C_Num;
param[5] = new SqlParameter("@S_C_type", SqlDbType.Int);
param[5].Value = S_C_type;
DAL.Executecommade("P_INV_insert_tr_inv", param);
}
private void btn_seve_Click(object sender, EventArgs e)
{
if (txt_id.Text == "<جديد>")
{
txt_id.Text = instrumrnt.instr_num(type_id);
}
instrumrnt.P_AC_insert_instrument(Convert.ToInt32(txt_id.Text), Convert.ToInt32(type_id), dtb_mov_date.Value.ToString("yyyy-MM-dd"), true,
txt_Note.Text, chbx_deported.Checked, chbx_stope.Checked, Convert.ToInt32(cbx_cost_canter.SelectedValue.ToString()),
txt_refer_num.Text, txt_tran_Num.Text, "YER", from_inv["Account_ID"].ToString(), true);
instrumrnt.P_INV_insert_tr_inv(Convert.ToInt32(txt_id.Text), Convert.ToInt32(type_id), Convert.ToInt32(cbx_Inv_from.SelectedValue.ToString()), Convert.ToInt32(cbx_inv_to.SelectedValue.ToString()), 0, 0);
if (type_id == 1.ToString())
{
foreach (DataGridViewRow row in dgv_mov_line.Rows)
{
if (row.Cells["product_ID"].Value != null)
{
instrumrnt.p_INV_insert_Product_Movmant_Line(Convert.ToInt32(txt_id.Text), Convert.ToInt32(type_id), row.Index + 1, row.Cells["product_ID"].Value.ToString(), 0, row.Cells["Unit"].Value.ToString(), 0, Convert.ToDecimal(row.Cells["Quantity"].Value));
}
}
}
if (type_id == 2.ToString())
{
foreach (DataGridViewRow row in dgv_mov_line.Rows)
{
if (row.Cells["product_ID"].Value != null)
{
instrumrnt.p_INV_insert_Product_Movmant_Line(Convert.ToInt32(txt_id.Text), 2, row.Index + 1, row.Cells["product_ID"].Value.ToString(), Convert.ToDecimal(row.Cells["cost"].Value), row.Cells["Unit"].Value.ToString(), Convert.ToDecimal(row.Cells["Quantity"].Value), 0);
}
}
if (txt_tran_Num.Text != string.Empty)
{
dal.Executecommade("Update INV_Product_Movmant set receved=1 where ID=" + DB.select_Row(this.Tag.ToString(), "Movmant_num", txt_tran_Num.Text, "Documant_Type_ID", 1.ToString() + " and FYear=" + PL.main.Fyear)["ID"]);
}
}
}
public void p_INV_insert_Inventorys(
int Invontory_ID,
string Inventory_A_N,
string Inventory_E_N,
string Storekeepr,
string Inventory_Location,
string phone_num,
int Sequence,
int Country_ID,
bool Primery_Store,
int Gov_id,
int Distinct_id,
int Account_ID,
int Inventory_Group_ID,
bool For_sale,
bool stop
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@Invontory_ID ", SqlDbType.Int);
param[0].Value = Invontory_ID;
param[1] = new SqlParameter("@Inventory_A_N", SqlDbType.NVarChar);
param[1].Value = Inventory_A_N;
param[2] = new SqlParameter("@Inventory_E_N", SqlDbType.NVarChar);
param[2].Value = Inventory_E_N;
param[3] = new SqlParameter("@Storekeepr", SqlDbType.NVarChar);
param[3].Value = Storekeepr;
param[4] = new SqlParameter("@Inventory_Location", SqlDbType.NVarChar);
param[4].Value = Inventory_Location;
param[5] = new SqlParameter("@phone_num", SqlDbType.NVarChar);
param[5].Value = phone_num;
param[6] = new SqlParameter("@Sequence", SqlDbType.Int);
param[6].Value = Sequence;
param[7] = new SqlParameter("@Country_ID", SqlDbType.Int);
param[7].Value = Country_ID;
param[8] = new SqlParameter("@Primery_Store", SqlDbType.Bit);
param[8].Value = Primery_Store;
param[9] = new SqlParameter("@Gov_id", SqlDbType.Int);
param[9].Value = Gov_id;
param[10] = new SqlParameter("@Distinct_id", SqlDbType.Int);
param[10].Value = Distinct_id;
param[11] = new SqlParameter("@Btanch_ID", SqlDbType.Int);
param[11].Value = PL.main.Btanch_ID;
param[12] = new SqlParameter("@Account_ID", SqlDbType.Int);
param[12].Value = Account_ID;
param[13] = new SqlParameter("@Inventory_Group_ID", SqlDbType.Int);
param[13].Value = Inventory_Group_ID;
param[14] = new SqlParameter("@For_sale", SqlDbType.Bit);
param[14].Value = For_sale;
param[15] = new SqlParameter("@stop", SqlDbType.Bit);
param[15].Value = stop;
param[16] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[16].Value = PL.main.Use_id;
DAL.Executecommade("p_INV_insert_Inventorys", param);
}
// ALTER proc[dbo].[P_AM_insert_Branches]
// @Branch_ID int,
// @Branch_A_N nvarchar(30),
// @Branch_E_N nvarchar(30),
// @Phone_num nvarchar(15),
//@location nvarchar(50),
// @Fax_num nvarchar(15),
// @Mail_box nvarchar(15),
// @B_F_Tele nvarchar(15),
// @B_F_Box nvarchar(15),
// @B_F_Fax nvarchar(15),
// @A_note nvarchar(max),
// @E_note nvarchar(50),
// @Tax_num nvarchar(30),
//@year_id nvarchar(5),
// @Company_ID int,
//@Branch_Image image,
// @Country_ID int,
//@Gov_id int,
//@Distinct_id int,
// @by_user nvarchar(50)
public void P_AM_insert_Branches(
int Branch_ID,
string Branch_A_N,
string Branch_E_N,
string Phone_num,
string location,
string Fax_num,
string Mail_box,
string B_F_Tele,
string B_F_Box,
string B_F_Fax,
string A_note,
string E_note,
string Tax_num,
string year_id,
int Company_ID,
Byte[] Branch_Image,
int Country_ID,
int Gov_id,
int Distinct_id
)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[20];
param[0] = new SqlParameter("@Branch_ID ", SqlDbType.Int);
param[0].Value = Branch_ID;
param[1] = new SqlParameter("@Branch_A_N", SqlDbType.NVarChar);
param[1].Value = Branch_A_N;
param[2] = new SqlParameter("@Branch_E_N", SqlDbType.NVarChar);
param[2].Value = Branch_E_N;
param[3] = new SqlParameter("@Phone_num", SqlDbType.NVarChar);
param[3].Value = Phone_num;
param[4] = new SqlParameter("@location", SqlDbType.NVarChar);
param[4].Value = location;
param[5] = new SqlParameter("@Mail_box", SqlDbType.NVarChar);
param[5].Value = Mail_box;
param[6] = new SqlParameter("@Fax_num", SqlDbType.NVarChar);
param[6].Value = Fax_num;
param[7] = new SqlParameter("@B_F_Tele", SqlDbType.NVarChar);
param[7].Value = B_F_Tele;
param[8] = new SqlParameter("@B_F_Box", SqlDbType.NVarChar);
param[8].Value = B_F_Box;
param[9] = new SqlParameter("@B_F_Fax", SqlDbType.NVarChar);
param[9].Value = B_F_Fax;
param[10] = new SqlParameter("@A_note", SqlDbType.NVarChar);
param[10].Value = A_note;
param[11] = new SqlParameter("@E_note", SqlDbType.NVarChar);
param[11].Value = E_note;
param[12] = new SqlParameter("@Tax_num", SqlDbType.NVarChar);
param[12].Value = Tax_num;
param[13] = new SqlParameter("@year_id", SqlDbType.NVarChar);
param[13].Value = year_id;
param[14] = new SqlParameter("@Company_ID", SqlDbType.Int);
param[14].Value = Company_ID;
param[15] = new SqlParameter("@Branch_Image", SqlDbType.Image);
param[15].Value = Branch_Image;
param[16] = new SqlParameter("@Country_ID", SqlDbType.Int);
param[16].Value = Country_ID;
param[17] = new SqlParameter("@Gov_id", SqlDbType.Int);
param[17].Value = Gov_id;
param[18] = new SqlParameter("@Distinct_id", SqlDbType.Bit);
param[18].Value = Distinct_id;
param[19] = new SqlParameter("@by_user", SqlDbType.NVarChar, 50);
param[19].Value = PL.main.Use_id;
DAL.Executecommade("P_AM_insert_Branches", param);
}
