private void EmpGridView_CommandCellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e) { var col = EmpGridView.CurrentColumn.Index; if (col == 6) { EditEmpFrm frm = new EditEmpFrm(); EmpTable tb = (EmpTable)EmpGridView.CurrentRow.DataBoundItem; frm.MyEMP = tb; frm.ShowDialog(); } if (col == 7) { if (RadMessageBox.Show(this, "هل تريد حذف السجل", "حذف السجلات", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes) { if (EmpCmd.DeleteDepartment(((EmpTable)this.EmpGridView.CurrentRow.DataBoundItem).Id)) { ManagEmpfrm_Load(null, null); } else { RadMessageBox.Show("لا يمكن حذف السجل", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error); } } } }
public void GetAllEmployee() { var q = EmpCmd.GetAll(); ReportDataSource rs = new ReportDataSource(); List <EmpObj> ls = new List <EmpObj>(); int counter = 0; foreach (var item in q) { counter++; ls.Add(new EmpObj() { id = counter, empname = item.EmpName, empNo = item.EmpNo, start = DateTime.Parse(item.StartTime.ToString()), end = DateTime.Parse(item.EndTime.ToString()), worktime = float.Parse(item.WorkTimeNo.ToString()), }); } rs.Name = "DataSet1"; rs.Value = ls; ReportFrm frm = new ReportFrm(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.EmpReport.rdlc"; frm.ShowDialog(); }
public void GetRptCollectionByDateAndID(DateTime date1, DateTime date2) { var q = EmpCmd.GetAll(); ReportDataSource rs = new ReportDataSource(); List <MonthyObj> ls = new List <MonthyObj>(); foreach (var item in q) { ls.Add(new MonthyObj() { id = item.Id, EmpName = item.EmpName, empNo = item.EmpNo, TotalDays = WorkCmd.GetTotalCountDayWork(date1, date2, item.Id), HoldyDays = WorkCmd.GetTotalCountDayHolady(date1, date2, item.Id), WorkHouer = WorkCmd.GetTotalWorkTime(date1, date2, item.Id), RealWorkHour = WorkCmd.GetTotalRealWork(date1, date2, item.Id), Defernce = WorkCmd.GetTotalDefrncMonth(date1, date2, item.Id), }); } rs.Name = "DataSet1"; rs.Value = ls; ReportFrm frm = new ReportFrm(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.MonthlyReport.rdlc"; frm.ShowDialog(); }
private void LoginBtn_Click(object sender, EventArgs e) { var q = EmpCmd.Login(UserTxt.Text.ToString(), PassText.Text.ToString()); if (q != null) { MainForm frm = new MainForm(); frm.ShowDialog(); } else { RadMessageBox.Show("خطأ في كلمة المرور", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error); return; } }
private void Addbtn_Click(object sender, EventArgs e) { if (RadMessageBox.Show(this, "هل تريد حفظ التعديلات", "حفظ", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes) { MyEMP.EmpName = empNameTextEdit.Text; MyEMP.EmpNo = empNoTextEdit.Text; MyEMP.StartTime = startTimeTimeEdit.Time.TimeOfDay; MyEMP.EndTime = endTimeTimeEdit.Time.TimeOfDay; MyEMP.WorkTimeNo = float.Parse(workTimeNoSpinEdit.EditValue.ToString()); MyEMP.Pssword = psswordTextEdit.Text; EmpCmd.EditDepartment(MyEMP); RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info); this.Close(); } }
private void fillcombo() { this.EmpComboBox.MultiColumnComboBoxElement.DropDownWidth = 500; this.EmpComboBox.ValueMember = "Id"; this.EmpComboBox.DisplayMember = "EmpName"; EmpComboBox.DataSource = EmpCmd.GetAll(); this.EmpComboBox.AutoFilter = true; CompositeFilterDescriptor compositeFilter = new CompositeFilterDescriptor(); FilterDescriptor empname = new FilterDescriptor("EmpName", FilterOperator.Contains, ""); FilterDescriptor empNumber = new FilterDescriptor("EmpNo", FilterOperator.Contains, ""); compositeFilter.FilterDescriptors.Add(empname); compositeFilter.FilterDescriptors.Add(empNumber); compositeFilter.LogicalOperator = FilterLogicalOperator.Or; this.EmpComboBox.EditorControl.FilterDescriptors.Add(compositeFilter); }
private void Addbtn_Click(object sender, EventArgs e) { #region " CheckFillTextBox " if (empNameTextEdit.Text == "") { empNameTextEdit.BackColor = Color.OrangeRed; empNameTextEdit.Focus(); return; } else { empNameTextEdit.BackColor = Color.White; } if (empNoTextEdit.Text == "") { empNoTextEdit.BackColor = Color.OrangeRed; empNoTextEdit.Focus(); return; } else { empNoTextEdit.BackColor = Color.White; } #endregion EmpTable tb = new EmpTable() { EmpName = empNameTextEdit.Text, EmpNo = empNoTextEdit.Text, WorkTimeNo = float.Parse(workTimeNoSpinEdit.EditValue.ToString()), StartTime = startTimeTimeEdit.Time.TimeOfDay, EndTime = endTimeTimeEdit.Time.TimeOfDay, Pssword = psswordTextEdit.Text, }; EmpCmd.addEmp(tb); RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info); empNameTextEdit.ResetText(); empNoTextEdit.ResetText(); psswordTextEdit.ResetText(); empNameTextEdit.Focus(); }
private void EnterBtn_Click(object sender, EventArgs e) { var q = EmpCmd.Login(empNoTextEdit.Text.ToString()); if (q != null) { UserClass.XEmpId = q.Id; UserClass.XEmpName = q.EmpName; UserClass.XWorkTime = float.Parse(q.WorkTimeNo.ToString()); UserWorkFrm frm = new UserWorkFrm(); this.Hide(); frm.ShowDialog(); Loginfrm_Load(null, null); } else { RadMessageBox.Show("تأكد من الرقم الوظيفي", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error); return; } }
private void ManagEmpfrm_Load(object sender, EventArgs e) { EmpGridView.DataSource = EmpCmd.GetAll(); }