private void BtnMarkAs_Click(object sender, EventArgs e)
{
try
{
if (RadioSpectacles.Checked == true)
{
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
t.UpdateOrderStatus(CmbSetAs.Text, SpecGrid.SelectedRows[0].Cells[0].Value.ToString());
this.spectaclesTableAdapter.Fill(this.technovisionDataSet.spectacles);
CommonFunctions.ShowSuccess(this, "Order status Updated to " + CmbSetAs.SelectedText + "Successfully");
CommonFunctions.WriteUserLog(Session.Username, "Has Updated Order Status to" + CmbSetAs.Text);
}
else if (RadioContactLense.Checked == true)
{
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
t.UpdateOrderStatus(CmbSetAs.Text, LenseGrid.SelectedRows[0].Cells[0].Value.ToString());
this.contactlenseTableAdapter.Fill(this.technovisionDataSet.contactlense);
CommonFunctions.ShowSuccess(this, "Order Updated to " + CmbSetAs.SelectedText + "Successfully");
CommonFunctions.WriteUserLog(Session.Username, "Has Updated Order Status to" + CmbSetAs.Text);
}
}
catch (Exception ex)
{
CommonFunctions.ShowError(this, ex.Message.ToString());
CommonFunctions.WriteToErrorLog(ex.Message.ToString());
}
}
private void BtnAddPayment_Click(object sender, EventArgs e)
{
try
{
Receipt.branch = Session.BranchId;
Receipt.custId = custID;
Receipt.orderNumber = LblOrderNo.Text;
Receipt.OrderType = orderType;
Receipt.paymentAmount = Double.Parse(TxtAmount.Text);
Receipt.receiptDate = DateTime.Now.ToString("yyyy-MM-dd");
Receipt.ReceiptNumber = LblReceiptNo.Text;
receiptController.WriteReceipt(this);
if (orderType == "LENSE")
{
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
t.UpdateBalanceByOrderNumber(double.Parse(LblDueAmount.Text) - double.Parse(TxtAmount.Text), orderNumber);
t.UpdateAdvanceByOrderNumber(Receipt.paymentAmount, orderNumber);
t.Dispose();
CommonFunctions.ShowSuccess(this, "New Advance Payment Added To " + LblOrderNo.Text);
InvoiceLenseCustomer rpt = new InvoiceLenseCustomer();
rpt.RecordSelectionFormula = "{contactlense1.OrderNumber} = '" + Receipt.orderNumber + "' AND {receipt1.ReceiptNumber} = '" + Receipt.ReceiptNumber + "' AND {contactlense1.Branch} =" + Session.BranchId;
rpt.PrintToPrinter(1, false, 1, 1);
new UI_REPORT_VIEWER(rpt).Show();
InvoiceLenseCompany rpt1 = new InvoiceLenseCompany();
rpt1.RecordSelectionFormula = "{contactlense1.OrderNumber} = '" + orderNumber + "'AND {receipt1.ReceiptNumber} = '" + LblReceiptNo.Text + "' AND {contactlense1.Branch} =" + Session.BranchId;
rpt1.PrintToPrinter(1, false, 1, 1);
new UI_REPORT_VIEWER(rpt1).Show();
}
if (orderType == "SPEC")
{
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
t.UpdateBalanceByOrderNumber(double.Parse(LblDueAmount.Text) - double.Parse(TxtAmount.Text), orderNumber);
t.UpdateAdvanceByOrderNumber(Receipt.paymentAmount, orderNumber);
t.Dispose();
CommonFunctions.ShowSuccess(this, "New Advance Payment Added To " + LblOrderNo.Text);
InvoiceSpecCustomer rpt = new InvoiceSpecCustomer();
rpt.RecordSelectionFormula = "{spectacles1.OrderNumber} ='" + Receipt.orderNumber + "' AND {receipt1.ReceiptNumber} = '" + Receipt.ReceiptNumber + "' AND {spectacles1.Branch} =" + Session.BranchId;
rpt.PrintToPrinter(1, false, 1, 1);
new UI_REPORT_VIEWER(rpt).Show();
InvoiceSpecCompany rpt1 = new InvoiceSpecCompany();
rpt1.RecordSelectionFormula = "{spectacles1.OrderNumber} ='" + orderNumber + "' AND {receipt1.ReceiptNumber} = '" + Receipt.ReceiptNumber + "' AND {spectacles1.Branch} =" + Session.BranchId;
rpt1.PrintToPrinter(1, false, 1, 1);
new UI_REPORT_VIEWER(rpt1).Show();
}
}
catch (Exception ex)
{
CommonFunctions.ShowError(this, ex.ToString());
}
}
private void cmbYear_TextChanged(object sender, EventArgs e)
{
technovisionDataSetTableAdapters.spectaclesTableAdapter ta = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
technovisionDataSet.spectaclesDataTable dt = new technovisionDataSet.spectaclesDataTable();
ta.FillByYearSpectacles(dt, cmbYear.Text);
this.SpecGrid.DataSource = dt;
//load contact lenses
technovisionDataSetTableAdapters.contactlenseTableAdapter co = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
technovisionDataSet.contactlenseDataTable tb = new technovisionDataSet.contactlenseDataTable();
co.FillByYearContactlenses(tb, cmbYear.Text);
this.LenseGrid.DataSource = tb;
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtBlindTest.Text == "" || TxtKReading.Text == "" || TxtLeftBc.Text == "" || TxtLeftDeze.Text == "" || TxtLeftDia.Text == "" || TxtLeftOldAdd.Text == "" || TxtLeftOldAxis.Text == "" || TxtLeftOldCyl.Text == "" || TxtLeftOldSph.Text == "" || TxtLeftPow.Text == "" || TxtLeftPresentAdd.Text == "" || TxtLeftPresentAxis.Text == "" || TxtLeftPresentCyl.Text == "" || TxtLeftPresentSph.Text == "" || TxtOverRefract.Text == "" || TxtRemarks.Text == "" || TxtRightBc.Text == "" || TxtRightDeze.Text == "" || TxtRightDia.Text == "" || TxtRightOldAdd.Text == "" || TxtRightOldAxis.Text == "" || TxtRightOldCyl.Text == "" || TxtRightOldSph.Text == "" || TxtRightPow.Text == "" || TxtRightPresentAdd.Text == "" || TxtRightPresentAxis.Text == "" || TxtRightPresentCyl.Text == "" || TxtRightPresentSph.Text == "" || TxtSpecialIns.Text == "" || TxtTrailLense.Text == "")
{
CommonFunctions.ShowError(this, "Please Complete All Fields to continue...If You have Empty Fileds Please put'-' into Text Area...");
}
else
{
if (LenseOrder.Advance == 0 || LenseOrder.PaymentMethod == "N-C")
{
LenseOrderController.FillFormTwo(TxtRightOldSph.Text, TxtRightOldCyl.Text, TxtRightOldAxis.Text, TxtRightOldAdd.Text, TxtLeftOldSph.Text, TxtLeftOldCyl.Text, TxtLeftOldAxis.Text, TxtLeftOldAdd.Text, TxtRightPresentSph.Text, TxtRightPresentCyl.Text, TxtRightPresentAxis.Text, TxtRightPresentAdd.Text, TxtRightPresentAdd.Text, TxtLeftPresentCyl.Text, TxtLeftPresentAxis.Text, TxtLeftPresentAdd.Text, TxtRightBc.Text, TxtRightPow.Text, TxtRightDia.Text, TxtRightDeze.Text, TxtLeftBc.Text, TxtLeftPow.Text, TxtLeftDia.Text, TxtLeftDeze.Text, TxtTrailLense.Text, TxtOverRefract.Text, TxtKReading.Text, TxtBlindTest.Text, TxtSpecialIns.Text, TxtRemarks.Text);
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
t.Insert(LenseOrder.OrderNumber, DateTime.Parse(LenseOrder.OrderDate), DateTime.Parse(LenseOrder.DueDate), LenseOrder.JobType, LenseOrder.TestedBy, LenseOrder.Total, LenseOrder.Discount, LenseOrder.Advance, LenseOrder.Balance, LenseOrder.PaymentMethod, LenseOrder.PaymentPlan, LenseOrder.OrderStatus, LenseOrder.OldRightSph, LenseOrder.OldRightCyl, LenseOrder.OldRightAxis, LenseOrder.OldRightAdd, LenseOrder.OldLeftSph, LenseOrder.OldLeftCyl, LenseOrder.OldLeftAxis, LenseOrder.OldLeftAdd, LenseOrder.PresentRightSph, LenseOrder.PresentRightCyl, LenseOrder.PresentRightAxis, LenseOrder.PresentRightAdd, LenseOrder.PresentLeftSph, LenseOrder.PresentLeftCyl, LenseOrder.PresentLeftAxis, LenseOrder.PresentLeftAdd, LenseOrder.RightBc, LenseOrder.RightPow, LenseOrder.RightDia, LenseOrder.RightDesz, LenseOrder.LeftBc, LenseOrder.LeftPow, LenseOrder.LeftDia, LenseOrder.LeftDesz, LenseOrder.TrailLense, LenseOrder.OverRefract, LenseOrder.KReading, LenseOrder.BlinkTest, LenseOrder.SpecialInstruction, LenseOrder.Remarks, LenseOrder.ReminderDays, LenseOrder.Branch, DateTime.Now.ToString("yyyy"), LenseOrder.custID);
//receiptController.WriteReceipt(this);
CommonFunctions.WriteUserLog(Session.Username, "Added New Lense Order : " + LenseOrder.OrderNumber);
CommonFunctions.ShowSuccess(this, "Order Number " + LenseOrder.OrderNumber + " Saved Succesfully...");
this.Dispose();
f.Dispose();
if (LenseOrder.PaymentMethod == "N-C" && LenseOrder.Advance == 0)
{
new UI_ORDER_COMPLETE("L", LenseOrder.OrderNumber, "N-C").Show();
}
else if (LenseOrder.PaymentMethod != "N-C" && LenseOrder.Advance == 0)
{
new UI_ORDER_COMPLETE("L", LenseOrder.OrderNumber, "Not Paid").Show();
}
}
else
{
LenseOrderController.FillFormTwo(TxtRightOldSph.Text, TxtRightOldCyl.Text, TxtRightOldAxis.Text, TxtRightOldAdd.Text, TxtLeftOldSph.Text, TxtLeftOldCyl.Text, TxtLeftOldAxis.Text, TxtLeftOldAdd.Text, TxtRightPresentSph.Text, TxtRightPresentCyl.Text, TxtRightPresentAxis.Text, TxtRightPresentAdd.Text, TxtRightPresentAdd.Text, TxtLeftPresentCyl.Text, TxtLeftPresentAxis.Text, TxtLeftPresentAdd.Text, TxtRightBc.Text, TxtRightPow.Text, TxtRightDia.Text, TxtRightDeze.Text, TxtLeftBc.Text, TxtLeftPow.Text, TxtLeftDia.Text, TxtLeftDeze.Text, TxtTrailLense.Text, TxtOverRefract.Text, TxtKReading.Text, TxtBlindTest.Text, TxtSpecialIns.Text, TxtRemarks.Text);
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
t.Insert(LenseOrder.OrderNumber, DateTime.Parse(LenseOrder.OrderDate), DateTime.Parse(LenseOrder.DueDate), LenseOrder.JobType, LenseOrder.TestedBy, LenseOrder.Total, LenseOrder.Discount, LenseOrder.Advance, LenseOrder.Balance, LenseOrder.PaymentMethod, LenseOrder.PaymentPlan, LenseOrder.OrderStatus, LenseOrder.OldRightSph, LenseOrder.OldRightCyl, LenseOrder.OldRightAxis, LenseOrder.OldRightAdd, LenseOrder.OldLeftSph, LenseOrder.OldLeftCyl, LenseOrder.OldLeftAxis, LenseOrder.OldLeftAdd, LenseOrder.PresentRightSph, LenseOrder.PresentRightCyl, LenseOrder.PresentRightAxis, LenseOrder.PresentRightAdd, LenseOrder.PresentLeftSph, LenseOrder.PresentLeftCyl, LenseOrder.PresentLeftAxis, LenseOrder.PresentLeftAdd, LenseOrder.RightBc, LenseOrder.RightPow, LenseOrder.RightDia, LenseOrder.RightDesz, LenseOrder.LeftBc, LenseOrder.LeftPow, LenseOrder.LeftDia, LenseOrder.LeftDesz, LenseOrder.TrailLense, LenseOrder.OverRefract, LenseOrder.KReading, LenseOrder.BlinkTest, LenseOrder.SpecialInstruction, LenseOrder.Remarks, LenseOrder.ReminderDays, LenseOrder.Branch, DateTime.Now.ToString("yyyy"), LenseOrder.custID);
receiptController.WriteReceipt(this);
CommonFunctions.WriteUserLog(Session.Username, "Added New Lense Order : " + LenseOrder.OrderNumber);
CommonFunctions.ShowSuccess(this, "Order Number " + LenseOrder.OrderNumber + " Saved Succesfully...");
this.Dispose();
f.Dispose();
new UI_ORDER_COMPLETE("L", LenseOrder.OrderNumber, Receipt.ReceiptNumber).Show();
}
}
}
catch (Exception ex)
{
CommonFunctions.WriteToErrorLog(ex.Message);
CommonFunctions.ShowError(this, ex.Message);
}
}
private void UI_ADD_ADVANCE_Load(object sender, EventArgs e)
{
DateOrderDate.MinDate = DateTime.UtcNow.AddDays(-30);
LblOrderNo.Text = orderNumber;
showReceiptNumber();
if (orderType == "LENSE")
{
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
LblDueAmount.Text = t.FindBalanceByOrderNumber(orderNumber).ToString();
t.Dispose();
}
if (orderType == "SPEC")
{
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
LblDueAmount.Text = t.FindBalanceByOrderNumber(orderNumber).ToString();
t.Dispose();
}
}
private void BtnAddPayment_Click(object sender, EventArgs e)
{
try
{
receiptController.FillReceipt(orderNumber, double.Parse(TxtAmount.Text), DateOrderDate.Value.ToString("yyyy-MM-dd"), orderType, custID);
receiptController.WriteReceipt(this);
if (orderType == "LENSE")
{
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
t.UpdateBalanceByOrderNumber(double.Parse(LblDueAmount.Text) - double.Parse(TxtAmount.Text), orderNumber);
t.Dispose();
CommonFunctions.ShowSuccess(this, "New Payment Added To " + LblOrderNo.Text);
CommonFunctions.WriteUserLog(Session.Username, "New Payment Added To " + LblOrderNo.Text);
this.receiptTableAdapter.Fill(this.technovisionDataSet.receipt);
receiptBindingSource.Filter = "OrderNumber ='" + orderNumber + "' AND OrderType = '" + orderType + "' AND Branch = " + Session.BranchId;
InvReceiptContactLense rpt = new InvReceiptContactLense();
rpt.RecordSelectionFormula = "{receipt1.ReceiptNumber} ='" + LblReceiptNo.Text + "'";
rpt.PrintToPrinter(2, false, 1, 1);
new UI_REPORT_VIEWER(rpt).Show();
}
if (orderType == "SPEC")
{
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
t.UpdateBalanceByOrderNumber(double.Parse(LblDueAmount.Text) - double.Parse(TxtAmount.Text), orderNumber);
t.Dispose();
CommonFunctions.ShowSuccess(this, "New Payment Added To " + LblOrderNo.Text);
CommonFunctions.WriteUserLog(Session.Username, "New Payment Added To " + LblOrderNo.Text);
this.receiptTableAdapter.Fill(this.technovisionDataSet.receipt);
receiptBindingSource.Filter = "OrderNumber ='" + orderNumber + "' AND OrderType = '" + orderType + "' AND Branch = " + Session.BranchId;
InvReceipt rpt = new InvReceipt();
rpt.RecordSelectionFormula = "{receipt1.ReceiptNumber} ='" + LblReceiptNo.Text + "'";
rpt.PrintToPrinter(2, false, 1, 1);
new UI_REPORT_VIEWER(rpt).Show();
}
}
catch (Exception ex)
{
CommonFunctions.ShowError(this, ex.Message.ToString());
CommonFunctions.WriteToErrorLog(ex.Message.ToString());
}
}
private void UI_ADD_NEW_PAYMENT_Load(object sender, EventArgs e)
{
DateOrderDate.MinDate = DateTime.UtcNow.AddDays(-30);
// TODO: This line of code loads data into the 'technovisionDataSet.receipt' table. You can move, or remove it, as needed.
this.receiptTableAdapter.Fill(this.technovisionDataSet.receipt);
receiptBindingSource.Filter = "OrderNumber ='" + orderNumber + "' AND OrderType = '" + orderType + "' AND Branch = " + Session.BranchId;
LblOrderNo.Text = orderNumber;
showReceiptNumber();
if (orderType == "LENSE")
{
technovisionDataSetTableAdapters.contactlenseTableAdapter t = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
LblDueAmount.Text = t.FindBalanceByOrderNumber(orderNumber).ToString();
t.Dispose();
}
if (orderType == "SPEC")
{
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
LblDueAmount.Text = t.FindBalanceByOrderNumber(orderNumber).ToString();
t.Dispose();
}
}
private string getOrderNumber()
{
try
{
string LastOrderNumber;
string NewOrderNumber;
technovisionDataSetTableAdapters.contactlenseTableAdapter table = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
try
{
LastOrderNumber = table.GetLastOrderNumber(Session.BranchId, DateTime.Now.ToString("yyyy")).ToString();
NewOrderNumber = (int.Parse(LastOrderNumber) + 1).ToString();
}
catch (NullReferenceException ex)
{
NewOrderNumber = DateTime.Now.ToString("yy") + "0001";
}
return(NewOrderNumber);
}
catch (Exception ex)
{
return(null);
}
}
private void loadData()
{
try
{
technovisionDataSetTableAdapters.spectaclesTableAdapter ta = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
technovisionDataSetTableAdapters.spec_ordersTableAdapter taa = new technovisionDataSetTableAdapters.spec_ordersTableAdapter();
//technovisionDataSet.spectaclesDataTable dt = new technovisionDataSet.spectaclesDataTable();
//ta.FillByYearSpectacles(dt, cmbYear.Text);
this.SpecGrid.DataSource = taa.GetDataByYear(cmbYear.Text);
//this.SpecGrid.DataSource = ta.GetDataByYear(cmbYear.Text);
//load contact lenses
technovisionDataSetTableAdapters.contactlenseTableAdapter co = new technovisionDataSetTableAdapters.contactlenseTableAdapter();
technovisionDataSet.contactlenseDataTable tb = new technovisionDataSet.contactlenseDataTable();
co.FillByYearContactlenses(tb, cmbYear.Text);
this.LenseGrid.DataSource = tb;
}
catch (Exception ex)
{
CommonFunctions.ShowError(this, ex.Message.ToString());
}
}
