private void btnSave_Click(object sender, EventArgs e) { if (radioGroupType.SelectedIndex == 1 && dedateend.EditValue == null) { Program.ShowMsg("يجب ادخال تاريخ انتهاء الؤقت", false, this, true); return; } if (ceestefaa.Checked && tbKideNumber.Text != string.Empty) { Program.Logger.LogThis("لا يمكن حفظ استيفاء ألا بعد حذف رقم القيد", Text, FXFW.Logger.OpType.fail, null, null, this); return; } if (_row.estefaa == true && !_row.IsKideNumberNull()) { Program.Logger.LogThis("لا يمكن حفظ استيفاء ألا بعد حذف رقم القيد", Text, FXFW.Logger.OpType.success, null, null, this); return; } if (lueSyndicateId.EditValue != null) _row.SyndicateId = Convert.ToInt32(lueSyndicateId.EditValue); if (lueSubCommitteId.EditValue != null) _row.SubCommitteId = Convert.ToInt32(lueSubCommitteId.EditValue); if (tbMemberName.EditValue != null) _row.MemberName = Convert.ToString(tbMemberName.EditValue); if (deBirthDate.EditValue != null) _row.BirthDate = Convert.ToDateTime(deBirthDate.EditValue); if (lueQualtypeId.EditValue != null) _row.QualtypeId = Convert.ToByte(lueQualtypeId.EditValue); if (lueJobtitleID.EditValue != null) _row.JobtitleID = Convert.ToInt32(lueJobtitleID.EditValue); if (luemembertypeid.EditValue != null) _row.membertypeid = Convert.ToByte(luemembertypeid.EditValue); if (deWorkeDate.EditValue != null) _row.WorkeDate = Convert.ToDateTime(deWorkeDate.EditValue); if (dekasmDate.EditValue != null) _row.kasmDate = Convert.ToDateTime(dekasmDate.EditValue); if (ceclosed.EditValue != null) _row.closed = Convert.ToBoolean(ceclosed.EditValue); if (ceestefaa.EditValue != null) _row.estefaa = Convert.ToBoolean(ceestefaa.EditValue); if (cerekeed.EditValue != null) _row.rekeed = Convert.ToBoolean(cerekeed.EditValue); //if (Misc.Misc.CalcAge(_row.BirthDate) >= 45 && _row.NewMember) //{ // //Program.Logger.LogThis("لا يجب ادخال عضو اكبر من 45 سنة", Text, FXFW.Logger.OpType.fail, null, null, this); // if (MessageBox.Show("هذا العضو اكبر من 45 سنه هل ترغب في حفظ العضو كعضو قديم؟", "عضو جديد غير لائق", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.No) // return; // else // _row.NewMember = false; //} // if (tbestefareson.EditValue != null) { if (tbestefareson.EditValue.ToString() == string.Empty && FXFW.SqlDB.UserInfo.UserID != "1") Program.Logger.LogThis("سوف يتم الحفظ لكن لن يتم مسح سبب الاستيفاء", Text, FXFW.Logger.OpType.success, null, null, this); else _row.estefareson = Convert.ToString(tbestefareson.EditValue); } if (tbmnid.EditValue != null) _row.mnid = tbmnid.EditValue.ToString(); if (deestefadate.EditValue != null) _row.estefadate = Convert.ToDateTime(deestefadate.EditValue); if (dereternestefadate.EditValue != null) _row.reternestefadate = Convert.ToDateTime(dereternestefadate.EditValue); if (tbesalno.EditValue != null && tbesalno.EditValue.ToString() != string.Empty) _row.esalno = Convert.ToInt32(tbesalno.EditValue); else _row.SetesalnoNull(); if (tbKideNumber.EditValue != null && tbKideNumber.EditValue.ToString() != string.Empty) { int KideNumber = Convert.ToInt32(tbKideNumber.EditValue); DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adpMem = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter adpMemWeb = new DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter(); if (_row.RowState == DataRowState.Detached) { if (adpMem.ScalarQueryExistsKideNumber(KideNumber) != 0 || adpMemWeb.ScalarQueryExistsKideNumber(_row.MemberId, KideNumber) != 0) { Program.ShowMsg("رقم القيد موجود مسبقا", true, this); Program.Logger.LogThis("رقم القيد موجود مسبقا", Text, FXFW.Logger.OpType.warning, null, null, this); return; } } else { int memberid = 0; if (_row.closed) memberid = (int)adpMem.ScalarQueryKideNumberByMemberId(_row.KideNumber); if (adpMem.ScalarQueryExistsKideNumber_MemberId(KideNumber, memberid) != 0 || adpMemWeb.ScalarQueryExistsKideNumber(_row.MemberId, KideNumber) != 0) { Program.ShowMsg("رقم القيد موجود مسبقا", true, this); Program.Logger.LogThis("رقم القيد موجود مسبقا", Text, FXFW.Logger.OpType.warning, null, null, this); return; } } _row.KideNumber = KideNumber; } else _row.SetKideNumberNull(); if (radioGroupType.SelectedIndex == 0) { _row.CardtypeId = 1; } else if (radioGroupType.SelectedIndex == 1) { _row.CardtypeId = 2; _row.dateend = dedateend.DateTime; _row.Installment = ceInstallment.Checked; } if (ImageChanged)// if user pick another image { System.IO.MemoryStream ms = new System.IO.MemoryStream(); if (peimagepath.Image != null) { peimagepath.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); peimagepath.Image.Dispose(); peimagepath.Image = null; } if (!_row.IsimagepathNull() && _row.imagepath != string.Empty) { if (System.IO.File.Exists(Program.imgPathWeb + _row.imagepath)) System.IO.File.Delete(Program.imgPathWeb + _row.imagepath); } if (ms.Length > 0) { string fileName = string.Format("{0}{1}{2}{3}{4}{5}{6}.jpg", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second, DateTime.Now.Millisecond); Image.FromStream(ms).Save(Program.imgPathWeb + fileName); ms.Close(); _row.imagepath = fileName; } } if (tbKideNumber.Properties.Buttons[0].Kind == DevExpress.XtraEditors.Controls.ButtonPredefines.Plus) _row.kednew = true; else _row.kednew = false; _row.userin = Program.UserInfo.UserId; _row.datein = SQLProvider.GetServerDateTime(); if (!_row.IsKideNumberNull() && _KideNumber != _row.KideNumber) _row.userked = _row.userin; if (!_row.IsesalnoNull()) { if (_row["esalno", DataRowVersion.Current].ToString() != _row["esalno", DataRowVersion.Original].ToString()) { if (Convert.ToInt32(SQLProvider.adpQry.eslanoRemains(_row.esalno)) - 1 < 0) { Program.Logger.LogThis("هذا الايصال تم ادخال كل اعضائة", Text, FXFW.Logger.OpType.fail, null, null, this); return; } } } DialogResult = System.Windows.Forms.DialogResult.OK; }
private void repositoryItemButtonEditEdit_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { GridView GV = (GridView)gridControlData.MainView; DataSources.dsTeachersUnion.TBLMemberWebRow row = (DataSources.dsTeachersUnion.TBLMemberWebRow)GV.GetFocusedDataRow(); if (!row.IsclosedNull() && row.closed && !Program.UserInfo.IsAdmin) { Program.ShowMsg("لا يمكن تعديل حقل مغلق", true, this); Program.Logger.LogThis("لا يمكن تعديل حقل مغلق", Text, FXFW.Logger.OpType.information, null, null, this); dsTeachersUnionList.TBLMemberWeb.RejectChanges(); return; } tblMemberWebBindingSource.EndEdit(); if (row.IsCardtypeIdNull() || (!row.rekeed && !row.estefaa)) { Program.ShowMsg("بيانات فارغة يجب ادخالها", true, this); Program.Logger.LogThis("بيانات فارغة يجب ادخالها", Text, FXFW.Logger.OpType.information, null, null, this); return; } if (row.rekeed && row.estefaa) { Program.ShowMsg("لا يجب ان يكون العضو استيفاء ومراجعة قيد", true, this); Program.Logger.LogThis("لا يجب ان يكون العضو استيفاء ومراجعة قيد", Text, FXFW.Logger.OpType.information, null, null, this); return; } if (!row.IsesalnoNull()) { if (row["esalno", DataRowVersion.Current].ToString() != row["esalno", DataRowVersion.Original].ToString()) { if (Convert.ToInt32(SQLProvider.adpQry.eslanoRemains(row.esalno)) - 1 < 0) { Program.Logger.LogThis("هذا الايصال تم ادخال كل اعضائة", Text, FXFW.Logger.OpType.fail, null, null, this); return; } } } if (!row.IsKideNumberNull() && row.KideNumber != 0) { if (row.estefaa) { Program.Logger.LogThis("لا يمكن حفظ استيفاء ألا بعد حذف رقم القيد", Text, FXFW.Logger.OpType.fail, null, null, this); return; } int KideNumber = row.KideNumber; DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adpMem = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter adpMemWeb = new DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter(); if (adpMem.ScalarQueryExistsKideNumber(KideNumber) != 0 || adpMemWeb.ScalarQueryExistsKideNumber(row.MemberId, KideNumber) != 0) { Program.ShowMsg("رقم القيد موجود مسبقا", true, this); Program.Logger.LogThis("رقم القيد موجود مسبقا", Text, FXFW.Logger.OpType.warning, null, null, this); return; } } try { if (!row.IsInstallmentNull() && row.Installment) { int index = CheckAksatRowExists(row.MemberId); if (index == -1) { Program.Logger.LogThis("يجب مليء تفاصيل التقسيط", Text, FXFW.Logger.OpType.fail, null, null, this); return; } DataSources.dsTeachersUnion.TBLAksatWEBRow KstRow = (DataSources.dsTeachersUnion.TBLAksatWEBRow)dsTeachersUnionList.TBLAksatWEB[index]; if (KstRow.IsNull("kestenddate") || KstRow.IsNull("mostahk") || KstRow.IsNull("madfoaa") || KstRow.IsNull("esalno") || KstRow.IsNull("esaldate")) { Program.Logger.LogThis("تفاصيل التقسيط غير مكتملة", Text, FXFW.Logger.OpType.fail, null, null, this); return; } } row.datein = SQLProvider.GetServerDateTime(); row.userin = Program.UserInfo.UserId; tblMemberWebBindingSource.EndEdit(); tblMemberWebTableAdapter.Update(row); dsTeachersUnionList.TBLMemberWeb.AcceptChanges(); if (!row.IsInstallmentNull() && row.Installment) { tblAksatWEBTableAdapter.Update(dsTeachersUnionList.TBLAksatWEB[CheckAksatRowExists(row.MemberId)]); dsTeachersUnionList.TBLAksatWEB.AcceptChanges(); } Program.ShowMsg("تم الحفظ", false, this); Program.Logger.LogThis("تم الحفظ", Text, FXFW.Logger.OpType.success, null, null, this); } catch (Exception ex) { Program.ShowMsg(Misc.Misc.ExceptionMessage(ex), true, this); Program.Logger.LogThis(null, Text, FXFW.Logger.OpType.fail, ex, null, this); } }