private void BtnSave_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddProject(int.Parse(ComboLocation.SelectedValue.ToString()),
int.Parse(ComboContractor.SelectedValue.ToString()), TxtExcuteOrder.Text, DateExcuteOrder.Value,
TxtpredicationOrder.Text, DatepredicationOrder.Value, int.Parse(TxtPeriod.Text), TxtDocNo.Text,
DateStart.Value, DateEnd.Value, int.Parse(TxtActualPeriod.Text), TxtOperation.Text,
decimal.Parse(TxtAmount.Text), DatePay.Value, decimal.Parse(TxtTaxRate.Text),
decimal.Parse(TxtTaxAmount.Text), decimal.Parse(TxtTransRate.Text),
decimal.Parse(TxtTransAmount.Text), decimal.Parse(TxtInsurRate.Text),
decimal.Parse(TxtInsurAmount.Text), decimal.Parse(TxtReservedRate.Text),
decimal.Parse(TxtReservedAmount.Text), decimal.Parse(TxtBusinessFees.Text),
decimal.Parse(TxtTotalDiscount.Text), decimal.Parse(TxtNetAmount.Text), TxtJustAmount.Text,
TxtNotes.Text);
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK,
MessageBoxIcon.Information);
Close();
new FrmOperation().Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSearchPayDate_Click(object sender, EventArgs e)
{
// Formatting the form Start
TxtDocNo.Text = "";
ComboLocation.Text = "";
ComboContractor.Text = "";
ComboInsuranceStatus.Text = "";
ComboReservedStatues.Text = "";
// Formatting the form End
//
// Search operation Start
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProGetProjectByPayDate(DatePay.Value.Date);
GrdViewProject.DataSource = c;
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
// Search operation End
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
if (TxtPassword.Text == "")
{
dc.ProUpdateUserWithoutUpdatePassword(ComboUserName.Text, TxtFirstName.Text,
TxtLastName.Text, TxtAddress.Text, TxtTelephone.Text, TxtUserName.Text,
int.Parse(ComboUserGroups.SelectedValue.ToString()), _intDisbled, _intLocked,
TxtNotes.Text);
}
else
{
dc.ProUpdateUser(ComboUserName.Text, TxtFirstName.Text, TxtLastName.Text,
TxtAddress.Text, TxtTelephone.Text, TxtUserName.Text, _encryptedPass,
int.Parse(ComboUserGroups.SelectedValue.ToString()), _intDisbled, _intLocked,
TxtNotes.Text);
}
}
MessageBox.Show(Resources.MsgUserUpdated, Resources.AppName, MessageBoxButtons.OK,
MessageBoxIcon.Information);
Close();
new FrmModifyUser().Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSearchDocNo_Click(object sender, EventArgs e)
{
// Formatting the form:
LblTotalTrans.Visible = true;
LblTotalTravel.Visible = true;
TxtTotalTrans.Visible = true;
TxtTotalTravel.Visible = true;
LblPound1.Visible = true;
LblPound2.Visible = true;
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
// Search progress:
var c = dc.ProGetTransFeeByDocNo(TxtDocNo.Text);
GrdViewTransFees.DataSource = c;
// Calculating:
double?DoubleTotalTrans = null;
double?DoubleTotalTravel = null;
int? IntCount = null;
var d = dc.ProCountTotal(TxtDocNo.Text, ref DoubleTotalTrans, ref DoubleTotalTravel, ref IntCount);
TxtCountRec.Text = IntCount.ToString();
TxtTotalTrans.Text = DoubleTotalTrans.ToString();
TxtTotalTravel.Text = DoubleTotalTravel.ToString();
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnSearchLocation_Click(object sender, EventArgs e)
{
// Formatting the form:
LblTotalTrans.Visible = false;
LblTotalTravel.Visible = false;
TxtTotalTrans.Visible = false;
TxtTotalTravel.Visible = false;
LblPound1.Visible = false;
LblPound2.Visible = false;
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
// Calculating:
int?IntCount = null;
var d = dc.ProCountLocation(int.Parse(ComboLocation.SelectedValue.ToString()), ref IntCount);
TxtCountRec.Text = IntCount.ToString();
// Search Progress:
var c = dc.ProGetTransFeeByLocationID(int.Parse(ComboLocation.SelectedValue.ToString()));
GrdViewTransFees.DataSource = c;
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void FrmEditMyAccount_Load(object sender, EventArgs e)
{
try
{
// Get Current User name Start
_staticStrCurrentUserName = Security.GetCurrentUser();
// Get current user name End
//
// Loading current user date into form Start
string strFName = null;
string strLName = null;
string strAddress = null;
string strTelephone = null;
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProSelectMyUserAccount(_staticStrCurrentUserName, ref strFName, ref strLName,
ref strAddress, ref strTelephone);
TxtUserName.Text = _staticStrCurrentUserName;
TxtFirstName.Text = strFName;
TxtLastName.Text = strLName;
TxtAddress.Text = strAddress;
TxtTelephone.Text = strTelephone;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// Loading current user date into form End
}
private void ImportData()
{
//Retreive document details from database
try
{
using (var dc = new DBAuditDataContext())
{
if (ComboDocNo.SelectedIndex != -1 && ComboName.SelectedIndex != -1)
{
DateTime?varDatePay = null;
int? intLocationId = null;
string strLocation = null;
string strDestination = null;
string strPeriod = null;
decimal? doubleTrans = null;
decimal? doubleTravel = null;
string strNotes = null;
dc.ProSelectTransFee(ComboDocNo.SelectedValue.ToString(), ref varDatePay, ref intLocationId,
int.Parse(ComboName.SelectedValue.ToString()), ref strDestination, ref strPeriod,
ref doubleTrans, ref doubleTravel, ref strNotes);
if (varDatePay != null)
{
DatePay.Value = varDatePay.Value;
}
dc.ProGetLocationByID(intLocationId, ref strLocation);
ComboLocation.Text = strLocation;
TxtDestination.Text = strDestination;
TxtPeriod.Text = strPeriod;
TxtTrans.Text = doubleTrans.ToString();
TxtTravel.Text = doubleTravel.ToString();
TxtNotes.Text = strNotes;
}
else
{
DatePay.Text = null;
ComboLocation.SelectedIndex = -1;
TxtDestination.Clear();
TxtPeriod.Clear();
TxtTrans.Clear();
TxtTravel.Clear();
TxtNotes.Clear();
}
}
}
catch (InvalidOperationException)
{
DatePay.Value = DateTime.Now;
ComboLocation.Text = "";
TxtDestination.Text = "";
TxtPeriod.Text = "";
TxtTrans.Text = "";
TxtTravel.Text = "";
TxtNotes.Text = "";
BtnDelete.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ImportData()
{
// Loading data into the form
try
{
if (ComboLocation.SelectedIndex < 0)
{
return;
}
using (var dc = new DBAuditDataContext())
{
string strName = null;
int? intSectorId = null;
string strNotes = null;
dc.ProSelectLocation(int.Parse(ComboLocation.SelectedValue.ToString()), ref strName,
ref intSectorId,
ref strNotes);
TxtName.Text = strName;
ComboSectors.SelectedValue = intSectorId;
TxtNotes.Text = strNotes;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ImportData()
{
try
{
// Loading data into the form
using (var dc = new DBAuditDataContext())
{
string strName = null;
int? intAdminPerm = null;
int? intAddPerm = null;
int? intEditPerm = null;
int? intViewPerm = null;
string strNotes = null;
dc.ProSelectUserGroup(ComboName.Text, ref strName, ref intAdminPerm, ref intAddPerm,
ref intEditPerm, ref intViewPerm, ref strNotes);
TxtName.Text = strName;
CheckAdmin.Checked = intAdminPerm == 1;
CheckAdd.Checked = intAddPerm == 1;
CheckEdit.Checked = intEditPerm == 1;
CheckView.Checked = intViewPerm == 1;
TxtNotes.Text = strNotes;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/**
* Apply permissions to users depending on user group
*/
public bool ApplyPermisions(string strPerm)
{
bool isEnabled = false;
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProGetUserPermisions(_strUser, ref _intAdmin, ref _intAdd, ref _intEdit, ref _intView);
}
if (strPerm == "Admin" && _intAdmin == 1)
{
isEnabled = true;
}
else if (strPerm == "Add" && _intAdd == 1)
{
isEnabled = true;
}
else if (strPerm == "Edit" && _intEdit == 1)
{
isEnabled = true;
}
else if (strPerm == "View" && _intView == 1)
{
isEnabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(isEnabled);
}
private void ComboDocNo_TextChanged(object sender, EventArgs e)
{
FormatBtnUpdate();
FormatBtnDelete();
// Loading data into the form:
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
if (ComboDocNo.Text != "")
{
string StrDocNo = null;
DateTime?VarDatePay = null;
int? IntLocationID = null;
int? IntEmployeeID = null;
string StrLocation = null;
string StrEmployee = null;
string StrPerson = null;
decimal? decimalAmount = null;
string StrDesc = null;
string StrNotes = null;
var c = dc.ProSelectCure(ComboDocNo.Text, ref StrDocNo, ref IntEmployeeID, ref IntLocationID, ref StrPerson, ref decimalAmount, ref VarDatePay, ref StrDesc, ref StrNotes);
TxtDocNo.Text = StrDocNo;
if (VarDatePay != null)
{
DatePayDate.Value = VarDatePay.Value;
}
var d = dc.ProGetLocationByID(IntLocationID, ref StrLocation);
ComboLocation.Text = StrLocation;
var x = dc.ProGetEmployeeByID(IntEmployeeID, ref StrEmployee);
ComboName.Text = StrEmployee;
TxtPerson.Text = StrPerson;
TxtAmount.Text = decimalAmount.ToString();
TxtDesc.Text = StrDesc;
TxtNotes.Text = StrNotes;
}
else
{
TxtDocNo.Text = "";
TxtPerson.Text = "";
ComboLocation.Text = "";
TxtAmount.Text = "";
TxtDesc.Text = "";
TxtNotes.Text = "";
}
}
}
catch (NullReferenceException)
{
BtnDelete.Enabled = false;
}
catch (InvalidOperationException)
{
BtnDelete.Enabled = false;
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
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 ComboSetNo_TextChanged(object sender, EventArgs e)
{
FormatBtnUpdate(ComboSetNo, TxtSettlementNo, ComboLocation, TxtTotalAmount, TxtReason);
FormatBtnDelete(ComboSetNo);
//
// Loading data into form
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
if (ComboSetNo.Text != "")
{
string StrSetNo = null;
int? IntLocID = null;
string StrLocation = null;
DateTime?VarSetDate = null;
decimal? DecimalAmount = null;
string StrDetails = null;
string StrNotes = null;
var c = dc.ProSelectSettlement(ComboSetNo.Text, ref StrSetNo, ref IntLocID, ref VarSetDate, ref DecimalAmount, ref StrDetails, ref StrNotes);
TxtSettlementNo.Text = StrSetNo;
var d = dc.ProGetLocationByID(IntLocID, ref StrLocation);
ComboLocation.Text = StrLocation;
if (VarSetDate != null)
{
DateSettlement.Value = VarSetDate.Value;
}
else
{
DateSettlement.Value = DateTime.Now;
}
TxtTotalAmount.Text = DecimalAmount.ToString();
TxtReason.Text = StrDetails;
TxtNotes.Text = StrNotes;
}
else
{
TxtSettlementNo.Text = null;
ComboLocation.Text = null;
DateSettlement.Value = DateTime.Now;
TxtTotalAmount.Text = null;
TxtReason.Text = null;
TxtNotes.Text = null;
}
}
}
catch (NullReferenceException)
{
}
catch (InvalidOperationException)
{
DateSettlement.Value = DateTime.Now;
BtnDelete.Enabled = false;
}
catch (Exception EX)
{
MessageBox.Show(EX.Message.ToString());
}
}
private void FrmViewContractors_Load(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProViewContractors();
GrdViewContractors.DataSource = c;
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void FrmViewLocations_Load(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProViewLocations();
//GrdViewLocations.DataSource = c;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddTelNo(TxtTelNo.Text, int.Parse(ComboLocation.SelectedValue.ToString()), TxtNotes.Text);
}
MessageBox.Show(@"تمت إضافة بيانات المستند بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
using (var dc = new DBAuditDataContext())
{
dc.ProAuditorGeneralSettings(DatePeriodStart.Value, DatePeriodEnd.Value);
MessageBox.Show(Resources.MsgAppSettingsSaved, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/**
* Add logout record to log
*/
public static void LogoutLog()
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAuditLogout(_staticIntUserId, _staticStrLoginTime,
DateTime.Now.ToString(CultureInfo.CurrentCulture));
}
_staticStrUserName = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var C = dc.ProAddPrePay(int.Parse(ComboLocation.SelectedValue.ToString()), int.Parse(ComboVendor.SelectedValue.ToString()), int.Parse(ComboBridge.SelectedValue.ToString()), TxtDocNo.Text, DatePayDate.Value, double.Parse(TxtAmount.Text), double.Parse(TxtTaxRate.Text), double.Parse(TxtTaxAmount.Text), double.Parse(TxtFees.Text), double.Parse(TxtTotalDiscount.Text), double.Parse(TxtNetAmount.Text), TxtJust.Text, TxtReason.Text, TxtNotes.Text);
}
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProUpdateSettlement(ComboSetNo.Text, TxtSettlementNo.Text, int.Parse(ComboLocation.SelectedValue.ToString()), DateSettlement.Value, decimal.Parse(TxtTotalAmount.Text), TxtReason.Text, TxtNotes.Text);
}
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddTempLoan(TxtDocNo.Text, DatePayDate.Value, int.Parse(ComboLocation.SelectedValue.ToString()), int.Parse(ComboEmployee.SelectedValue.ToString()), decimal.Parse(TxtTotalAmount.Text), int.Parse(TxtPeriod.Text), TxtReason.Text, TxtNotes.Text);
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
new FrmNewTemporaryLoan().Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddDoctorBill(TxtDocNo.Text, DatePayDate.Value, int.Parse(ComboLocation.SelectedValue.ToString()), int.Parse(ComboDoctor.SelectedValue.ToString()), decimal.Parse(TxtAmount.Text), decimal.Parse(TxtPercent.Text), decimal.Parse(TxtTaxs.Text), decimal.Parse(TxtDiscounts.Text), decimal.Parse(TxtTotalDiscount.Text), decimal.Parse(TxtNetAmount.Text), TxtDesc.Text, TxtNotes.Text);
MessageBox.Show(Resources.MsgDocumentAdded, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
new FrmNewDoctorBill().Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSearchDocNo_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProGetCureByDocNo(TxtDocNo.Text);
GrdViewCure.DataSource = c;
ComboName.Text = "";
ComboLocation.Text = "";
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnSearchEmployee_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProGetCureByEmployeeID(int.Parse(ComboName.SelectedValue.ToString()));
GrdViewCure.DataSource = c;
TxtDocNo.Text = "";
ComboLocation.Text = "";
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddContractor(TxtName.Text, TxtNotes.Text);
}
MessageBox.Show(Resources.MsgContractorAdded, Resources.AppName, MessageBoxButtons.OK,
MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddEmployee(TxtName.Text, int.Parse(ComboLocation.SelectedValue.ToString()), ComboDegree.Text, ComboPosition.Text, TxtAddress.Text, TxtTelephone.Text, TxtNotes.Text);
}
MessageBox.Show(Resources.MsgEmployeeAdded, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
new FrmNewEmployee().Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
dc.ProAddUserGroup(TxtName.Text, _intAdmin, _intAdd, _intEdit, _intView, TxtNotes.Text);
}
MessageBox.Show(Resources.MsgUserGroupAdded, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
new FrmNewUserGroup().Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProUpdateTempLoan(ComboDocNo.Text, DatePayDate.Value, int.Parse(ComboLocation.SelectedValue.ToString()), int.Parse(ComboEmployee.SelectedValue.ToString()), decimal.Parse(TxtTotalAmount.Text), int.Parse(TxtPeriod.Text), TxtReason.Text, ComboStatus.Text, DateSettlement.Value, TxtChequeNo.Text, DateChequeDate.Value, DateChequeExpense.Value, DateEndDate.Value, decimal.Parse(TxtSettlementAmount.Text), int.Parse(TxtSettlementPeriod.Text), decimal.Parse(TxtTax.Text), decimal.Parse(TxtPenalty.Text), decimal.Parse(TxtFees.Text), decimal.Parse(TxtRevenues.Text), decimal.Parse(TxtNetAmount.Text), decimal.Parse(TxtTotalDiscount.Text), decimal.Parse(TxtAmountToPay.Text), decimal.Parse(TxtPaidAmount.Text), TxtBill.Text, TxtSettlementNo.Text, TxtNotes.Text);
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
FrmModifyTemporaryLoan Frm = new FrmModifyTemporaryLoan();
Frm.Show();
}
}
catch (Exception EX)
{
MessageBox.Show(EX.Message.ToString());
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProAddDoctor(TxtDoctor.Text, ComboType.Text, TxtNotes.Text);
}
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
FrmNewDoctor Frm = new FrmNewDoctor();
Frm.Show();
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
using (DBAuditDataContext dc = new DBAuditDataContext())
{
var c = dc.ProUpdateTelNo(int.Parse(ComboTelNo.SelectedValue.ToString()), TxtTelNo.Text, int.Parse(ComboLocation.SelectedValue.ToString()), TxtNotes.Text);
}
MessageBox.Show(@"تمت إضافة بيانات السلفة المؤقتة بنجاح", @"المراجع الذكي", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
FrmModifyTelNo Frm = new FrmModifyTelNo();
Frm.ShowDialog();
}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
}
