private string getOrderNumber()
{
try
{
string LastOrderNumber;
string NewOrderNumber;
technovisionDataSetTableAdapters.spectaclesTableAdapter table = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
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)
{
CommonFunctions.WriteToErrorLog(ex.Message);
return(null);
}
}
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 BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtRightDistSph.Text == "" || TxtRightDistCyl.Text == "" || TxtRightDistAxis.Text == "" || TxtLeftDistSph.Text == "" || TxtLeftDistCyl.Text == "" || TxtLeftDistAxis.Text == "" || TxtRightAdd.Text == "" || TxtLeftAdd.Text == "" || TxtLenseType.Text == "" || CmbFrame.Text == "" || TxtPD.Text == "" || TxtSegmentHeight.Text == "" || TxtSpecialIns.Text == "" || TxtRemarks.Text == "")
{
CommonFunctions.ShowError(this, "Please Complete All Fields to continue...If You have Empty Fileds Please put'-' into Text Area...");
CommonFunctions.WriteUserLog(Session.Username, "tried to continue without enter all fields");
}
else
{
if (SpecOrder.Advance == 0 || SpecOrder.PaymentMethod == "N-C")
{
SpecOrderController.FillFormTwo(TxtRightDistSph.Text, TxtRightDistCyl.Text, TxtRightDistAxis.Text, TxtLeftDistSph.Text, TxtLeftDistCyl.Text, TxtLeftDistAxis.Text, TxtRightAdd.Text, TxtLeftAdd.Text, TxtLenseType.Text, CmbFrame.Text, TxtPD.Text, TxtSegmentHeight.Text, TxtSpecialIns.Text, TxtRemarks.Text);
receiptController.FillReceipt(SpecOrder.OrderNumber, SpecOrder.Advance, SpecOrder.OrderDate, "SPEC", SpecOrder.custID);
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
t.Insert(SpecOrder.OrderNumber, DateTime.Parse(SpecOrder.OrderDate), DateTime.Parse(SpecOrder.DueDate), SpecOrder.OrderStatus, SpecOrder.Total, SpecOrder.Advance, SpecOrder.Discount, SpecOrder.Balance, SpecOrder.TestBy, SpecOrder.Eyewear, SpecOrder.Lense, SpecOrder.PaymentPlan, SpecOrder.PaymentMethod, SpecOrder.DistRightSph, SpecOrder.DistRightCyl, SpecOrder.DistRightAxis, SpecOrder.DistLeftSph, SpecOrder.DistLeftCyl, SpecOrder.DistLeftAxis, SpecOrder.AddRight, SpecOrder.AddLeft, SpecOrder.LenseType, SpecOrder.Frame, SpecOrder.PD, SpecOrder.SegmentHeight, SpecOrder.SpecialInstruction, SpecOrder.Remarks, SpecOrder.ReminderDays, SpecOrder.Branch, DateTime.Now.ToString("yyyy"), SpecOrder.custID);
CommonFunctions.WriteUserLog(Session.Username, "Added New Spec Order : " + SpecOrder.OrderNumber);
//receiptController.WriteReceipt(this);
CommonFunctions.ShowSuccess(this, "Order Number " + SpecOrder.OrderNumber + " Saved Succesfully...");
this.Dispose();
form.Dispose();
if (SpecOrder.PaymentMethod == "N-C" && SpecOrder.Advance == 0)
{
new UI_ORDER_COMPLETE("S", SpecOrder.OrderNumber, "N-C").Show();
}
else if (SpecOrder.PaymentMethod != "N-C" && SpecOrder.Advance == 0)
{
new UI_ORDER_COMPLETE("S", SpecOrder.OrderNumber, "Not Paid").Show();
}
}
else
{
SpecOrderController.FillFormTwo(TxtRightDistSph.Text, TxtRightDistCyl.Text, TxtRightDistAxis.Text, TxtLeftDistSph.Text, TxtLeftDistCyl.Text, TxtLeftDistAxis.Text, TxtRightAdd.Text, TxtLeftAdd.Text, TxtLenseType.Text, CmbFrame.Text, TxtPD.Text, TxtSegmentHeight.Text, TxtSpecialIns.Text, TxtRemarks.Text);
receiptController.FillReceipt(SpecOrder.OrderNumber, SpecOrder.Advance, SpecOrder.OrderDate, "SPEC", SpecOrder.custID);
technovisionDataSetTableAdapters.spectaclesTableAdapter t = new technovisionDataSetTableAdapters.spectaclesTableAdapter();
t.Insert(SpecOrder.OrderNumber, DateTime.Parse(SpecOrder.OrderDate), DateTime.Parse(SpecOrder.DueDate), SpecOrder.OrderStatus, SpecOrder.Total, SpecOrder.Advance, SpecOrder.Discount, SpecOrder.Balance, SpecOrder.TestBy, SpecOrder.Eyewear, SpecOrder.Lense, SpecOrder.PaymentPlan, SpecOrder.PaymentMethod, SpecOrder.DistRightSph, SpecOrder.DistRightCyl, SpecOrder.DistRightAxis, SpecOrder.DistLeftSph, SpecOrder.DistLeftCyl, SpecOrder.DistLeftAxis, SpecOrder.AddRight, SpecOrder.AddLeft, SpecOrder.LenseType, SpecOrder.Frame, SpecOrder.PD, SpecOrder.SegmentHeight, SpecOrder.SpecialInstruction, SpecOrder.Remarks, SpecOrder.ReminderDays, SpecOrder.Branch, DateTime.Now.ToString("yyyy"), SpecOrder.custID);
CommonFunctions.WriteUserLog(Session.Username, "Added New Spec Order : " + SpecOrder.OrderNumber);
receiptController.WriteReceipt(this);
CommonFunctions.ShowSuccess(this, "Order Number " + SpecOrder.OrderNumber + " Saved Succesfully...");
this.Dispose();
new UI_ORDER_COMPLETE("S", SpecOrder.OrderNumber, Receipt.ReceiptNumber).Show();
form.Dispose();
}
}
}
catch (Exception ex)
{
CommonFunctions.WriteToErrorLog(ex.Message);
CommonFunctions.ShowError(this, ex.Message);
}
}
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 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 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());
}
}
