private void BtnUpdate_Click(object sender, EventArgs e) { try { using (DBAuditDataContext dc = new DBAuditDataContext()) { // Detect DateTime Start DateTime?VarReservedPayDate; DateTime?VareInsurancePayDate; if (DateResevedPay.Enabled == true) { VarReservedPayDate = DateResevedPay.Value; } else { VarReservedPayDate = null; } if (DateInsurancePay.Enabled == true) { VareInsurancePayDate = DateInsurancePay.Value; } else { VareInsurancePayDate = null; } // Detect DateTime End // // Update process Start var c = dc.ProUpdateProject(int.Parse(ComboLocation.SelectedValue.ToString()), int.Parse(ComboContractor.SelectedValue.ToString()), TxtExcuteOrder.Text, DateExcuteOrder.Value, TxtPredicationOrder.Text, DatePredicationOreder.Value, int.Parse(TxtPeriod.Text), ComboDocNo.Text, DateStart.Value, DateEnd.Value, int.Parse(TxtActualPeriod.Text), TxtOperation.Text, Convert.ToDecimal(TxtAmount.Text), DatePay.Value, Convert.ToDecimal(TxtTaxRate.Text), Convert.ToDecimal(TxtTaxAmount.Text), Convert.ToDecimal(TxtTransRate.Text), Convert.ToDecimal(TxtTransAmount.Text), Convert.ToDecimal(TxtInsurRate.Text), Convert.ToDecimal(TxtInsurAmount.Text), ComboInsuranceRefund.Text, Convert.ToDecimal(TxtReservedRate.Text), Convert.ToDecimal(TxtReservedAmount.Text), ComboReservedRefund.Text, Convert.ToDecimal(TxtBusinessFees.Text), Convert.ToDecimal(TxtTotalDiscount.Text), Convert.ToDecimal(TxtNetAmount.Text), TxtJustAmount.Text, TxtReservedDocNo.Text, VarReservedPayDate, Convert.ToDecimal(TxtResDiscountPercentage.Text), Convert.ToDecimal(TxtResDiscountAmount.Text), Convert.ToDecimal(TxtReservedPaid.Text), TxtInsuranceDocNo.Text, VareInsurancePayDate, Convert.ToDecimal(TxtInsurDiscountPercentage.Text), Convert.ToDecimal(TxtInsuranceDiscountAmount.Text), Convert.ToDecimal(TxtInsurancePaid.Text), TxtNotes.Text); } MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); FrmModifyProject Frm = new FrmModifyProject(); Frm.Show(); // Update process End } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void BtnDelete_Click(object sender, EventArgs e) { try { DialogResult Rslt = MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Rslt == DialogResult.Yes) { using (DBAuditDataContext dc = new DBAuditDataContext()) { var c = dc.ProDeleteProject(ComboDocNo.Text); } MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); FrmModifyProject Frm = new FrmModifyProject(); Frm.Show(); } } catch (Exception EX) { MessageBox.Show(EX.Message); } }