// Deleting Price
public void DeletingPrice(int IDOfDrugstore, int IDOfProduct)
{
//
// Searching Price
//
object[] KeyOfRow = new object[] { IDOfDrugstore, IDOfProduct };
DataRow FindRow = PriceList.Rows.Find(KeyOfRow);
if (FindRow != null)
{
//
FindRow.Delete();
//
// Updating
//
ExecutedUpdatingOfPriceList();
//
// Checking Of Count Prices
//
if (PriceList.Rows.Count == 0)
{
//
// Change Of Status Of PriceList
//
CurrentStatus = StatusOfPriceList.SupplementingPriceList;
ChangeOfStatusOfPriceList(CurrentStatus);
}
}
}
// Change Of Status Of PriceList
public void ChangeOfStatusOfPriceList(StatusOfPriceList NewStatus)
{
//
// Updating Status Of PriceList
//
MySqlCommand UpdatingStatus = new MySqlCommand(
String.Format("UPDATE service SET Value = {0} WHERE Id_Service = 6;",
(NewStatus == StatusOfPriceList.FullPriceList) ? "1" : "0"), ConnectionToBase);
try
{
//
// !!!
//
OpeningConnection(UpdatingStatus.Connection);
//
UpdatingStatus.ExecuteScalar();
//
ClosingConnection(UpdatingStatus.Connection);
}
catch (Exception E)
{
//
ClosingConnection(UpdatingStatus.Connection);
//
RecordingInLogFile(String.Format("ERROR Ошибка при обновлении статуса Прайс-Листа: {0}", E.Message));
}
}
// Change Of Status Of PriceList
public void ChangeOfStatusOfPriceList(StatusOfPriceList NewStatus)
{
//
bool AllPrices = false;
//
// Change Of Status
//
CurrentStatus = NewStatus;
if (CurrentStatus == StatusOfPriceList.FullPriceList)
{
AllPrices = true;
}
/*
* //
* // Updating AllPrices
* //
* foreach (DataRow CurrentPrice in PriceList.Rows)
* CurrentPrice["AllPrices"] = AllPrices;
*/
//
// Updating
//
//UPDATE exp_price_list SET Is_all_price = {0} WHERE Is_all_price <> {0};
MySqlCommand UpdatingStatus = new MySqlCommand(
String.Format("UPDATE service SET Value = {0} WHERE Id_Service = 6;",
AllPrices ? "1" : "0"),
ConnectionToBase01);
try
{
bool IsOpen = false;
if (UpdatingStatus.Connection.State == ConnectionState.Open)
{
IsOpen = true;
}
if (!IsOpen)
{
UpdatingStatus.Connection.Open();
}
//
UpdatingStatus.ExecuteScalar();
//
if (!IsOpen)
{
UpdatingStatus.Connection.Close();
}
}
catch (Exception E) { ReturningMessageAboutError("Ошибка при обновлении статуса строк", E, false); }
finally { UpdatingStatus.Connection.Close(); }
//
}
// Deleting All Prices
public void DeletingAllPrices()
{
//
// Giving Status Of Deleting
//
foreach (DataRow CurrentPrice in PriceList.Rows)
{
CurrentPrice.Delete();
}
//
PriceList.AcceptChanges();
//
// Updating
//
MySqlCommand DeletingPrices = new MySqlCommand("DELETE FROM exp_price_list;", ConnectionToBase01);
try
{
bool IsOpen = false;
if (DeletingPrices.Connection.State == ConnectionState.Open)
{
IsOpen = true;
}
if (!IsOpen)
{
DeletingPrices.Connection.Open();
}
//
DeletingPrices.ExecuteScalar();
//
if (!IsOpen)
{
DeletingPrices.Connection.Close();
}
}
catch (Exception E) { ReturningMessageAboutError("Ошибка при удалении строк Прайс-листа", E, false); }
finally { DeletingPrices.Connection.Close(); }
//
// COM
//
//ExecutedUpdatingOfPriceList();
//TypeOfUpdating = "UP";
//ExecutedThreadingsOfUpdatingOfPriceList();
//
// Change Of Status Of PriceList
//
CurrentStatus = StatusOfPriceList.SupplementingPriceList;
ChangeOfStatusOfPriceList(CurrentStatus);
}
// Filling Of PriceList
private void FillingPriceList(bool CreatingSchema)
{
//
// Clearing PriceList
//
PriceList.Clear();
PriceList.Dispose();
PriceList = new DataTable("PriceList");
GC.Collect();
//
// Filling With Data
//
FillingWithDataOfTable(PriceList, "PriceList", UpdatingOfPriceList, CreatingSchema);
//
//if (CreatingSchema)//PriceList.Columns["AllPrices"].AllowDBNull = true;
//
// Creation Of Compound Key
//
//PriceList.PrimaryKey = new DataColumn[] { PriceList.Columns["ID_PH"], PriceList.Columns["ID_PR"] };
try { PriceList.PrimaryKey = new DataColumn[] { PriceList.Columns["ID_PH"], PriceList.Columns["ID_PR"] }; }
catch (Exception E)
{
//
this.RecordingInLogFile(String.Format("Ошибка при создании составного ключа Exp_PL: {0}", E.Message));
this.RecordingInLogFile("Зачистка Exp_PL");
//
// Removal Of Recurrences Of Exp_price_list
//
IntegrityOfData IOfD = new IntegrityOfData(StringOfConnection, this.PathToLogFile);
//
IOfD.RemovalOfRecurrencesOfPriceList("exp_price_list", true);
//
// !!!
//
try
{
//
PriceList.Clear();
PriceList.Dispose();
PriceList = new DataTable("PriceList");
//
FillingWithDataOfTable(PriceList, "PriceList", UpdatingOfPriceList, CreatingSchema);
//
PriceList.PrimaryKey =
new DataColumn[] { PriceList.Columns["ID_PH"], PriceList.Columns["ID_PR"] };
}
catch (Exception E2)
{
//
this.RecordingInLogFile(
String.Format("Ошибка при создании составного ключа Exp_PL: {0}", E2.Message));
this.RecordingInLogFile("Очистка Exp_PL");
//
DeletingAllPrices();
}
}
//
// Reading Status Of PriceList
//
MySqlCommand GettingStatus = new MySqlCommand(
"SELECT Value FROM service WHERE Id_Service = 6;", ConnectionToBase01);
try
{
bool IsOpen = false;
if (GettingStatus.Connection.State == ConnectionState.Open)
{
IsOpen = true;
}
if (!IsOpen)
{
GettingStatus.Connection.Open();
}
//
int ValueOfStatus = (int)GettingStatus.ExecuteScalar();
if (ValueOfStatus == 1)
{
CurrentStatus = StatusOfPriceList.FullPriceList;
}
else
{
CurrentStatus = StatusOfPriceList.SupplementingPriceList;
}
//
if (!IsOpen)
{
GettingStatus.Connection.Close();
}
}
catch (Exception E) { ReturningMessageAboutError("Ошибка при чтении статуса Прайс-Листа", E, false); }
finally { GettingStatus.Connection.Close(); }
/*
* bool AllPrices = false;
* if (PriceList.Rows.Count > 0)
* AllPrices = (bool)PriceList.Rows[0]["AllPrices"];
* //
* if (AllPrices)
* CurrentStatus = StatusOfPriceList.FullPriceList;
* else
* CurrentStatus = StatusOfPriceList.SupplementingPriceList;
*/
}
