public XRep10(DataSources.Linq.vTBLMembersPlusShadetKed row) { InitializeComponent(); appOptionsTableAdapter.Fill(dsTeachersUnionQuery1.AppOptions); DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adp = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); lblName.Text = row.MemberName; lblJobtitle.Text = row.Jobtitle; lblSyndicate.Text = row.Syndicate; lblKideNumber.Text = row.KideNumber.ToString(); lblDate.Text = DateTime.Now.ToShortDateString(); }
private void btnUpdate_Click(object sender, EventArgs e) { if (tbtbesalnoUpdate.EditValue == null || FXFW.SqlDB.IsNullOrEmpty(tbtbesalnoUpdate.EditValue)) return; if (MessageBox.Show("هل انت متأكد؟", "تعديل", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.No) return; DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adp = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); foreach (DataSources.dsTeachersUnionQuery.FixesalnoTBLMembersRow member in dsTeachersUnionQuery.FixesalnoTBLMembers) { adp.UpdateQueryesalno(Convert.ToInt32(tbtbesalnoUpdate.EditValue), member.MemberId); } Program.ShowMsg("تم التعديل", false, this); Program.Logger.LogThis("تم التعديل", Text, FXFW.Logger.OpType.success, null, null, this); btnSearch_Click(btnSearch, EventArgs.Empty); }
private void btnTarheal_Click(object sender, EventArgs e) { if (FXFW.SqlDB.IsNullOrEmpty(LUEHafza.EditValue)) return; string msg = "سوف يتم ترحيل فقط من تحتوي بياناته علي " + Environment.NewLine; msg += "النقابة" + Environment.NewLine; msg += "اللجنة" + Environment.NewLine; msg += "الاسم" + Environment.NewLine; msg += "الوظيفة" + Environment.NewLine; msg += "رقم الايصال" + Environment.NewLine; msg += "الصورة" + Environment.NewLine; msg += "مراجعة قيد" + Environment.NewLine; msg += "رقم القيد" + Environment.NewLine; msg += "نوع العضوية" + Environment.NewLine; msg += "هل انت متأكد؟" + Environment.NewLine; if (MessageBox.Show(msg, "تحزير ...", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.No) return; int savedMemberCount = 0; int savedAksatCount = 0; int savedHalaCount = 0; int savedSadadCount = 0; DataSources.dsTeachersUnion.TBLHafzawebListRow rowHafza = (DataSources.dsTeachersUnion.TBLHafzawebListRow)((DataRowView)LUEHafza.GetSelectedDataRow()).Row; tblMemberWebTableAdapter.FillByhafzaid(dsTeachersUnionList.TBLMemberWeb, Convert.ToDouble(LUEHafza.EditValue)); DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adp = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); for (int i = 0; i < dsTeachersUnionList.TBLMemberWeb.Count; i++) { DataSources.dsTeachersUnion.TBLMemberWebRow webRow = (DataSources.dsTeachersUnion.TBLMemberWebRow)dsTeachersUnionList.TBLMemberWeb.Rows[i]; DataSources.dsTeachersUnion.TBLMembersRow row = dsTeachersUnionList.TBLMembers.NewTBLMembersRow(); if (!webRow.IsclosedNull() && webRow.closed == true) continue; if (webRow.IsSyndicateIdNull() || webRow.IsSubCommitteIdNull() || webRow.IsJobtitleIDNull() || webRow.IsMemberNameNull() || webRow.IsimagepathNull() || webRow.imagepath == string.Empty || webRow.IsesalnoNull() || webRow.MemberName == string.Empty || webRow.IsrekeedNull() || webRow.rekeed == false || webRow.IsKideNumberNull() || webRow.KideNumber == 0 || webRow.IsCardtypeIdNull()) continue; if (!webRow.IsestefaaNull() && webRow.estefaa)//estefaa should be 'false' continue; if (!File.Exists(Program.imgPathWeb + webRow.imagepath)) continue; DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adpMem = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter(); DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter adpMemWeb = new DataSources.dsTeachersUnionTableAdapters.TBLMemberWebTableAdapter(); if (adpMem.ScalarQueryExistsKideNumber(webRow.KideNumber) != 0) continue; row.MemberId = 1; if (!webRow.IsSyndicateIdNull()) row.SyndicateId = webRow.SyndicateId; if (!webRow.IsSubCommitteIdNull()) row.SubCommitteId = webRow.SubCommitteId; if (!webRow.IsMemberNameNull()) row.MemberName = webRow.MemberName; if (!webRow.IsBirthDateNull()) row.BirthDate = webRow.BirthDate; //row.QualtypeId = webRow.QualtypeId; if (!webRow.IsJobtitleIDNull()) row.JobtitleID = webRow.JobtitleID; //row.membertypeid = webRow.membertypeid; if (!webRow.IsWorkeDateNull()) row.WorkeDate = webRow.WorkeDate; //row.kasmDate = webRow.kasmDate; //row.estefaa = webRow.estefaa; if (!webRow.IsesalnoNull()) row.esalno = webRow.esalno; row.RandomCard = new Random().Next(100, 999).ToString(); //if (webRow.IsKideNumberNull() || webRow.KideNumber.ToString().Length == 0) // row.KideNumber = (int)adp.ScalarQueryNewKideNumber(); //else row.KideNumber = webRow.KideNumber; row.img = Program.imgPath + row.KideNumber + Program.imgExt; row.cardtype = webRow.CardtypeId; if (!webRow.IsdateendNull()) row.dateend = webRow.dateend; if (!webRow.IsInstallmentNull()) row.Installment = webRow.Installment; row.MemberShipNumber = (int)adp.ScalarQueryNewMemberShipNumber(); row.userin = Program.UserInfo.UserId; row.datein = SQLProvider.GetServerDateTime(); row.trheelprog = true; if (!webRow.IsmnidNull()) { row.MemberNId = webRow.mnid; List<object> ID = Misc.Misc.IDExtraction(webRow.mnid); if (ID.Count == 3) { row.MemberGender = Convert.ToByte(ID[0]); row.BirthDate = Convert.ToDateTime(ID[1]); //row.MemberaddresGov = Convert.ToByte(ID[2]); } } dsTeachersUnionList.TBLMembers.AddTBLMembersRow(row); if (File.Exists(Program.imgPathWeb + webRow.imagepath)) { if (File.Exists(row.img)) File.Delete(row.img); File.Move(Program.imgPathWeb + webRow.imagepath, row.img); } adp.Update(row); savedMemberCount++; row.MemberId = (int)adp.ScalarQueryKideNumberByMemberId(row.KideNumber); webRow.closed = true; tblMemberWebTableAdapter.Update(webRow); //Tarhel AksatWeb for member DataSources.dsTeachersUnionTableAdapters.TBLAksatWEBTableAdapter adpAksatWeb = new DataSources.dsTeachersUnionTableAdapters.TBLAksatWEBTableAdapter(); adpAksatWeb.FillByMemberId(dsTeachersUnionList.TBLAksatWEB, webRow.MemberId); foreach (DataSources.dsTeachersUnion.TBLAksatWEBRow RowAksatWeb in dsTeachersUnionList.TBLAksatWEB.Rows) { DataSources.dsTeachersUnion.TBLAksatRow RowAksat = dsTeachersUnionList.TBLAksat.NewTBLAksatRow(); RowAksat.MemberId = row.MemberId; RowAksat.kestenddate = RowAksatWeb.kestenddate; RowAksat.mostahk = RowAksatWeb.mostahk; RowAksat.madfoaa = RowAksatWeb.madfoaa; RowAksat.esalno = RowAksatWeb.esalno; RowAksat.esaldate = RowAksatWeb.esaldate; RowAksat.userin = Program.UserInfo.UserId; RowAksat.datein = SQLProvider.GetServerDateTime(); dsTeachersUnionList.TBLAksat.AddTBLAksatRow(RowAksat); } DataSources.dsTeachersUnionTableAdapters.TBLAksatTableAdapter adpAksat = new DataSources.dsTeachersUnionTableAdapters.TBLAksatTableAdapter(); savedAksatCount += adpAksat.Update(dsTeachersUnionList.TBLAksat); //Tarhel Hala for member DataSources.dsTeachersUnionTableAdapters.TBLMemberHalaTableAdapter adpHala = new DataSources.dsTeachersUnionTableAdapters.TBLMemberHalaTableAdapter(); DataSources.dsTeachersUnionTableAdapters.TBLMemberHalaWebTableAdapter adpHalaWeb = new DataSources.dsTeachersUnionTableAdapters.TBLMemberHalaWebTableAdapter(); adpHalaWeb.FillByMemberId(dsTeachersUnionList.TBLMemberHalaWeb, webRow.MemberId); foreach (DataSources.dsTeachersUnion.TBLMemberHalaWebRow RowHalaWeb in dsTeachersUnionList.TBLMemberHalaWeb.Rows) { DataSources.dsTeachersUnion.TBLMemberHalaRow RowHala = dsTeachersUnionList.TBLMemberHala.NewTBLMemberHalaRow(); RowHala.MemberId = row.MemberId; RowHala.MemberSTypeId = RowHalaWeb.MemberSTypeId; if (!RowHalaWeb.IsgehaidNull()) RowHala.gehaid = RowHalaWeb.gehaid; RowHala.datefrom = RowHalaWeb.datefrom; if (!RowHalaWeb.IsdatetoNull()) RowHala.dateto = RowHalaWeb.dateto; if (!RowHalaWeb.IsremararksNull()) RowHala.remararks = RowHalaWeb.remararks; if (!RowHalaWeb.IsremararksNull()) RowHala.remararks = RowHalaWeb.remararks; RowHala.userin = Program.UserInfo.UserId; RowHala.datein = SQLProvider.GetServerDateTime(); dsTeachersUnionList.TBLMemberHala.AddTBLMemberHalaRow(RowHala); } savedHalaCount = +adpHala.Update(dsTeachersUnionList.TBLMemberHala); //Tarhel Sadad for member DataSources.dsTeachersUnionTableAdapters.TBLSadadTableAdapter adpSadad = new DataSources.dsTeachersUnionTableAdapters.TBLSadadTableAdapter(); DataSources.dsTeachersUnionTableAdapters.TBLSadadWebTableAdapter adpSadadWeb = new DataSources.dsTeachersUnionTableAdapters.TBLSadadWebTableAdapter(); adpSadadWeb.FillByMemberId(dsTeachersUnionList.TBLSadadWeb, webRow.MemberId); foreach (DataSources.dsTeachersUnion.TBLSadadWebRow RowSadadWeb in dsTeachersUnionList.TBLSadadWeb) { DataSources.dsTeachersUnion.TBLSadadRow RowSadad = dsTeachersUnionList.TBLSadad.NewTBLSadadRow(); RowSadad.MemberId = row.MemberId; RowSadad.esalno = RowSadadWeb.esalno; RowSadad.esaldate = RowSadadWeb.esaldate; RowSadad.esalmony = RowSadadWeb.esalmony; RowSadad.fatrafrom = RowSadadWeb.fatrafrom; RowSadad.fatrato = RowSadadWeb.fatrato; if (!RowSadadWeb.IsesalremarkNull()) RowSadad.esalremark = RowSadadWeb.esalremark; RowSadad.userin = Program.UserInfo.UserId; RowSadad.datein = SQLProvider.GetServerDateTime(); dsTeachersUnionList.TBLSadad.AddTBLSadadRow(RowSadad); } savedSadadCount += adpSadad.Update(dsTeachersUnionList.TBLSadad); } string saveMsg = string.Format("تم ترحيل اعضاء عدد {0} عضو {1} تم ترحيل اقساط عدد {2} قسط {3} تم ترحيل حالات {4} حالة {5} تم ترحيل سداد عدد {6}", savedMemberCount, Environment.NewLine, savedAksatCount, Environment.NewLine, savedHalaCount, Environment.NewLine, savedSadadCount); Program.ShowMsg(saveMsg, false, this); Program.Logger.LogThis(saveMsg, Text, FXFW.Logger.OpType.success, null, null, this); LUEHafza_EditValueChanged(LUEHafza, new EventArgs()); }
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); } }