public override void Delete() { Global.ShowNotifier("Deleted Item : (" + ID + ") " + this.Description); String Sql = "Delete From Product Where ProductID='" + this.ID + "' And CompanyID='" + this.CompanyID + "'"; oMySql.exec_sql(Sql); Sql = "Delete From BrochureDetail Where ProductID='" + this.ID + "' And CompanyID='" + this.CompanyID + "'"; oMySql.exec_sql(Sql); }
public Boolean GenerateFinanceCharges(Double Percent) { DateTime FromDate; DateTime ToDate; FromDate = this.DeliveryDate; ToDate = DateTime.Now; if (this.DeliveryDate == Global.DNull) { Global.ShowNotifier("No delivery date to calculate from"); return(false); } if (this.StatementAmountDue <= 0) { return(false); } Int32 PassedMonths = (Int32)DateAndTime.DateDiff(DateInterval.Month, FromDate, ToDate, FirstDayOfWeek.System, FirstWeekOfYear.System); Int32 ChargesNumber = GetFinanceChargesNumber(); Double Amount = AmountDue - GetFinanceChargesAmount(); Boolean Changed = false; // MessageBox.Show(Amount.ToString()); for (int i = 0; i < PassedMonths - ChargesNumber; i++) { Charge oCharge = new Charge(CompanyID); oCharge.Comment = "FINANCE CHARGES"; oCharge.Type = "F"; oCharge.CustomerID = ID; oCharge.Date = this.DeliveryDate.AddMonths(ChargesNumber + i + 1); if (DateTime.Now >= oCharge.Date && i >= 0) { if (Amount * Percent / 100 > 0.00) { if (oCharge.FindByDate(oCharge.Date, ID, "F")) { oCharge.Amount = Amount * Percent / 100; oCharge.Update(); Changed = true; } else { oCharge.Date = this.DeliveryDate.AddMonths(ChargesNumber + i + 1); oCharge.Amount = Amount * Percent / 100; oCharge.Insert(); Changed = true; } } } } return(Changed); }
public bool DeletePrinterConnection(String Printer) { int result; Global.ShowNotifier("Deleting printer : " + Printer); try { result = PrintDirect.DeletePrinterConnectionA(Printer); } catch (Exception e) { Console.WriteLine("Exception:" + e.Message); return false; } //Console.Read(); return true; }
public bool AddPrinterConnection(String Printer) { bool result; Global.ShowNotifier("Adding printer : " + Printer); try { //result = PrintDirect.AddPrinterConnection("\\\\sha-prn-01\\2017hp8100"); //Console.WriteLine("result:" + result); result = PrintDirect.AddPrinterConnection(Printer); } catch (Exception e) { Console.WriteLine("Exception:" + e.Message); return false; } //Console.Read(); return true; }
public override bool Find(int OrderID, string PackID) { //Header if (!FindHeader(OrderID)) { return(false); } ImprintItems.Clear(); LocalItems = 0; DataView tDetail = new DataView(); if (PackID != "0" && PackID != "") { tDetail = oMySql.GetDataView(String.Format("SELECT ot.OrderID as ID, ot.ID as TicketID, o.CustomerID, ot.Quantity,ot.ProductID, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode,ot.Printed FROM OrderTicket ot Left Join Orders o On o.ID=ot.OrderID Left Join Product p On p.ProductID=ot.ProductID And p.CompanyID=o.CompanyID Where ot.OrderID='{0}' ", this.ID), "Detail"); } foreach (DataRow Row in tDetail.Table.Rows) { ImprintItem Item = new ImprintItem(); Item.Description = Row["Description"].ToString(); Item.TicketID = (int)Row["TicketID"]; Item.ProductID = Row["ProductID"].ToString(); Item.Quantity = (int)Row["Quantity"]; Item.Description = Row["Description"].ToString(); Item.InvCode = Row["InvCode"].ToString(); Item.BarCode = Row["BarCode"].ToString(); //Row["ProductID"].ToString(); Item.BarCode2 = Row["BarCode_2"].ToString(); Item.BarCode3 = Row["BarCode_3"].ToString(); Item.Printed = (Boolean)Row["Printed"];; if (Item.BarCode.Trim() == "") { Global.ShowNotifier("This Product doesn't have BarCode : " + Row["ProductID"].ToString()); } ImprintItems.Add(Row["TicketID"].ToString(), Item); LocalItems++; } return(true); }
public override bool Find(int OrderID, string PackID) { //Header if (!FindHeader(OrderID)) { return(false); } //Detail //Detail.Clear(); Items.Clear(); LocalItems = 0; DataView tDetail = new DataView(); if (PackID != "0" && PackID != "") { tDetail = oMySql.GetDataView("Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Where OrderID='" + ID + "' And PackID='" + PackID + "'", "Detail"); //tDetail = oMySql.GetDataView("Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Left Join Card c On d.CompanyID=c.CompanyID And d.ProductID=c.ProductID Where OrderID='" + ID + "' And PackID='" + PackID + "' And c.ProductID is null", "Detail"); } else { tDetail = oMySql.GetDataView("Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Where OrderID='" + ID + "'", "Detail"); } foreach (DataRow Row in tDetail.Table.Rows) { ScanItem Detail = new ScanItem(); Detail.Description = Row["Description"].ToString(); Detail.CompanyID = CompanyID; Detail.CustomerID = CustomerID; Detail.ProductID = Row["ProductID"].ToString(); Detail.Packed = Row["ProductID"].ToString(); Detail.Quantity = (int)Row["Quantity"]; Detail.Description = Row["Description"].ToString(); Detail.BarCode = Row["BarCode"].ToString(); //Row["ProductID"].ToString(); Detail.Scanned = 0; Detail.InvCode = Row["InvCode"].ToString(); Detail.BarCode2 = Row["BarCode_2"].ToString(); Detail.BarCode3 = Row["BarCode_3"].ToString(); if (Detail.BarCode.Trim() == "") { Global.ShowNotifier("This Product doesn't have BarCode : " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else if (ScanItems.Contains(Detail.BarCode)) { Global.ShowNotifier("This BarCode is already in this order: " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else { ScanItems.Add(Row["BarCode"].ToString(), Detail); } LocalItems += Detail.Quantity; } oPrize.Find(oCustomer.PrizeID); if (oPrize.PackID != PackID) { return(true); } DataView dvPrizes = oPrize.GetItems(oCustomer.PrizeID, NoItems); foreach (DataRow Row in dvPrizes.Table.Rows) { if (!((Boolean)Row["IsCompound"])) { ScanItem Detail = new ScanItem(); Detail.Description = Row["Description"].ToString(); Detail.CompanyID = CompanyID; Detail.CustomerID = CustomerID; Detail.ProductID = Row["ProductID"].ToString(); //Detail.Packed = Row["ProductID"].ToString(); Detail.Quantity = Convert.ToInt32(Row["Quantity"].ToString()); Detail.BarCode = Row["BarCode"].ToString(); //Row["ProductID"].ToString(); Detail.BarCode2 = Row["BarCode_2"].ToString(); Detail.BarCode3 = Row["BarCode_3"].ToString(); Detail.InvCode = Row["InvCode"].ToString(); Detail.Scanned = 0; if (Detail.BarCode.Trim() == "") { Global.ShowNotifier("This Product doesn't have BarCode : " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else if (ScanItems.Contains(Detail.BarCode)) { Global.ShowNotifier("This BarCode is already in this order: " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else { ScanItems.Add(Row["BarCode"].ToString(), Detail); } LocalItems += Detail.Quantity; } else { //Prizes compound products DataView dvCompoundPrizes = this.oProduct.Items.GetTable(Row["ProductID"].ToString()); foreach (DataRow row in dvCompoundPrizes.Table.Rows) { ScanItem _Detail = new ScanItem(); _Detail.Description = row["Description"].ToString(); _Detail.CompanyID = CompanyID; _Detail.CustomerID = CustomerID; _Detail.ProductID = row["ProductID"].ToString(); //Detail.Packed = Row["ProductID"].ToString(); _Detail.Quantity = 1; _Detail.BarCode = row["BarCode"].ToString(); //Row["ProductID"].ToString(); _Detail.BarCode2 = row["BarCode_2"].ToString(); _Detail.BarCode3 = row["BarCode_3"].ToString(); _Detail.InvCode = row["InvCode"].ToString(); _Detail.Scanned = 0; if (_Detail.BarCode.Trim() == "") { Global.ShowNotifier("This Product doesn't have BarCode : " + row["ProductID"].ToString()); ScanItems.Add(row["ProductID"].ToString(), _Detail); } else if (ScanItems.Contains(_Detail.BarCode)) { Global.ShowNotifier("This BarCode is already in this order: " + row["ProductID"].ToString()); ScanItems.Add(row["ProductID"].ToString(), _Detail); } else { ScanItems.Add(row["BarCode"].ToString(), _Detail); } LocalItems += _Detail.Quantity; } } } return(true); }
public bool Find(int OrderID, string PackID, String SectionID) { String Sql = ""; //Detail //Detail.Clear(); //Items.Clear(); LocalItems = 0; DataView tDetail = new DataView(); if (PackID != "0" && PackID != "") { Sql = "Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Where OrderID='" + base.OrderID + "' And PackID='" + PackID + "' And p.SectionID='" + SectionID + "'"; tDetail = oMySql.GetDataView(Sql, "Detail"); //tDetail = oMySql.GetDataView("Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Left Join Card c On d.CompanyID=c.CompanyID And d.ProductID=c.ProductID Where OrderID='" + ID + "' And PackID='" + PackID + "' And c.ProductID is null", "Detail"); } else { tDetail = oMySql.GetDataView("Select d.ProductID,d.Quantity, p.Description,p.BarCode,p.BarCode_2,p.BarCode_3,p.InvCode From OrderDetail as d Left Join Product as p On d.ProductID=p.ProductID And d.CompanyID=p.CompanyID Where OrderID='" + ID + "'", "Detail"); } ///Adding Prizes oPrize.Find(oCustomer.PrizeID); if (oPrize.PackID != PackID) { return(true); } DataView dvPrizes = oPrize.GetItems(oCustomer.PrizeID, NoItems, SectionID); foreach (DataRow Row in dvPrizes.Table.Rows) { DataRow row = tDetail.Table.NewRow(); row["ProductID"] = Row["ProductID"]; row["InvCode"] = Row["InvCode"]; row["Quantity"] = 1; row["BarCode"] = Row["BarCode"]; row["BarCode_2"] = Row["BarCode_2"]; row["BarCode_3"] = Row["BarCode_3"]; row["Description"] = Row["Description"]; tDetail.Table.Rows.Add(row); } foreach (DataRow Row in tDetail.Table.Rows) { ScanItem Detail = new ScanItem(); Detail.CompanyID = CompanyID; Detail.CustomerID = CustomerID; Detail.ProductID = Row["ProductID"].ToString(); Detail.Packed = Row["ProductID"].ToString(); Detail.Quantity = (int)Row["Quantity"]; Detail.Description = Row["Description"].ToString(); Detail.BarCode = Row["BarCode"].ToString(); //Row["ProductID"].ToString(); Detail.Scanned = 0; Detail.InvCode = Row["InvCode"].ToString(); Detail.BarCode2 = Row["BarCode_2"].ToString(); Detail.BarCode3 = Row["BarCode_3"].ToString(); if (Detail.BarCode.Trim() == "") { Global.ShowNotifier("This Product doesn't have BarCode : " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else if (ScanItems.Contains(Detail.BarCode)) { Global.ShowNotifier("This same BarCode is already in this order: " + Row["ProductID"].ToString()); ScanItems.Add(Row["ProductID"].ToString(), Detail); } else { ScanItems.Add(Row["BarCode"].ToString(), Detail); } LocalItems += Detail.Quantity; } oPrize.Find(oCustomer.PrizeID); //if (oPrize.PackID != PackID) // return true; /* * if (SectionID == "X") * { * * DataView dvPrizes = oPrize.GetItems(oCustomer.PrizeID, base.NoItems, SectionID); * * foreach (DataRow Row in dvPrizes.Table.Rows) * { * if (!((Boolean)Row["IsCompound"])) * { * ScanItem Detail = new ScanItem(); * * Detail.Description = Row["Description"].ToString(); * Detail.CompanyID = CompanyID; * Detail.CustomerID = CustomerID; * Detail.ProductID = Row["ProductID"].ToString(); * //Detail.Packed = Row["ProductID"].ToString(); * Detail.Quantity = Convert.ToInt32(Row["Quantity"].ToString()); * Detail.BarCode = Row["BarCode"].ToString(); //Row["ProductID"].ToString(); * Detail.BarCode2 = Row["BarCode_2"].ToString(); * Detail.BarCode3 = Row["BarCode_3"].ToString(); * Detail.InvCode = Row["InvCode"].ToString(); * Detail.Scanned = 0; * if (Detail.BarCode.Trim() == "") * { * Global.ShowNotifier("This Product doesn't have BarCode : " + Row["ProductID"].ToString()); * ScanItems.Add(Row["ProductID"].ToString(), Detail); * } * else if (ScanItems.Contains(Detail.BarCode)) * { * Global.ShowNotifier("This BarCode is already in this order: " + Row["ProductID"].ToString()); * ScanItems.Add(Row["ProductID"].ToString(), Detail); * } * else * ScanItems.Add(Row["BarCode"].ToString(), Detail); * * LocalItems += Detail.Quantity; * } * else * { * //Prizes compound products * * DataView dvCompoundPrizes = this.oProduct.Items.GetTable(Row["ProductID"].ToString()); * foreach (DataRow row in dvCompoundPrizes.Table.Rows) * { * * ScanItem _Detail = new ScanItem(); * * _Detail.Description = row["Description"].ToString(); * _Detail.CompanyID = CompanyID; * _Detail.CustomerID = CustomerID; * _Detail.ProductID = row["ProductID"].ToString(); * //Detail.Packed = Row["ProductID"].ToString(); * _Detail.Quantity = 1; * _Detail.BarCode = row["BarCode"].ToString(); //Row["ProductID"].ToString(); * _Detail.BarCode2 = row["BarCode_2"].ToString(); * _Detail.BarCode3 = row["BarCode_3"].ToString(); * _Detail.InvCode = row["InvCode"].ToString(); * _Detail.Scanned = 0; * if (_Detail.BarCode.Trim() == "") * { * Global.ShowNotifier("This Product doesn't have BarCode : " + row["ProductID"].ToString()); * ScanItems.Add(row["ProductID"].ToString(), _Detail); * } * else if (ScanItems.Contains(_Detail.BarCode)) * { * Global.ShowNotifier("This BarCode is already in this order: " + row["ProductID"].ToString()); * ScanItems.Add(row["ProductID"].ToString(), _Detail); * } * else * ScanItems.Add(row["BarCode"].ToString(), _Detail); * * LocalItems += _Detail.Quantity; * } * } * } * }*/ return(true); }
public static void playSimpleSound(int Index) { String Path = "G:\\Sounds\\"; if (Global.IsRunningOnMono()) { Path = "Sounds/"; } SoundPlayer simpleSound; switch (Index) { case 0: //SystemSounds.Hand.Play(); simpleSound = new SoundPlayer(@Path + "meep1.wav"); break; case 1: //SystemSounds.Asterisk.Play(); simpleSound = new SoundPlayer(@Path + "brkglass.wav"); break; case 2: //SystemSounds.Beep.Play(); simpleSound = new SoundPlayer(@Path + "meep.wav"); break; case 3: //SystemSounds.Exclamation.Play(); simpleSound = new SoundPlayer(@Path + "ouch2.wav"); break; case 4: SystemSounds.Hand.Play(); return; case 5: simpleSound = new SoundPlayer(@Path + "brkglss2.wav"); break; case 6: simpleSound = new SoundPlayer(@Path + "digital_blip.wav"); break; case 7: simpleSound = new SoundPlayer(@Path + "guitwail.wav"); break; default: //SystemSounds.Question.Play(); simpleSound = new SoundPlayer(@Path + "brkglss2.wav"); //@"c:\Windows\Media\chimes.wav"); break; } try { simpleSound.Play(); } catch (Exception e) { Global.ShowNotifier(e.Message); } //SoundPlayer simpleSound = new SoundPlayer(System.Environment.GetEnvironmentVariable("windir") + @"\Media\HeyHey.wav"); //@"c:\Windows\Media\chimes.wav"); //SoundPlayer simpleSound = new SoundPlayer(Application.StartupPath + @"\HeyHey.wav"); //@"c:\Windows\Media\chimes.wav"); //simpleSound.Play(); }