public void update()
{
FacadeController f = FacadeController.getFController();
DataSet s = f.getHighestDispatch();
if (s.Tables["myTable"].Rows[0][0].ToString() != "")
{
string disp = s.Tables["myTable"].Rows[0][0].ToString();
dispatchno = int.Parse(disp) + 1;
}
else
{
dispatchno = 1;
}
middlePanel.Dock = DockStyle.Fill;
productsfunctionsPanel.Visible = false;
dispatchNoTB.Text = dispatchno.ToString();
newDispatchPanel.Visible = false;
loadProductsGrid();
addDispatchPanel.Visible = false;
s = f.getNoOfDispatch();
totalDispatchesLB.Text = s.Tables["myTable"].Rows.Count.ToString();
totalProductsLB.Text = productsGrid.Rows.Count.ToString();
}
public void UploadLocal()
{
FacadeController facadeController = new FacadeController(
new LocalOLEDBPersistenceStrategiesFactory(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\users\ctorres\OneDrive - Quest Window Systems Inc\Desktop\ScanToPrint.mdb;Persist Security Info=False;"),
new OnlineOLEDBPersistenceStrategiesFactory(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:\Quest_CT.mdb;Persist Security Info=False;")
);
//List<RegisteredTag> tags = facadeController.GetRegisteredTags().Where(x => x.Job == "AAA").ToList();
//foreach(RegisteredTag tag in tags)
//{
// facadeController.AddBarcode(new Barcodes()
// {
// Barcode = string.Format("{0}{1}{2}", tag.Job, tag.Floor, tag.Tag),
// Tag = tag.Tag,
// Job = tag.Job,
// Line = 2,
// ScanDate = DateTime.Now,
// SentDatabase = false
// });
//}
facadeController.UploadBarcodes();
}
private void YourBill_Load(object sender, EventArgs e)
{
FacadeController fc = new FacadeController();
//UserBillController ubc = new UserBillController();
richTextBox1.Text = fc.Bill();
}
private void Transfuse_Click(object sender, EventArgs e)
{
if (!textBox2.Text.Contains("ml") && !textBox3.Text.Contains("dl"))
{
MessageBox.Show("You need no enter amount of blood in ml and hemoglobin in dl");
}
else
{
FacadeController fc = new FacadeController();
//UserTransfuseController utc = new UserTransfuseController();
fc.UpdatingTransfusion(User.UserID, comboBox1.Text, textBox2.Text, textBox3.Text, DateTime.Parse(dateTimePicker1.Text), int.Parse(textBox4.Text), textBox5.Text, DateTime.Parse(dateTimePicker2.Text));
textBox1.Clear();
comboBox1.Text = "";
textBox2.Clear();
textBox3.Clear();
dateTimePicker1.ResetText();
textBox4.Clear();
textBox5.Clear();
dateTimePicker2.ResetText();
if (fc.TransfusionData().tt == null)
{
MessageBox.Show("Data Inserted Successfully");
}
else
{
MessageBox.Show("Data Updated Successfully");
}
}
}
private void UpdateUser_Load(object sender, EventArgs e)
{
FacadeController fc = new FacadeController();
UserUpdate u = new UserUpdate();
//UserUpdateController uup = new UserUpdateController();
textBox1.Text = User.UserID.ToString();
if (fc.UserInformation().CellNo != null)
{
u = fc.UserInformation();
comboBox1.Text = u.Type;
textBox2.Text = u.FirstName;
textBox3.Text = u.LastName;
textBox4.Text = u.FatherName;
comboBox2.Text = u.BG;
textBox5.Text = u.NIC;
dateTimePicker1.Text = u.DOB.ToString();
textBox6.Text = u.PEmail;
textBox7.Text = u.TEmail;
textBox8.Text = u.Paddress;
textBox9.Text = u.TAddress;
textBox10.Text = u.Country;
textBox11.Text = u.City;
textBox12.Text = u.PostalCode.ToString();
textBox13.Text = u.CellNo;
textBox14.Text = u.Pass;
}
}
private void submitBTN_Click(object sender, EventArgs e)
{
if (nameTB.Text != "" && mileageTB.Text != "" && contactTB.Text != "" && cnicTB.Text != "" && vehicleNoTB.Text != "")
{
FacadeController f = FacadeController.getFController();
if (rightPanelHeader.Text.Contains("Edit"))
{
string id = vanGrid.SelectedRows[0].Cells["id"].Value.ToString();
int response = f.updateVan(id, nameTB.Text, vehicleNoTB.Text, contactTB.Text, mileageTB.Text, cnicTB.Text);
if (response == 1)
{
MessageBox.Show("Record Updated Successfully");
getAllVans();
newVanForm.Visible = false;
rightPanelHeader.Text = "Cick a record";
}
}
else
{
f.createVanData(vehicleNoTB.Text, nameTB.Text, cnicTB.Text, contactTB.Text, mileageTB.Text);
getAllVans();
newVanForm.Visible = false;
rightPanelHeader.Text = "Cick a record";
}
}
else
{
MessageBox.Show("Please fill the form correctly");
}
}
void getProductsSummary()
{
FacadeController f = FacadeController.getFController();
DataTable dt = f.getProductsSummary().Tables["myTable"];
categories = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
highestProduct = int.Parse(dt.Rows[0]["qtycart"].ToString());
lowestProduct = int.Parse(dt.Rows[0]["qtycart"].ToString());
foreach (DataRow r in dt.Rows)
{
if (int.Parse(r["qtycart"].ToString()) > highestProduct)
{
highestProduct = int.Parse(r["qtycart"].ToString());
highestProductName = r["Name"].ToString();
}
productsWorth += int.Parse(r["rate"].ToString()) * int.Parse(r["qtycart"].ToString());
totalstock += int.Parse(r["qtycart"].ToString());
if (int.Parse(r["qtycart"].ToString()) < lowestProduct)
{
lowestProduct = int.Parse(r["qtycart"].ToString());
lowestProductName = r["Name"].ToString();
}
}
}
setInventoryDetails();
}
void getSalesSummary()
{
FacadeController f = FacadeController.getFController();
int totalPc = 0;
int totalCartons = 0;
int returnedCartons = 0;
int returnedpcs = 0;
int replacedCartons = 0;
int replacedpcs = 0;
foreach (string bill in Salesman.bills)
{
DataTable dt = f.getSalesTotal(bill).Tables["myTable"];
totalPc += int.Parse(dt.Rows[0]["totalPieces"].ToString());
totalCartons += int.Parse(dt.Rows[0]["totalCartons"].ToString());
returnedCartons += int.Parse(dt.Rows[0]["returnedCart"].ToString());
returnedpcs += int.Parse(dt.Rows[0]["returnedpc"].ToString());
replacedCartons += int.Parse(dt.Rows[0]["replacedCart"].ToString());
replacedpcs += int.Parse(dt.Rows[0]["replacedpc"].ToString());
}
int soldCartons = totalCartons - (returnedCartons + replacedCartons);
int soldpcs = totalPc - (returnedpcs + replacedpcs);
totalLB.Text = totalCartons + "C\n" + totalPc + "P";
returnedLB.Text = returnedCartons + "C\n" + returnedpcs + "P";
replacedLB.Text = replacedCartons + "C\n" + replacedpcs + "P";
soldLB.Text = soldCartons + "C\n" + soldpcs + "P";
}
private void searchBTN_Click(object sender, EventArgs e)
{
if (active == "P")
{
DataTable dt = new DataTable();
FacadeController f = FacadeController.getFController();
DataSet s = f.getProducts();
dt = s.Tables["myTable"];
string search = searchTB.Text.ToLower();
foreach (DataRow row in dt.Rows)
{
string name = row["Name"].ToString().ToLower();
string company = row["Company"].ToString().ToLower();
string dispatchno = row["dispatchno"].ToString().ToLower();
if (name.Contains(search) || company.Contains(search) || dispatchno.Contains(search))
{
}
else
{
row.Delete();
}
}
manageProducts1.productsGrid.DataSource = dt;
manageProducts1.productsGrid.DefaultCellStyle.SelectionBackColor = Color.MediumAquamarine;
manageProducts1.productsGrid.DefaultCellStyle.SelectionForeColor = Color.White;
}
}
void saveAllItems()
{
FacadeController f = FacadeController.getFController();
foreach (item i in billItems)
{
int returnedpcs = 0;
int returnedcart = 0;
int replacedpcs = 0;
int replacedcart = 0;
foreach (item ii in returnedItems)
{
if (i.id == ii.id)
{
i.total -= ii.total;
returnedpcs = ii.qtypcs;
returnedcart = ii.qtycart;
break;
}
}
foreach (item ii in replacedItems)
{
if (i.id == ii.id)
{
i.total -= ii.total;
replacedpcs = ii.qtypcs;
replacedcart = ii.qtycart;
break;
}
}
f.saveSaleReturn(i.id, billno, returnedcart, returnedpcs, replacedcart, replacedpcs, payid, i.total);
}
}
public void getAllCCustomers()
{
List <string> s = new List <string>();
FacadeController f = FacadeController.getFController();
cust = f.getAllCustomersInfo();
}
DataTable getAllProducts()
{
FacadeController f = FacadeController.getFController();
DataTable dt = f.getAllProducts().Tables["myTable"];
return(dt);
}
void setPayid()
{
FacadeController f = FacadeController.getFController();
DataSet s = f.getPayment(billno);
payid = int.Parse(s.Tables["myTable"].Rows[0]["id"].ToString());
}
void getAllSales(string billno)
{
int count = 0;
clearAllFields();
billNoLB.Text = billno;
subTotalLB.Text = billsGrid.SelectedRows[0].Cells["subtotal"].Value.ToString();
discountLB.Text = billsGrid.SelectedRows[0].Cells["discount"].Value.ToString();
tax = billsGrid.SelectedRows[0].Cells["tax"].Value.ToString();
whtTypeLB.Text = "WHT (" + tax + ")";
whtLB.Text = billsGrid.SelectedRows[0].Cells["wht"].Value.ToString();
FacadeController f = FacadeController.getFController();
DataTable dt = f.getAllSales(billno).Tables["myTable"];
foreach (DataRow r in dt.Rows)
{
item i = new item();
i.Name = r["Name"].ToString();
i.desc = r["description"].ToString();
i.crt = int.Parse(r["crt"].ToString());
i.tradeOffer = r["tradeOffer"].ToString();
i.expiry = r["expiry"].ToString();
i.rate = int.Parse(r["rate"].ToString());
i.qtycart = int.Parse(r["qtycarton"].ToString());
i.qtypcs = int.Parse(r["qtypc"].ToString());
i.total = int.Parse(r["total"].ToString());
i.id = int.Parse(r["id"].ToString());
i.product_id = int.Parse(r["prod_id"].ToString());
i.tag = (++count).ToString();
billItems.Add(i);
replacedProductCB.Items.Add(count + "." + i.Name + " (" + i.expiry + ")");
returnedProductCB.Items.Add(count + "." + i.Name + " (" + i.expiry + ")");
}
}
private void UserReports_Load(object sender, EventArgs e)
{
FacadeController fc = new FacadeController();
//UserReportsController urc = new UserReportsController();
richTextBox1.Text = fc.Data();
}
void getCompaniesSummary()
{
FacadeController f = FacadeController.getFController();
DataTable dt = f.getCompaniesSummary().Tables["myTable"];
activeCompaniesLB.Text = dt.Rows.Count.ToString();
if (dt.Rows.Count > 0)
{
totalCompaniesLB.Text = dt.Rows[0][0].ToString();
}
else
{
totalCompaniesLB.Text = "0";
}
getactiveCompanies();
dt = f.getTopCompany().Tables["myTable"];
if (dt.Rows.Count > 0)
{
topCompanyLB.Text = dt.Rows[0]["company"].ToString();
}
else
{
topCompanyLB.Text = "-";
}
}
void addProduct(string name, string desc, string rate, string expiry, string qtyCarton, string qtyPcs, string crt, string company)
{
bool exists = false;
FacadeController f = FacadeController.getFController();
DataTable dt = f.getAllProducts().Tables["myTable"];
foreach (DataRow r in dt.Rows)
{
if (r["Name"].ToString().ToLower() == name.ToLower() && r["Expiry"].ToString() == expiry && rate == r["rate"].ToString())
{
exists = true;
int totalQtyPcs = int.Parse(r["qtypcs"].ToString());
if (qtyPcs != "")
{
totalQtyPcs += int.Parse(qtyPcs);
}
int totalQtyCart = int.Parse(qtyCarton) + int.Parse(r["qtycart"].ToString());
f.updateProductQty(r["id"].ToString(), totalQtyPcs.ToString(), totalQtyCart.ToString());
break;
}
}
if (exists == false)
{
if (qtyPcs != "")
{
f.insertProduct(name, desc, rate, expiry, qtyCarton, qtyPcs, crt, company);
}
else
{
f.insertProduct(name, desc, rate, expiry, qtyCarton, qtyPcs = 0.ToString(), crt, company);
}
}
}
void updateCustomerChart()
{
FacadeController f = FacadeController.getFController();
DataTable dt = f.getTopCustomer().Tables["myTable"];
if (dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
firstCustomerLB.Text = dt.Rows[0][0].ToString();
}
else if (i == 1)
{
secondCustomerLB.Text = dt.Rows[1][0].ToString();
}
else if (i == 2)
{
thirdCustomerLB.Text = dt.Rows[2][0].ToString();
}
else if (i == 3)
{
break;
}
}
}
else
{
firstCustomerLB.Text = "-";
secondCustomerLB.Text = "-";
thirdCustomerLB.Text = "-";
}
}
void deliveries()
{
int scheduled = 0;
int pending = 0;
int delivered = 0;
FacadeController f = FacadeController.getFController();
DataTable dt = f.getAllBills().Tables["myTable"];
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
if (r["returned"].ToString() == "0" && r["salesman"].ToString() == "nil")
{
pending++;
}
else if (r["returned"].ToString() == "1")
{
delivered++;
}
else if (r["returned"].ToString() == "0" && r["salesman"].ToString() != "nil")
{
scheduled++;
}
}
}
deliveriesScheduledLB.Text = scheduled.ToString();
deliveriesSentLB.Text = delivered.ToString();
pendingLB.Text = pending.ToString();
}
void getCustomersSummary()
{
FacadeController f = FacadeController.getFController();
DataTable allCustomers = f.getAllCustomers().Tables["myTable"];
DataTable topCustomer = f.getTopCustomer().Tables["myTable"];
DataTable activeCustomer = f.getActiveCustomers().Tables["myTable"];
if (allCustomers.Rows.Count > 0)
{
totalCustomersLB.Text = f.getAllCustomers().Tables["myTable"].Rows[0][0].ToString();
}
else
{
totalCustomersLB.Text = "0";
}
if (activeCustomer.Rows.Count > 0)
{
activeCustomerLB.Text = f.getActiveCustomers().Tables["myTable"].Rows[0][0].ToString();
}
else
{
totalCustomersLB.Text = "0";
}
if (topCustomer.Rows.Count > 0)
{
topCustomerLB.Text = f.getTopCustomer().Tables["myTable"].Rows[0]["Name"].ToString();
}
else
{
topCustomerLB.Text = "0";
}
updateCustomerChart();
}
public void TestMethod1()
{
FacadeController controller = new FacadeController(new OLEDBPersistenceStrategiesFactory(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\users\ctorres\OneDrive - Quest Window Systems Inc\Desktop\Quest_ScanToPrintDevelopment.mdb;Persist Security Info=False;"));
//List<Job> jobs = controller.GetJobs();
//List<ShippingColor> sc = controller.GetShippingColors();
List <JobShippingColor> jsc = controller.GetJobShippingColors();
}
void setGrid()
{
deliveriesGrid.Columns.Clear();
FacadeController f = FacadeController.getFController();
DataTable dt = f.getDeliverySummary().Tables["myTable"];
deliveriesGrid.DataSource = dt;
}
private void Medicine_Load(object sender, EventArgs e)
{
FacadeController fc = new FacadeController();
richTextBox1.Text = fc.MedData();
//UserMedicineController umc = new UserMedicineController();
//richTextBox1.Text= umc.MedData();
}
void updateSalesman()
{
FacadeController f = FacadeController.getFController();
f.updateSalesman(billNoLB.Text, vanNoLB.Text);
MetroMessageBox.Show(this, "Bill No. " + billNoLB.Text + " assigned to Van " + vanNoLB.Text, "Success", MessageBoxButtons.OK, MessageBoxIcon.Information, 200);
update();
}
private void okBTN_Click(object sender, EventArgs e)
{
if (vansCB.Text != "")
{
FacadeController f = FacadeController.getFController();
f.updateSalesman(billNo, vansCB.Text);
Close();
}
}
private void User_Information_Load(object sender, EventArgs e)
{
FacadeController fc = new FacadeController();
//UserUpdateController uic = new UserUpdateController();
BindingSource bs = new BindingSource();
bs.DataSource = fc.User();
dataGridView1.DataSource = bs;
}
static void Main(string[] args)
{
FacadeController controller = new FacadeController(new LocalOLEDBPersistenceStrategiesFactory(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ScanToPrint\ScanToPrint.mdb;Persist Security Info=False;"),
new OnlineOLEDBPersistenceStrategiesFactory(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:\Quest.mdb;Persist Security Info=False;"));
Console.WriteLine(string.Format("Updating local data...{0}", DateTime.Now.TimeOfDay.ToString()));
controller.UpdateTagData();
Console.WriteLine(string.Format("Local data update...{0}", DateTime.Now.TimeOfDay.ToString()));
}
private void button8_Click(object sender, EventArgs e)
{
if (nameTB.Text != "" && descTB.Text != "" && companyCB.Text != "" && crtTB.Text != "")
{
FacadeController f = FacadeController.getFController();
int response = f.addProduct(nameTB.Text, descTB.Text, companyCB.Text, crtTB.Text);
clearTextBoxes();
}
}
private void saveCompany_Click(object sender, EventArgs e)
{
if (addCompanyTB.Text != "")
{
FacadeController f = FacadeController.getFController();
f.insertCompany(addCompanyTB.Text);
addCompanyTB.Text = "";
}
}
public void refreshGrid()
{
FacadeController f = FacadeController.getFController();
loadGrid.Columns.Clear();
sheet = f.getLoadSheet();
getReport();
loadGrid.Columns["date"].Visible = false;
changeGridColors("unselected");
}
