private void ManageWorkFrm_Load(object sender, EventArgs e)
{
fillcombo();
radGridView1.DataSource = WorkCmd.GetAll();
FromDateTimePicker.Value = DateTime.Now.Date;
ToDateTimePicker.Value = DateTime.Now.Date;
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (RadMessageBox.Show(this, "هل تريد حفظ التعديلات", "حفظ", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
var ListData = WorkCmd.GetWorkInfo(UserClass.XEmpId, DateTime.Now.Date);
foreach (var item in ListData)
{
Startime = DateTime.Parse(item.startTime.ToString());
}
float compMonth = (DateTime.Now.Minute + DateTime.Now.Hour * 60) - (Startime.Minute + Startime.Hour * 60);
float Totaltime = compMonth / 60;
WorkTable tb = new WorkTable()
{
EmpId = UserClass.XEmpId,
WorkDate = DateTime.Now.Date,
startTime = Startime.TimeOfDay,
endtime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = Totaltime,
DefernceTime = (Totaltime - UserClass.XWorkTime),
WorkFinsh = "true"
};
WorkCmd.EditWorkUser(tb);
RadMessageBox.Show("تم تسجيل الانصراف", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
Loginfrm myForm = (Loginfrm)Application.OpenForms["Loginfrm"];
myForm.Show();
this.Close();
}
}
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 radGridView1_CommandCellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
{
var col = radGridView1.CurrentColumn.Index;
if (col == 7)
{
EditWorkFrm frm = new EditWorkFrm();
WorkTable tb = (WorkTable)radGridView1.CurrentRow.DataBoundItem;
frm.Wtb = tb;
frm.ShowDialog();
}
if (col == 8)
{
if (RadMessageBox.Show(this, "هل تريد حذف السجل", "حذف السجلات", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
if (WorkCmd.DeleteWork(((WorkTable)this.radGridView1.CurrentRow.DataBoundItem).Id))
{
}
else
{
RadMessageBox.Show("لا يمكن حذف السجل", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
}
}
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;
}
#endregion
var q = WorkCmd.CheckWork(int.Parse(EmpComboBox.SelectedValue.ToString()), radDateTimePicker1.Value.Date);
if (q != null)
{
RadMessageBox.Show("مسجل في هذا التاريخ مسبقاً", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
return;
}
float compMonth = (endtimeTimeEdit.Time.Minute + endtimeTimeEdit.Time.Hour * 60) - (startTimeTimeEdit.Time.Minute + startTimeTimeEdit.Time.Hour * 60);
float Totaltime = compMonth / 60;
WorkTime = Totaltime;
Defernce = WorkTime - WorkHour;
WorkTable tb = new WorkTable()
{
EmpId = int.Parse(EmpComboBox.SelectedValue.ToString()),
WorkDate = radDateTimePicker1.Value.Date,
startTime = startTimeTimeEdit.Time.TimeOfDay,
endtime = endtimeTimeEdit.Time.TimeOfDay,
RealWorkTimeNo = WorkHour,
WorkTime = WorkTime,
DefernceTime = Defernce,
WorkFinsh = "true"
};
WorkCmd.addWork(tb);
RadMessageBox.Show("تمت عملية الحفظ", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
EmpComboBox.Focus();
}
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;
}
#endregion
float compMonth = (endtimeTimeEdit.Time.Minute + endtimeTimeEdit.Time.Hour * 60) - (startTimeTimeEdit.Time.Minute + startTimeTimeEdit.Time.Hour * 60);
float Totaltime = compMonth / 60;
WorkTime = Totaltime;
Defernce = WorkTime - WorkHour;
if (RadMessageBox.Show(this, "هل تريد حفظ التعديلات", "حفظ", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
Wtb.EmpId = int.Parse(EmpComboBox.SelectedValue.ToString());
Wtb.startTime = startTimeTimeEdit.Time.TimeOfDay;
Wtb.endtime = endtimeTimeEdit.Time.TimeOfDay;
Wtb.WorkTime = WorkTime;
Wtb.RealWorkTimeNo = WorkHour;
Wtb.DefernceTime = Defernce;
Wtb.WorkFinsh = "true";
WorkCmd.EditWork(Wtb);
}
this.Close();
}
private void EditWorkFrm_Load(object sender, EventArgs e)
{
fillcombo();
var ListData = WorkCmd.GetEMpInfo(int.Parse(EmpComboBox.SelectedValue.ToString()));
foreach (var item in ListData)
{
WorkHour = float.Parse(item.WorkTimeNo.ToString());
}
EmpComboBox.Text = Wtb.EmpTable.EmpName;
startTimeTimeEdit.EditValue = Wtb.startTime;
radDateTimePicker1.Value = Wtb.WorkDate.Value.Date;
endtimeTimeEdit.EditValue = Wtb.endtime;
}
private void radMultiColumnComboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (EmpComboBox.SelectedValue == null)
{
return;
}
var ListData = WorkCmd.GetEMpInfo(int.Parse(EmpComboBox.SelectedValue.ToString()));
foreach (var item in ListData)
{
WorkHour = float.Parse(item.WorkTimeNo.ToString());
startTimeTimeEdit.EditValue = item.StartTime;
endtimeTimeEdit.EditValue = item.EndTime;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
WorkTable tb = new WorkTable()
{
EmpId = UserClass.XEmpId,
WorkDate = DateTime.Now.Date,
startTime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
endtime = DateTime.Parse(DateTime.Now.ToShortTimeString()).TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = 0,
DefernceTime = (0 - UserClass.XWorkTime)
};
WorkCmd.addWork(tb);
RadMessageBox.Show("تم تسجيل الحضور", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
Loginfrm myForm = (Loginfrm)Application.OpenForms["Loginfrm"];
myForm.Show();
this.Close();
}
private void UserWorkFrm_Load(object sender, EventArgs e)
{
var q = WorkCmd.CheckWork(UserClass.XEmpId, DateTime.Now.Date);
if (q != null)
{
simpleButton1.Enabled = false;
simpleButton2.Enabled = true;
if (q.WorkFinsh == "true")
{
simpleButton1.Enabled = false;
simpleButton2.Enabled = false;
}
}
else
{
simpleButton1.Enabled = true;
simpleButton2.Enabled = false;
}
EmpNameTxt.Text = UserClass.XEmpName;
timer1.Start();
}
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;
radGridView1.DataSource = WorkCmd.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;
radGridView1.DataSource = WorkCmd.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;
radGridView1.DataSource = WorkCmd.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;
}
}
private void simpleButton1_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 (radDropDownList1.Text == "")
{
radDropDownList1.BackColor = Color.OrangeRed;
radDropDownList1.Focus();
return;
}
else
{
radDropDownList1.BackColor = Color.White;
}
#endregion
var q = WorkCmd.CheckWork(int.Parse(EmpComboBox.SelectedValue.ToString()), LeaveDateTimePicker.Value.Date);
if (q != null)
{
if (RadMessageBox.Show(this, "هل تريد حفظ التغيرات", "تنبيه", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
LvTb.EmpId = int.Parse(EmpComboBox.SelectedValue.ToString());
LvTb.LeaveDate = LeaveDateTimePicker.Value.Date;
LvTb.LeaveTime = leaveTimeTimeEdit.Time.TimeOfDay;
LvTb.BackTime = backTimeTimeEdit.Time.TimeOfDay;
LvTb.LeaveType = radDropDownList1.Text;
LeaveCmdClass.EditLeave(LvTb);
}
if (RadMessageBox.Show(this, "هل يتم اعتماد ساعة العودة ساعة الانصراف", "تنبيه", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
var ListData = WorkCmd.GetWorkInfo(int.Parse(EmpComboBox.SelectedValue.ToString()), LeaveDateTimePicker.Value.Date);
foreach (var item in ListData)
{
Startime = DateTime.Parse(item.startTime.ToString());
UserClass.XWorkTime = float.Parse(item.RealWorkTimeNo.ToString());
}
float compMonth = (backTimeTimeEdit.Time.Minute + backTimeTimeEdit.Time.Hour * 60) - (Startime.Minute + Startime.Hour * 60);
float Totaltime = compMonth / 60;
WorkTable tb1 = new WorkTable()
{
EmpId = int.Parse(EmpComboBox.SelectedValue.ToString()),
WorkDate = LeaveDateTimePicker.Value.Date,
startTime = Startime.TimeOfDay,
endtime = leaveTimeTimeEdit.Time.TimeOfDay,
RealWorkTimeNo = UserClass.XWorkTime,
WorkTime = Totaltime,
DefernceTime = (Totaltime - UserClass.XWorkTime),
WorkFinsh = "true"
};
WorkCmd.EditWorkUser(tb1);
RadMessageBox.Show("تمت الاضافة واعتماد ساعة الانتهاء من الدوام", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
}
RadMessageBox.Show("تمت الاضافة بدون اعتماد ساعةالانتهاء من الدوام", "تمت", MessageBoxButtons.OK, RadMessageIcon.Info);
}
else
{
RadMessageBox.Show("يرجى اولا تسجيل الحضور", "خطأ", MessageBoxButtons.OK, RadMessageIcon.Error);
return;
}
}
