public void btnSave_Click(System.Object sender, System.EventArgs e)
{
if (txtEmployeeName.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الموظف", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txtShiftOrderNo.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الوردية", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//try
//{
string TransACTIONID = Name + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Millisecond;
mTable.ExecuteNonQuery("BEGIN TransACTION " + TransACTIONID);
if (mTable.find("ID=" + mID))
{
mTable.Add_New();
mTable.SetFiled("Year", Settings.CurrentYear);
mTable.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable["dwYear"] = txtTransDate.Value.Year;
mTable["dwMonth"] = txtTransDate.Value.Month;
mTable["dwDay"] = txtTransDate.Value.Day;
mTable["dwHour"] = dtpAttTime.Value.Hour;
mTable["dwMinute"] = dtpAttTime.Value.Minute;
mTable["dwSecond"] = dtpAttTime.Value.Second;
mTable.Update("ID=" + mID);
//---------------------------------------
mTable2.Add_New();
mTable2.SetFiled("ID", mID);
mTable2.SetFiled("Year", Settings.CurrentYear);
mTable2.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable2.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable2.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable2.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable2.SetFiled("UserCode", Settings.CurrentUser_ID);
mTable2.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable2.SetFiled("TransTypeOld", radioButton1.Tag + "" == "true" ? 1 : 0);
mTable2.SetFiled("TransDateOld", txtTransDate.Tag);
mTable2.Update();
}
else
{
mTable.Add_New();
mTable.SetFiled("Year", Settings.CurrentYear);
mTable.SetFiled("Branch_ID", Settings.CurrentBranch_ID);
mTable.SetFiled("TransDate", Convert.ToDateTime(txtTransDate.Text + " " + dtpAttTime.Text));
mTable.SetFiled("ShiftOrderNo", txtShiftOrderNo.Text);
mTable.SetFiled("EmployeeCode", txtEmployeeCode.Text);
mTable.SetFiled("TransType", radioButton1.Checked ? 1 : 0);
mTable.Update();
}
mTable.ExecuteNonQuery("COMMIT TransACTION " + TransACTIONID);
NewRecord = false;
InProcess = false;
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else
if (MessageBox.Show("تم حفظ البيانات. ", "حفظ", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
btnNew_Click(null, null);
}
//}
//catch (Exception Ex)
//{
// MessageBox.Show(Ex.Message);
//}
}
public void btnSave_Click(System.Object sender, System.EventArgs e)
{
if (txtCode.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الكود", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txtName.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الاسم", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (NewRecord && mTable.find("Code=N\'" + txtCode.Text.Trim() + "\'"))
{
MessageBox.Show("الكود موجود من قبل...ولا يمكن اضافة جديد بهذا الكود", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCode.Text = "";
return;
}
try
{
string TransACTIONID = Name + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Millisecond;
mTable.ExecuteNonQuery("BEGIN TransACTION " + TransACTIONID);
InProcess = true;
mTable.Add_New();
mTable.SetFiled("Code", (BasicDataNo ? Convert.ToInt64(txtCode.Text).ToString() : txtCode.Text));
mTable.SetFiled("Name", txtName.Text);
if (where == "main=1")
{
mTable.SetFiled("Main", 1);
}
//mTable.SetFiled("MainNo", txtMainCode.Text);
mTable.Update("Code=N\'" + txtCode.Text.Trim() + "\'");
mTable.ExecuteNonQuery("COMMIT TransACTION " + TransACTIONID);
NewRecord = false;
InProcess = false;
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else
if (MessageBox.Show("تم حفظ البيانات...هل تريد مستند جديد؟", "حفظ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
btnNew_Click(null, null);
}
else
{
Retrieve();
}
}
catch (Exception Ex)
{
if (InProcess)
{
////mTable.ExecuteNonQuery("Rollback TransACTION " + TransACTIONID);
InProcess = false;
}
MessageBox.Show(Ex.Message);
}
}
public void btnSave_Click(System.Object sender, System.EventArgs e)
{
if (txtCode.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الكود", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (txtName.Text.Trim() == "")
{
MessageBox.Show("من فضلك ادخل الاسم", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (NewRecord && mTable.find("Code=N\'" + txtCode.Text.Trim() + "\'"))
{
MessageBox.Show("الكود موجود من قبل...ولا يمكن اضافة جديد بهذا الكود", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
txtCode.Text = "";
return;
}
if (txtFingerPrintCode.Text.Trim() != "")
{
if (mTable.find("Code<>N\'" + txtCode.Text.Trim() + "\' and FingerPrintCode=" + txtFingerPrintCode.Text))
{
MessageBox.Show(
string.Format("كود الموظف علي ماكنية البصمة موجود بالفعل علي الموظف : {0}", mTable["Code"]), "",
MessageBoxButtons.OK, MessageBoxIcon.Error);
txtFingerPrintCode.Text = "";
return;
}
}
NewRecord = false;
mTable.Add_New();
mTable["Code"] = (BasicDataNo ? Convert.ToInt64(txtCode.Text).ToString() : txtCode.Text);
mTable["Name"] = txtName.Text;
mTable["FingerPrintCode"] = txtFingerPrintCode.Text;
mTable["Gender"] = cmbGender.SelectedIndex;
mTable["ReligionCode"] = cmbReligionCode.SelectedValue;
mTable.SetFiled(txtDateofBirth);
mTable["PlaceofBirth"] = txtPlaceofBirth.Text;
mTable["MotherName"] = txtMotherName.Text;
mTable["FatherName"] = txtFatherName.Text;
mTable["HealthOfficecode"] = cmbHealthOfficecode.SelectedValue;
mTable["NationalID"] = txtNationalID.Text;
mTable.SetFiled(txtNationalIDDate);
mTable["InusranceID"] = txtInusranceID.Text;
mTable["MaterialState"] = cmbMaterialState.SelectedIndex;
mTable["MilitaryService"] = cmbMilitaryService.SelectedIndex;
//--------------------
if (Pic.Image != null)
{
Bitmap newBitmap1 = new Bitmap(Pic.Image);
var ms1 = new MemoryStream();
newBitmap1.Save(ms1, ImageFormat.Jpeg);
byte[] photoAray1 = new byte[ms1.Length];
ms1.Position = 0;
ms1.Read(photoAray1, 0, photoAray1.Length);
ms1.Close();
mTable["EmployeePicture"] = photoAray1;
}
//--------------------
mTable["Tel1"] = txtTel1.Text;
mTable["Tel2"] = txtTel2.Text;
mTable["Mobile1"] = txtMobile1.Text;
mTable["Mobile2"] = txtMobile2.Text;
mTable["Email"] = txtEmail.Text;
mTable["CityCode"] = cmbCity.SelectedValue;
//--------------------
mTable["VariableSalary"] = txtVariableSalary.Text;
mTable["BasicSalary"] = txtBasicSalary.Text;
mTable["JobCode"] = cmbJobs.SelectedValue;
mTable["DeptCode"] = cmbDepts.SelectedValue;
mTable["ManagementCode"] = cmbManagements.SelectedValue;
mTable["Qualification"] = cmbQualification.SelectedValue;
mTable["WorkStatus"] = cmbWorkStatus.SelectedIndex;
mTable["Manager"] = cmbManager.SelectedValue;
mTable["Specialization"] = txtSpecialization.Text;
mTable.SetFiled(dtbDateofLeavingWork);
mTable.SetFiled(dtpDateofAppointment);
mTable["HourPrice"] = txtHourPrice.Text;
mTable.Update("Code=N\'" + txtCode.Text.Trim() + "\'");
//------------shifts---------------
var mEmployeesShifts = new MATRIX("EmployeesShifts");
//mEmployeesShifts.Delete(string.Format("Employeecode='{0}'", txtCode.Text));
//for (int i = 1; i < grdShifts.Rows.Count; i++)
//{
// if (grdShifts[i, "ShiftName"] != null)
// {
// mEmployeesShifts.Add_New();
// mEmployeesShifts.SetFiled("EmployeeCode", txtCode.Text);
// mEmployeesShifts.SetFiled("ShiftCode", grdShifts[i, "ShiftName"]);
// mEmployeesShifts.Update();
// }
//}
//------------HoliDays---------------
var mEmployeesHoliDays = new MATRIX("EmployeesHoliDays");
//mEmployeesHoliDays.Delete(string.Format("Employeecode='{0}'", txtCode.Text));
//for (int i = 1; i < grdHoliDays.Rows.Count; i++)
//{
// if (grdHoliDays[i, "chk"] != null && (bool)grdHoliDays[i, "chk"])
// {
// mEmployeesHoliDays.Add_New();
// mEmployeesHoliDays.SetFiled("EmployeeCode", txtCode.Text);
// mEmployeesHoliDays.SetFiled("EnglishName", grdHoliDays[i, "EnglishName"]);
// mEmployeesHoliDays.Update();
// }
//}
//------------ الاستقطاعات ---------------
var mEmployees2 = new MATRIX("Employees2");
mEmployees2.Delete(string.Format("Employeecode='{0}'", txtCode.Text));
//for (int i = 1; i < grdDeduction.Rows.Count; i++)
//{
// if ((grdDeduction[i, "DeductiontName"] + "").Trim() != "")
// {
// mEmployees2.Add_New();
// mEmployees2.SetFiled("EmployeeCode", txtCode.Text);
// mEmployees2.SetFiled("Code", grdDeduction[i, "DeductiontName"]);
// mEmployees2.SetFiled("DataType", 1);
// mEmployees2.SetFiled("Type", grdDeduction[i, "Type"]);
// mEmployees2.SetFiled("Qty", grdDeduction[i, "Qty"]);
// mEmployees2.SetFiled("Value", grdDeduction[i, "Value"]);
// mEmployees2.Update();
// }
//}
//------------ الاستحقاقات ---------------
mEmployees2 = new MATRIX("Employees2");
//for (int i = 1; i < grdMerit.Rows.Count; i++)
//{
// if ((grdMerit[i, "MerittName"] + "").Trim() != "")
// {
// mEmployees2.Add_New();
// mEmployees2.SetFiled("EmployeeCode", txtCode.Text);
// mEmployees2.SetFiled("Code", grdMerit[i, "MerittName"]);
// mEmployees2.SetFiled("DataType", 2);
// mEmployees2.SetFiled("Type", grdMerit[i, "Type"]);
// mEmployees2.SetFiled("Qty", grdMerit[i, "Qty"]);
// mEmployees2.SetFiled("Value", grdMerit[i, "Value"]);
// mEmployees2.Update();
// }
//}
//for (int i = 0; i < pnlPic.Controls.Count; i++)
//{
// var doc =new EmployeesDocument();
// doc.DocPic= (PictureBox)[i]
//}
mEmployees2 = new MATRIX("EmployeesDocuments");
mEmployees2.Delete(string.Format("Employeecode='{0}'", txtCode.Text));
foreach (var pic_ in pnlPic.Controls)
{
var pic = new PictureBox();
pic.Image = ((PictureBox)pic_).Image;
mEmployees2.Add_New();
mEmployees2["EmployeeCode"] = txtCode.Text;
//---------------------
//MemoryStream ms = new MemoryStream();
//pic.Image.Save(ms, pic.Image.RawFormat);
//byte[] a = ms.ToArray();
Bitmap newBitmap = new Bitmap(pic.Image);
var ms = new MemoryStream();
newBitmap.Save(ms, ImageFormat.Jpeg);
byte[] photoAray = new byte[ms.Length];
ms.Position = 0;
ms.Read(photoAray, 0, photoAray.Length);
ms.Close();
mEmployees2["DocPic"] = photoAray;
//---------------------
mEmployees2.Update();
}
//------------
if (SaveMsgDontShow)
{
btnNew_Click(null, null);
}
else if (
MessageBox.Show("تم حفظ البيانات...هل تريد مستند جديد؟", "حفظ", MessageBoxButtons.YesNo,
MessageBoxIcon.Information) == DialogResult.Yes)
{
btnNew_Click(null, null);
}
else
{
Retrieve();
}
Tree1.FillTree();
}