void LoadFile()
{
General.CheckForExitsFile(Application.StartupPath + "//" + FirmsP);
General.CheckForExitsFile(Application.StartupPath + "//" + StocksP);
General.CheckForExitsFile(Application.StartupPath + "//" + BState);
General.CheckForExitsFile(Application.StartupPath + "//" + EState);
General.CheckForExitsFile(Application.StartupPath + "//" + CState);
General.CheckForExitsFile(Application.StartupPath + "//" + CPState);
if (General.CheckIsFileNull(BState))
{
General.WriteToFileValue(BState, 0, false);
}
if (General.CheckIsFileNull(EState))
{
General.WriteToFileValue(EState, 0, false);
}
if (General.CheckIsFileNull(CState))
{
General.WriteToFileValue(CState, 0, false);
}
if (General.CheckIsFileNull(CPState))
{
General.WriteToFileValue(CPState, 0, false);
}
General.CheckForExitsDirectory(Application.StartupPath + "//CounterpartyAgentsList//");
General.CheckForExitsDirectory(Application.StartupPath + "//Report//");
/*General.CheckForExitsFile(WorkersSalaryDataFilePath);
* General.CheckForExitsFile(FoodDataFilePath);
* General.CheckForExitsFile(FirmDataFilePath);
* General.CheckForExitsFile(FuelDataFilePath);
* General.CheckForExitsFile(ResultsDataFilePath);
* General.CheckForExitsFile(CashDataFilePath);
* General.CheckForExitsFile(RelDataFilePath);
* General.CheckForExitsFile(Shop0DataFilePath);
* General.CheckForExitsFile(Shop1DataFilePath);
* General.CheckForExitsFile(CounterpartyDataFilePath);
* General.CheckForExitsFile(RawMatDataFilePath);
* General.CheckForExitsFile(RawMat0DataFilePath);
* General.CheckForExitsFile(CounterpartySPASDataFilePath);
* General.CheckForExitsFile(CounterpartyEndOfDataFilePath);
* General.CheckForExitsFile(TransportDataFilePath);
*/
}
private void button1_Click(object sender, EventArgs e)
{
DataPicker D = new DataPicker();
D.OpenT = DataPicker.ReportType.ExpenseReport;
D.button2.Enabled = false;
D.ShowDialog(this);
string Date = D.MonthComboBox.SelectedItem.ToString();
if (Date != null)
{
string FileName = Application.StartupPath + "//Report//" + Date + "//EState.data";
float ESumm = General.ReadFromFileValue(FileName, 0);
float BSumm = General.ReadFromFileValue(Application.StartupPath + "//BState.data", 0);
A += (BSumm / ESumm);
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + Date + "//CalcProductsData");
General.CheckForExitsFile(Application.StartupPath + "//Report//" + Date + "//CalcProductsData//" + ProductName + ".data");
SumLabel.Text = "Общая Сумма:" + A.ToString().Replace(",", ".") + " Сомони";
General.WriteToFileValue(Application.StartupPath + "//Report//" + Date + "//CalcProductsData//" + ProductName + ".data", A.ToString().Replace(".", ","), false);
}
}
void SaveExpenseReport()
{
string DateData = DatePicker.Text;
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + DateData);
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//EState.data", MoneySumResults, false);
try
{
General.Command = new SqlCommand("select sum(Общий) from ExpenseWorker", General.Connection);
General.Connection.Open();
float ExpenseWorkerSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseWorker.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseWorker.data", ExpenseWorkerSumm, false);
string ExpenseWorkerData = Application.StartupPath + "//Report//" + DateData + "//ExpenseWorkerData.data";
General.LoadSQLData("ExpenseWorker", DView);
General.SaveData(ExpenseWorkerData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFood", General.Connection);
General.Connection.Open();
float ExpenseFooodSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFood.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFood.data", ExpenseFooodSumm, false);
string ExpenseFoodData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFoodData.data";
General.LoadSQLData("ExpenseFood", DView);
General.SaveData(ExpenseFoodData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFuel", General.Connection);
General.Connection.Open();
float ExpenseFuel = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFuel.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFuel.data", ExpenseFuel, false);
string ExpenseFuelData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFuelData.data";
General.LoadSQLData("ExpenseFuel", DView);
General.SaveData(ExpenseFuelData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFirm", General.Connection);
General.Connection.Open();
float ExpenseFirmSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFirm.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFirm.data", ExpenseFirmSumm, false);
string ExpenseFirmData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFirmData.data";
General.LoadSQLData("ExpenseFirm", DView);
General.SaveData(ExpenseFirmData, DView);
}
catch (Exception) { }
}
void SaveCollectionReport()
{
string DateData = DatePicker.Text;
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + DateData);
#region Raws
try
{
General.Command = new SqlCommand("select sum(Сумма) from RawMaterials", General.Connection);
General.Connection.Open();
float ImportedRawSum = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsImported.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsImported.data", ImportedRawSum, false);
string ReportRawMaterialsDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsImportedReportData.data";
General.LoadSQLData("RawMaterials", DView);
General.SaveData(ReportRawMaterialsDataFileDATA, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from RemovedRawMaterials", General.Connection);
General.Connection.Open();
float RemovedRawsSummData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsRemoved.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsRemoved.data", RemovedRawsSummData, false);
string ReportRawMaterialsRemovedDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsRemovedReportData.data";
General.LoadSQLData("RemovedRawMaterials", DView);
General.SaveData(ReportRawMaterialsRemovedDataFileDATA, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from RawMaterialsResidue", General.Connection);
General.Connection.Open();
float ResidueRawsMaterials = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsResidue.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsResidue.data", ResidueRawsMaterials, false);
string ReportRawMaterialsResidueDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsResidueReportData.data";
General.LoadSQLData("RawMaterialsResidue", DView);
General.SaveData(ReportRawMaterialsResidueDataFileDATA, DView);
}
catch (Exception) { }
#endregion
#region Shop
try
{
General.Command = new SqlCommand("select sum(КоличествоКаробок) from ShopMaterials", General.Connection);
General.Connection.Open();
float CrateCount = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//BState.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//BState.data", CrateCount, false);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from ShopMaterials", General.Connection);
General.Connection.Open();
float ImportedShopMAterialsData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopMaterials.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopMaterials.data", ImportedShopMAterialsData, false);
string ImportedShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//ImportedShopData.data";
General.LoadSQLData("ShopMaterials", DView);
General.SaveData(ImportedShopMAterialsDataFile, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from SaledShopMaterials", General.Connection);
General.Connection.Open();
float SaledShopMaterials = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopSaled.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopSaled.data", SaledShopMaterials, false);
string SaledShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//SaledShopMaterialsData.data";
General.LoadSQLData("SaledShopMaterials", DView);
General.SaveData(SaledShopMAterialsDataFile, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from ResidueShopMaterials", General.Connection);
General.Connection.Open();
float ResidueShopMaterialsData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopResidue.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopResidue.data", ResidueShopMaterialsData, false);
string ResidueShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//ResidueShopMaterialsData.data";
General.LoadSQLData("ResidueShopMaterials", DView);
General.SaveData(ResidueShopMAterialsDataFile, DView);
}
catch (Exception) { }
#endregion
#region Cash
try
{
General.Command = new SqlCommand("select sum(Оплаченно) from CashData", General.Connection);
General.Connection.Open();
float CounterPartyResults = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//CPState.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//CPState.data", CounterPartyResults, false);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Должен) from CashData", General.Connection);
General.Connection.Open();
float DebtData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//Debt.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//Debt.data", DebtData, false);
}
catch (Exception) { }
try
{
string CashData = Application.StartupPath + "//Report//" + DateData + "//CashRecordsData.data";
General.LoadSQLData("CashData", DView);
General.SaveData(CashData, DView);
}
catch (Exception) { }
#endregion
}
