private static void PurchaseHistoryIntoSQL(SQLiteConnection DataFile, PurchaseHistoryList PurHisList) { SQLiteCommand insert = new SQLiteCommand(DataFile); for (int i = 0; i < PurHisList.Count; i++) { insert.CommandText = "insert into PurchaseHistory values(" + PurHisList[i].PurchaseHistoryID.ToString() + ", " + PurHisList[i].ShipmentID.ToString() + ", " + PurHisList[i].ClientID.ToString() + ", " + PurHisList[i].Count.ToString() + ", '" + PurHisList[i].Year.ToString() + "-"; if (PurHisList[i].Month < 10) { insert.CommandText += "0" + PurHisList[i].Month.ToString() + "-"; } else { insert.CommandText += PurHisList[i].Month.ToString() + "-"; } if (PurHisList[i].Day < 10) { insert.CommandText += "0" + PurHisList[i].Day.ToString() + "')"; } else { insert.CommandText += PurHisList[i].Day.ToString() + "')"; } insert.ExecuteNonQuery(); } }
public static bool ShipmentReport(string file, ShipmentList Shipments, PurchaseHistoryList PurHisList) { List <string> Titles = new List <string>(); List <int> Prices = new List <int>(); List <int> Counts = new List <int>(); List <int> Costs = new List <int>(); for (int i = 0; i < Shipments.Count; i++) { Titles.Add(Shipments[i].ShipmentName); Prices.Add(Shipments[i].Price); Counts.Add(0); foreach (PurchaseHistory PH in PurHisList.ListOfHistory) { if (Shipments[i].ShipmentID == PH.ShipmentID) { Counts[i] += PH.Count; } } Costs.Add(Shipments[i].Price * Counts[i]); } PDF.CreateShipmentReport(file, Titles, Prices, Counts, Costs); return(true); }
public BackupClass(ClientList Clients, ProviderList Providers, ShipmentList Shipments, ProviderShipmentList ProviderShipment, PurchaseHistoryList PurchaseHistory) { this.Clients = Clients; this.Providers = Providers; this.Shipments = Shipments; this.ProviderShipment = ProviderShipment; this.PurchaseHistory = PurchaseHistory; }
private void OFD_FileOk(object sender, CancelEventArgs e) { string file = OFD.FileName; BackupClass.BackupClass Backup = InputList.InputList.Backup(file); Shipments = Backup.Shipments; Clients = Backup.Clients; Providers = Backup.Providers; ProvidersShipments = Backup.ProviderShipment; PurchaseHistoryL = Backup.PurchaseHistory; MessageBox.Show("Списки успешно перезаписаны"); }
public static PurchaseHistoryList PurchaseHistory(SQLiteConnection DataFile) { PurchaseHistoryList PurHisList = new PurchaseHistoryList(); SQLiteCommand input = new SQLiteCommand(DataFile); input.CommandText = "select * from PurchaseHistory"; SQLiteDataReader sdr = input.ExecuteReader(); while (sdr.Read()) { string[] str = sdr.GetValue(4).ToString().Split('-'); PurHisList.Add(Convert.ToInt32(sdr.GetValue(0)), Convert.ToInt32(sdr.GetValue(1)), Convert.ToInt32(sdr.GetValue(2)), Convert.ToInt32(sdr.GetValue(3)), Convert.ToInt32(str[2]), Convert.ToInt32(str[1]), Convert.ToInt32(str[0])); } return(PurHisList); }
private void StartScreen_Load(object sender, EventArgs e) { if (!File.Exists("mySQLiteLab.sqlite")) { SQLiteConnection.CreateFile("mySQLiteLab.sqlite"); } DataFile.Open(); CreateTable.CreateAll(DataFile); Shipments = InputList.InputList.Shipment(DataFile); Providers = InputList.InputList.Provider(DataFile); Clients = InputList.InputList.Client(DataFile); ProvidersShipments = InputList.InputList.ProviderShipment(DataFile); PurchaseHistoryL = InputList.InputList.PurchaseHistory(DataFile); MaxShipmentID = SearchMaxID.SearchMaxID.FindMaxID(DataFile, "prod"); MaxClientID = SearchMaxID.SearchMaxID.FindMaxID(DataFile, "cl"); MaxProviderID = SearchMaxID.SearchMaxID.FindMaxID(DataFile, "prov"); MaxPurchaseHistoryID = SearchMaxID.SearchMaxID.FindMaxID(DataFile, "ph"); }
public static bool PurchaseHistoryReport(string file, ShipmentList Shipments, PurchaseHistoryList PurHisList) { List <string> Dates = new List <string>(); List <int> Counts = new List <int>(); List <int> Costs = new List <int>(); for (int i = 0; i < PurHisList.Count; i++) { if (Dates.Count == 0) { Dates.Add(FormatDate.GetDate(PurHisList[i].Day, PurHisList[i].Month, PurHisList[i].Year)); Counts.Add(PurHisList[i].Count); foreach (Shipment SH in Shipments.Shipments) { if (SH.ShipmentID == PurHisList[i].ShipmentID) { Costs.Add(PurHisList[i].Count * SH.Price); break; } } } else { int numberOfDate = -1; for (int j = 0; j < Dates.Count; j++) { if (FormatDate.GetDate(PurHisList[i].Day, PurHisList[i].Month, PurHisList[i].Year) == Dates[j]) { numberOfDate = j; break; } } if (numberOfDate != -1) { Counts[numberOfDate] += PurHisList[i].Count; foreach (Shipment SH in Shipments.Shipments) { if (SH.ShipmentID == PurHisList[i].ShipmentID) { Costs[numberOfDate] += PurHisList[i].Count * SH.Price; break; } } } else { Dates.Add(FormatDate.GetDate(PurHisList[i].Day, PurHisList[i].Month, PurHisList[i].Year)); Counts.Add(PurHisList[i].Count); foreach (Shipment SH in Shipments.Shipments) { if (SH.ShipmentID == PurHisList[i].ShipmentID) { Costs.Add(PurHisList[i].Count * SH.Price); break; } } } } } PDF.CreatePurchaseHistoryReport(file, Dates, Counts, Costs); return(true); }
public static bool ClientReport(string file, ClientList Clients, ShipmentList Shipments, PurchaseHistoryList PurHisList) { List <string> Names = new List <string>(); List <int> Counts = new List <int>(); List <int> Costs = new List <int>(); for (int i = 0; i < Clients.Count; i++) { Names.Add(Clients[i].ClientLastName + " " + Clients[i].ClientFirstName); Counts.Add(0); Costs.Add(0); foreach (PurchaseHistory PH in PurHisList.ListOfHistory) { if (PH.ClientID == Clients[i].ClientID) { Counts[i] += PH.Count; foreach (Shipment SH in Shipments.Shipments) { if (SH.ShipmentID == PH.ShipmentID) { Costs[i] += SH.Price * PH.Count; break; } } } } } PDF.CreateClientReport(file, Names, Counts, Costs); return(true); }
public static void OutputIntoSQL(SQLiteConnection DataFile, ShipmentList ShipList, ClientList CList, ProviderList ProvList, ProviderShipmentList ProvShipList, PurchaseHistoryList PurHisList) { ShipmentsIntoSQL(DataFile, ShipList); ClientsIntoSQL(DataFile, CList); ProvidersIntoSQL(DataFile, ProvList); ProviderShipmentsIntoSQL(DataFile, ProvShipList); PurchaseHistoryIntoSQL(DataFile, PurHisList); }
public static void OutputIntoXML(string file, ShipmentList ShipList, ClientList ClList, ProviderList ProvList, ProviderShipmentList ProvShipList, PurchaseHistoryList PurHisList) { BackupClass.BackupClass BC = new BackupClass.BackupClass(ClList, ProvList, ShipList, ProvShipList, PurHisList); StreamWriter NewFile = new StreamWriter(file); XmlSerializer XMLSer = new XmlSerializer(typeof(BackupClass.BackupClass)); XMLSer.Serialize(NewFile, BC); NewFile.Close(); }