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