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();
}
