public void BindCmb_JobType()
{
Cmb_Job_Name.DataSource = RetriveData.ExcuteQuery("Sp_Job_Type_SelectAll", CommandType.StoredProcedure);
Cmb_Job_Name.DisplayMember = "Job_Name";
Cmb_Job_Name.ValueMember = "Job_ID";
Cmb_Job_Name.Text = "";
}
public void BindCmb_Search()
{
comboBox1.DataSource = RetriveData.ExcuteQuery("Sp_Emplyees_SelectAll", CommandType.StoredProcedure);
comboBox1.DisplayMember = "Emp_Name";
comboBox1.ValueMember = "Emp_ID";
comboBox1.Text = "";
}
void Bindcombo()
{
comboBox1.DataSource = RetriveData.ExcuteQuery("Sp_Customers_SelectAll", CommandType.StoredProcedure);
comboBox1.DisplayMember = "Cust_Name";
comboBox1.ValueMember = "cust_ID";
comboBox1.Text = "";
}
void Bindcombo()
{
Cmb_Search.DataSource = RetriveData.ExcuteQuery("Sp_Vendors_SelectAll", CommandType.StoredProcedure);
Cmb_Search.DisplayMember = "Ven_Name";
Cmb_Search.ValueMember = "Ven_ID";
Cmb_Search.Text = "";
}
public void Bind_Cmb_ItemName()
{
Cmb_ItemName.DataSource = RetriveData.ExcuteQuery("Sp_Items_SelectAll", CommandType.StoredProcedure);
Cmb_ItemName.DisplayMember = "Item_Name";
Cmb_ItemName.ValueMember = "Item_ID";
Cmb_ItemName.Text = "";
}
public void BindGrid()
{
DataTable dt = new DataTable();
dt = RetriveData.ExcuteQuery("Sp_Job_Type_SelectAll", CommandType.StoredProcedure);
DVGrid.DataSource = dt;
}
public void BindGrid()
{
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Ven_Account_SelectAll", CommandType.StoredProcedure);
DVGrid.DataSource = Dt;
}
public void Bind_Cmb_CategoryID()
{
Cmb_CategoryID.DataSource = RetriveData.ExcuteQuery("Sp_Item_Category_SelectAll", CommandType.StoredProcedure);
Cmb_CategoryID.DisplayMember = "Category_Name";
Cmb_CategoryID.ValueMember = "Category_ID";
Cmb_CategoryID.Text = "";
}
public void Bind_Filter_Items()
{
Cmb_ItemName.DataSource = RetriveData.ExcuteQuery("Sp_Store_Convert_SelectByCategoryID", CommandType.StoredProcedure,
new Pararmter("@Category_ID", SqlDbType.Int, int.Parse(Cmb_CategoryName.SelectedValue.ToString())));
Cmb_ItemName.DisplayMember = "Item_Name";
Cmb_ItemName.ValueMember = "Item_ID";
Cmb_ItemName.Text = "";
}
private void Btn_Search_Click(object sender, EventArgs e)
{
if (Cmb_Search.Text != "")
{
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Vendors_SelectByID", CommandType.StoredProcedure, new Pararmter("@Ven_ID", SqlDbType.Int, int.Parse(Cmb_Search.SelectedValue.ToString())));
Lbl_Find.Text = Dt.Rows[0]["Ven_ID"].ToString();
Txt_RemainValue.Text = Dt.Rows[0]["Ven_Debit"].ToString();
}
}
private void Cmb_StoreTo_SelectedValueChanged(object sender, EventArgs e)
{
if (Cmb_StoreTo.Text == "" || Cmb_Item_Name.Text == "")
{
return;
}
DataTable dt = RetriveData.ExcuteQuery("Sp_StoreQuantity_SelectQuantity", CommandType.StoredProcedure,
new Pararmter("@Item_ID", SqlDbType.Int, int.Parse(Cmb_Item_Name.SelectedValue.ToString())),
new Pararmter("@Store_ID", SqlDbType.Int, int.Parse(Cmb_StoreTo.SelectedValue.ToString())));
Txt_CurrentQ2.Text = dt.Rows[0][0].ToString();
}
public void Bind_Emp_Name()
{
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Emplyees_SelectAll", CommandType.StoredProcedure);
Cmb_Emp_Name.DataSource = Dt;
Cmb_Emp_Name.DisplayMember = "Emp_Name";
Cmb_Emp_Name.ValueMember = "Emp_ID";
Cmb_Emp_Name.Text = "";
}
private void Btn_Search_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Customers_SelectByID", CommandType.StoredProcedure, new Pararmter("@Cust_ID", SqlDbType.Int, int.Parse(comboBox1.SelectedValue.ToString())));
Lbl_Cust_ID.Text = Dt.Rows[0]["Cust_ID"].ToString();
Txt_Name.Text = Dt.Rows[0]["cust_Name"].ToString();
Txt_Address.Text = Dt.Rows[0]["Cust_Address"].ToString();
Txt_Mobile.Text = Dt.Rows[0]["Mobile"].ToString();
Txt_Phone.Text = Dt.Rows[0]["Phone"].ToString();
Txt_Notes.Text = Dt.Rows[0]["Notes"].ToString();
}
}
public void Bind_StoreName()
{
Cmb_StoreFrom.DataSource = RetriveData.ExcuteQuery("Sp_Store_Data_SelectAll", CommandType.StoredProcedure);
Cmb_StoreTo.DataSource = RetriveData.ExcuteQuery("Sp_Store_Data_SelectAll", CommandType.StoredProcedure);
Cmb_StoreFrom.DisplayMember = "Store_Name";
Cmb_StoreFrom.ValueMember = "Store_ID";
Cmb_StoreTo.DisplayMember = "Store_Name";
Cmb_StoreTo.ValueMember = "Store_ID";
Cmb_StoreFrom.Text = "";
Cmb_StoreTo.Text = "";
}
private void Btn_Search_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Store_Data_selectByID", CommandType.StoredProcedure, new Pararmter("@Store_ID", SqlDbType.Int, comboBox1.SelectedValue));
Lbl_Cust_ID.Text = Dt.Rows[0]["Store_ID"].ToString();
Txt_Address.Text = Dt.Rows[0]["Store_Address"].ToString();
Txt_Name.Text = Dt.Rows[0]["store_Name"].ToString();
Txt_Notes.Text = Dt.Rows[0]["Store_Notes"].ToString();
Cmb_Emp_Name.SelectedValue = Dt.Rows[0]["Emp_ID"];
}
}
public void Bind_Cmbs()
{
Cmb_VendorName.DataSource = RetriveData.ExcuteQuery("Sp_Vendors_SelectAll", CommandType.StoredProcedure);
Cmb_VendorName.DisplayMember = "ven_Name";
Cmb_VendorName.ValueMember = "Ven_ID";
Cmb_VendorName.Text = "";
Cmb_StoreName.DataSource = RetriveData.ExcuteQuery("Sp_Store_Data_SelectAll", CommandType.StoredProcedure);
Cmb_StoreName.DisplayMember = "Store_Name";
Cmb_StoreName.ValueMember = "Store_ID";
Cmb_StoreName.Text = "";
Cmb_CategoryName.DataSource = RetriveData.ExcuteQuery("Sp_Item_Category_selectAll", CommandType.StoredProcedure);
Cmb_CategoryName.DisplayMember = "Category_Name";
Cmb_CategoryName.ValueMember = "Category_ID";
Cmb_CategoryName.Text = "";
}
private void Btn_Search_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("من فضلك يجب اختيار اسم الموظف", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); return;
}
DataTable Dt = new DataTable();
Dt = RetriveData.ExcuteQuery("Sp_Emplyees_SelectByID", CommandType.StoredProcedure,
new Pararmter("@Emp_ID", SqlDbType.Int, comboBox1.SelectedValue));
Lbl_Cust_ID.Text = Dt.Rows[0]["Emp_ID"].ToString();
Txt_Name.Text = Dt.Rows[0]["Emp_Name"].ToString();
Txt_Address.Text = Dt.Rows[0]["Emp_Address"].ToString();
Txt_Mobile.Text = Dt.Rows[0]["Emp_Mobile"].ToString();
Txt_Phone.Text = Dt.Rows[0]["Emp_Phone"].ToString();
Txt_PersonalID.Text = Dt.Rows[0]["personal_ID"].ToString();
Txt_BasicSalary.Text = Dt.Rows[0]["Basic_Salary"].ToString();
Cmb_Job_Name.SelectedValue = Dt.Rows[0]["Job_ID"];
}
public void BindDGVGrid()
{
DataTable Dt = RetriveData.ExcuteQuery("Sp_Store_Convert_SelectAll", CommandType.StoredProcedure);
DVGrid.DataSource = Dt;
}