public void SalesMainForm() { try { tabControlSales = xtraTabControlSalesContent; MainTabPageAddCustomer = new XtraTabPage(); MainTabPageUpdateCustomer = new XtraTabPage(); MainTabPagePrintCustomer = new XtraTabPage(); EmpBranchId = UserControl.UserBranch(dbconnection); SpecialOrdersFunction(); //Calculate the time of the actual work of the delegates timer.Interval = 1000 * 60; timer.Tick += new EventHandler(GetNonRequestedSpecialOrders); timer.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
//private void gridView1_RowStyle(object sender, RowStyleEventArgs e) //{ // try // { // GridView View = sender as GridView; // if (e.RowHandle >= 0) // { // string category = View.GetRowCellDisplayText(e.RowHandle, View.Columns["Error"]); // if (category == "1") // { // e.Appearance.BackColor = Color.Salmon; // } // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} //functions public void search() { PSloaded = false; DelegateBranchID = UserControl.UserBranch(conn); //if (delegateID == -1) //{ // delegateID = -1; //} conn.Open(); string query = "select * from delegate where Branch_ID=" + DelegateBranchID; MySqlDataAdapter da = new MySqlDataAdapter(query, conn); DataTable dt = new DataTable(); da.Fill(dt); comDelegate.DataSource = dt; comDelegate.DisplayMember = dt.Columns["Delegate_Name"].ToString(); comDelegate.ValueMember = dt.Columns["Delegate_ID"].ToString(); //comDelegate.SelectedIndex = delegateID; comDelegate.SelectedValue = delegateID; txtBillNum.Text = billNum.ToString(); query = "select * from customer"; da = new MySqlDataAdapter(query, conn); dt = new DataTable(); da.Fill(dt); comCustomer.DataSource = dt; comCustomer.DisplayMember = dt.Columns["Customer_Name"].ToString(); comCustomer.ValueMember = dt.Columns["Customer_ID"].ToString(); conn.Close(); loadFunc(); PSloaded = true; //GridColumn colBillNumber = gridView1.Columns["Bill_Number"]; //gridView1.BeginSort(); //gridView1.ClearGrouping(); //colBillNumber.GroupIndex = 0; //gridView1.EndSort(); }
private void Commitment_Report_Load(object sender, EventArgs e) { try { string query = "select * from delegate where Branch_ID=" + UserControl.UserBranch(conn) + " and Error=0"; conn.Open(); MySqlDataAdapter da = new MySqlDataAdapter(query, conn); DataTable dt = new DataTable(); da.Fill(dt); comDelegate.DataSource = dt; comDelegate.DisplayMember = dt.Columns["Delegate_Name"].ToString(); comDelegate.ValueMember = dt.Columns["Delegate_ID"].ToString(); comDelegate.Text = ""; conn.Close(); loaded = true; } catch(Exception ex) { MessageBox.Show(ex.Message); } }
private void CustomerReturnBill_Load(object sender, EventArgs e) { try { string query = "select * from branch"; MySqlDataAdapter da = new MySqlDataAdapter(query, dbconnection); DataTable dt = new DataTable(); da.Fill(dt); comBranch.DataSource = dt; comBranch.DisplayMember = dt.Columns["Branch_Name"].ToString(); comBranch.ValueMember = dt.Columns["Branch_ID"].ToString(); comBranch.Text = ""; txtBranchID.Text = ""; comBranchLoaded = true; EmpBranchId = UserControl.UserBranch(dbconnection); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public SpecialOrders_Report() { InitializeComponent(); conn = new MySqlConnection(connection.connectionString); MainTabControlPS = MainForm.tabControlSales; //panelAddCustomer = new Panel(); //panelUpdateCustomer = new Panel(); //panelPrintCustomer = new Panel(); gridcontrol = gridControl1; EmpBranchId = UserControl.UserBranch(conn); //gridView1.PostEditor(); //gridView1.UpdateCurrentRow(); gridView1.OptionsBehavior.EditingMode = DevExpress.XtraGrid.Views.Grid.GridEditingMode.EditFormInplace; gridView1.OptionsEditForm.CustomEditFormLayout = new AdvancedEditForm(EmpBranchId); //gridView1.ShowInplaceEditForm(); //gridView1.OptionsBehavior.EditingMode = DevExpress.XtraGrid.Views.Grid.GridEditingMode.Default; }
//review public void test(int DelegateId, int BillNum) { int count = 0; string query = "SELECT dash_details.Data_ID FROM dash_details INNER JOIN dash ON dash.Dash_ID = dash_details.Dash_ID where dash.Bill_Number=" + BillNum + " and dash.Branch_ID=" + UserControl.UserBranch(conn); MySqlCommand com = new MySqlCommand(query, conn); conn.Open(); MySqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { count++; } labelNotify.Text = (count).ToString(); if (Convert.ToInt16(labelNotify.Text) > 0) { labelNotify.Visible = true; //delegateID = DelegateId; //billNum = BillNum; } else { labelNotify.Visible = false; //delegateID = 0; //billNum = 0; } delegateID = DelegateId; billNum = BillNum; dr.Close(); conn.Close(); }
private void LoadGridData() { EmpBranchId = UserControl.UserBranch(dbconnection); //and delegate.Error=0 dbconnection.Open(); MySqlCommand adapter = new MySqlCommand("SELECT delegate.Delegate_ID,delegate.Delegate_Name FROM delegate where delegate.Branch_ID=" + EmpBranchId + "", dbconnection); dr = adapter.ExecuteReader(); BindingList <GridData> lista = new BindingList <GridData>(); if (dr.HasRows) { while (dr.Read()) { lista.Add(new GridData() { DelegateId = Convert.ToInt16(dr["Delegate_ID"].ToString()), DelegateName = dr["Delegate_Name"].ToString(), StatusID = "-1" }); } dr.Close(); } gridControl1.DataSource = lista; dbconnection.Close(); if (gridView1.IsLastVisibleRow) { gridView1.FocusedRowHandle = gridView1.RowCount - 1; } List <ComboData> lista_combo = new List <ComboData>(); lista_combo.Add(new ComboData() { StatusId = 1, Status = "متاح" }); lista_combo.Add(new ComboData() { StatusId = 2, Status = "مشغول" }); lista_combo.Add(new ComboData() { StatusId = 3, Status = "استراحة" }); lista_combo.Add(new ComboData() { StatusId = 4, Status = "انصراف" }); repositoryItemLookUpEdit1.DataSource = lista_combo; repositoryItemLookUpEdit1.DisplayMember = "Status"; repositoryItemLookUpEdit1.ValueMember = "StatusId"; repositoryItemLookUpEdit1.Columns.Clear(); repositoryItemLookUpEdit1.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo() { Caption = "الحالة", FieldName = "Status" }); repositoryItemLookUpEdit1.EditValueChanged += repositoryItemLookUpEdit1_EditValueChanged; //repositoryItemLookUpEdit1.Closed += repositoryItemLookUpEdit1_Closed; gridView1.Columns[3].ColumnEdit = repositoryItemButtonEdit1; }
public void search() { try { string query = ""; if (comDelegate.Text != "") { query = "SELECT dash.Delegate_Name as 'المندوب',dash.Bill_Number as 'الفاتورة',dash.Bill_Time as 'الوقت المستغرق' FROM dash where DATE_FORMAT(dash.Bill_Date,'%Y-%m-%d') between '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' and dash.Delegate_ID=" + comDelegate.SelectedValue.ToString(); } else { query = "SELECT dash.Delegate_Name as 'المندوب',dash.Bill_Number as 'الفاتورة',dash.Bill_Time as 'الوقت المستغرق' FROM dash where DATE_FORMAT(dash.Bill_Date,'%Y-%m-%d') between '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' and dash.Branch_ID=" + UserControl.UserBranch(conn); } conn.Open(); MySqlDataAdapter adpt = new MySqlDataAdapter(query, conn); DataSet dset = new DataSet(); adpt.Fill(dset); gridControl1.DataSource = dset.Tables[0]; //gridView1.Columns[0].Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }
public void search() { try { string query = ""; if (comDelegate.Text != "") { query = "select Attendance_ID as 'التسلسل', Name as 'المندوب', Absence_Date as 'تاريخ الغياب' from attendance where DATE_FORMAT(Absence_Date,'%Y-%m-%d') between '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' and Delegate_ID=" + comDelegate.SelectedValue.ToString() + " and Absence_Date is not null and Error=0"; } else { query = "select Attendance_ID as 'التسلسل', Name as 'المندوب', Absence_Date as 'تاريخ الغياب' from attendance INNER JOIN delegate ON attendance.Delegate_ID = delegate.Delegate_ID where DATE_FORMAT(Absence_Date,'%Y-%m-%d') between '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "' and delegate.Branch_ID=" + UserControl.UserBranch(conn) + " and Absence_Date is not null and attendance.Error=0"; } conn.Open(); MySqlDataAdapter adpt = new MySqlDataAdapter(query, conn); DataSet dset = new DataSet(); adpt.Fill(dset); gridControl1.DataSource = dset.Tables[0]; gridView1.Columns[0].Visible = false; txtSum.Visible = true; label4.Visible = true; txtSum.Text = ""; txtSum.Text = (gridView1.RowCount).ToString(); //btnDelete.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }
public void search() { string query = "SELECT dash_delegate_bill.Delegate_ID,dash_delegate_bill.Delegate_Name as 'المندوب',dash_delegate_bill.Bill_Number as 'الفاتورة' FROM dash_delegate_bill where dash_delegate_bill.Branch_ID=" + UserControl.UserBranch(conn); conn.Open(); MySqlDataAdapter adpt = new MySqlDataAdapter(query, conn); DataSet dset = new DataSet(); adpt.Fill(dset); gridControl1.DataSource = dset.Tables[0]; gridView1.Columns[0].Visible = false; conn.Close(); }