private void HoldyGridView_CommandCellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e) { var col = HoldyGridView.CurrentColumn.Index; if (col == 4) { EditHoldyFrm frm = new EditHoldyFrm(); HoldyTable tb = (HoldyTable)HoldyGridView.CurrentRow.DataBoundItem; frm.Htb = tb; frm.ShowDialog(); } if (col == 5) { if (RadMessageBox.Show(this, "هل تريد حذف السجل", "حذف السجلات", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes) { if (HoldyCmd.DeleteHoldy(((HoldyTable)this.HoldyGridView.CurrentRow.DataBoundItem).Id)) { } else { RadMessageBox.Show("لا يمكن حذف السجل", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error); } } } }
private void ManageHoldyFrm_Load(object sender, EventArgs e) { fillcombo(); HoldyGridView.DataSource = HoldyCmd.GetAll(); FromDateTimePicker.Value = DateTime.Now.Date; ToDateTimePicker.Value = DateTime.Now.Date; }
private void SaveBtn_Click(object sender, EventArgs e) { #region " CheckFillTextBox " if (HoldyTypeDropDownList.Text == "") { HoldyTypeDropDownList.BackColor = Color.OrangeRed; HoldyTypeDropDownList.Focus(); return; } else { HoldyTypeDropDownList.BackColor = Color.White; } #endregion HoldyTable tb = new HoldyTable { EmpID = UserClass.XEmpId, HoldyDate = holdyDateTimePicker.Value.Date, HoldType = HoldyTypeDropDownList.Text, }; HoldyCmd.addHoldy(tb); RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info); Loginfrm myForm = (Loginfrm)Application.OpenForms["Loginfrm"]; myForm.Show(); this.Close(); }
private void SaveBtn_Click(object sender, EventArgs e) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (HoldyTypeDropDownList.Text == "") { HoldyTypeDropDownList.BackColor = Color.OrangeRed; HoldyTypeDropDownList.Focus(); return; } else { HoldyTypeDropDownList.BackColor = Color.White; } #endregion if (RadMessageBox.Show(this, "هل تريد حفظ التعديلات", "حفظ", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes) { Htb.EmpID = int.Parse(EmpComboBox.SelectedValue.ToString()); Htb.HoldyDate = holdyDateTimePicker.Value.Date; Htb.HoldType = HoldyTypeDropDownList.Text; HoldyCmd.EditHoldy(Htb); RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info); this.Close(); } }
public void GetRptCollectionByDateAndID(int ID, DateTime date1, DateTime date2) { var q = WorkCmd.GetByIDAndDate(ID, date1, date2); ReportDataSource rs = new ReportDataSource(); List <EmpWorkObj> ls = new List <EmpWorkObj>(); foreach (var item in q) { ls.Add(new EmpWorkObj() { Id = item.Id, empname = item.EmpTable.EmpName, empNo = item.EmpTable.EmpNo, WorkDat = item.WorkDate.Value, start = DateTime.Parse(item.startTime.ToString()), end = DateTime.Parse(item.endtime.ToString()), RealWork = float.Parse(item.RealWorkTimeNo.ToString()), worktime = float.Parse(item.WorkTime.ToString()), defernce = float.Parse(item.DefernceTime.ToString()), TotalDefernce = WorkCmd.GetTotalDefrnc(date1, date2, ID), TotalDays = WorkCmd.GetTotalCountDayWork(date1, date2, item.Id), HoldyDays = WorkCmd.GetTotalCountDayHolady(date1, date2, item.Id), TotalWorkHouer = WorkCmd.GetTotalWorkTime(date1, date2, item.Id), TotalRealWorkHour = WorkCmd.GetTotalRealWork(date1, date2, item.Id), }); } var q1 = HoldyCmd.GetByIDAndDate(ID, date1, date2); ReportDataSource rs1 = new ReportDataSource(); List <HoldyObj> ls1 = new List <HoldyObj>(); foreach (var item in q1) { ls1.Add(new HoldyObj() { HoldyDate = item.HoldyDate.Value, HoldyType = item.HoldType, }); } rs.Name = "DataSet1"; rs1.Name = "DataSet2"; rs.Value = ls; rs1.Value = ls1; ReportFrm frm = new ReportFrm(); frm.reportViewer1.LocalReport.DataSources.Clear(); frm.reportViewer1.LocalReport.DataSources.Add(rs); frm.reportViewer1.LocalReport.DataSources.Add(rs1); frm.reportViewer1.LocalReport.ReportEmbeddedResource = "PcdcrSystem.Report.EmpWorkReoprt.rdlc"; frm.ShowDialog(); }
private void AddBtn_Click(object sender, EventArgs e) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (HoldyTypeDropDownList.Text == "") { HoldyTypeDropDownList.BackColor = Color.OrangeRed; HoldyTypeDropDownList.Focus(); return; } else { HoldyTypeDropDownList.BackColor = Color.White; } #endregion var q = HoldyCmd.CheckHoldy(int.Parse(EmpComboBox.SelectedValue.ToString()), holdyDateTimePicker.Value.Date); if (q != null) { RadMessageBox.Show("مسجل في هذا التاريخ مسبقاً", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error); return; } HoldyTable tb = new HoldyTable() { EmpID = int.Parse(EmpComboBox.SelectedValue.ToString()), HoldyDate = holdyDateTimePicker.Value.Date, HoldType = HoldyTypeDropDownList.Text, }; HoldyCmd.addHoldy(tb); RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info); EmpComboBox.Focus(); HoldyTypeDropDownList.ResetText(); }
private void simpleButton1_Click(object sender, EventArgs e) { if (checkBox1.Checked == true && checkBox2.Checked == false) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } #endregion this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByEmpID(int.Parse(EmpComboBox.SelectedValue.ToString())); GC.SuppressFinalize(HoldyCmd.GetByEmpID(int.Parse(EmpComboBox.SelectedValue.ToString()))); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } if (checkBox1.Checked == false && checkBox2.Checked == true) { this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByDate(FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date); GC.SuppressFinalize(HoldyCmd.GetByDate(FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date)); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } if (checkBox1.Checked == true && checkBox2.Checked == true) { #region " CheckFillTextBox " if (EmpComboBox.Text == "") { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } if (EmpComboBox.SelectedValue == null) { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.OrangeRed; EmpComboBox.Focus(); return; } else { EmpComboBox.MultiColumnComboBoxElement.BackColor = Color.White; } #endregion this.Cursor = Cursors.WaitCursor; HoldyGridView.DataSource = HoldyCmd.GetByIDAndDate(int.Parse(EmpComboBox.SelectedValue.ToString()), FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date); GC.SuppressFinalize(HoldyCmd.GetByIDAndDate(int.Parse(EmpComboBox.SelectedValue.ToString()), FromDateTimePicker.Value.Date, ToDateTimePicker.Value.Date)); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Cursor = Cursors.Default; } }