private void InitializeDGVs(int id)
{
//if (connectionType == ConnectionTypes.Connected)
//{
//}
DGVDiagnoses.DataSource = null;
DGVMedications.DataSource = null;
diagnosesId.Clear();
medicationsId.Clear();
string query = Commands.SelectPrescriptionsDiagnosesWhereId(id);
ConnectedData.SetCommand(query);
int[] size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
int row = size[0];
int column = size[1];
dataDiagnoses = new string[row, column];
dataDiagnoses = ConnectedData.GetTableData();
DGVDiagnoses.RowCount = row + 1;
for (int i = 0; i < row; i++)
{
diagnosesId.Add(Convert.ToInt32(dataDiagnoses[i, 1]));
DGVDiagnoses[0, i].Value = Convert.ToInt32(dataDiagnoses[i, 1]);
}
query = Commands.SelectPrescriptionsMedicationsWhereId(id);
ConnectedData.SetCommand(query);
size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
row = size[0];
column = size[1];
dataMedications = new string[row, column];
dataMedications = ConnectedData.GetTableData();
DGVMedications.RowCount = row + 1;
for (int i = 0; i < row; i++)
{
medicationsId.Add(Convert.ToInt32(dataMedications[i, 1]), Convert.ToInt32(dataMedications[i, 2]));
DGVMedications[0, i].Value = Convert.ToInt32(dataMedications[i, 1]);
DGVMedications[1, i].Value = Convert.ToInt32(dataMedications[i, 2]);
}
}
public Dictionary <int, string> GetPrescriptionsMedications()
{
query = Commands.SelectPrescriptionsMedications();
ConnectedData.SetCommand(query);
Dictionary <int, string> list = new Dictionary <int, string>();
if (connectionType == ConnectionTypes.Connected)
{
int[] size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
int row = size[0];
int column = size[1];
string[,] data = new string[row, column];
data = ConnectedData.GetTableData();
int key = Convert.ToInt32(data[0, 0]);
string str = "";
for (int i = 0; i < row; i++)
{
if (Convert.ToInt32(data[i, 0]) == key)
{
str += data[i, 1] + " " + data[i, 2] + "шт, ";
}
else
{
str = str.Remove(str.Length - 2);
list.Add(key, str);
str = "";
key = Convert.ToInt32(data[i, 0]);
str += data[i, 1] + " " + data[i, 2] + "шт, ";
}
}
str = str.Remove(str.Length - 2);
list.Add(key, str);
}
else
{
dataSet = DisconnectedData.GetTableData(query);
DataTable dataTable = dataSet.Tables[0];
DataRow dataRow = dataTable.Rows[0];
int key = Convert.ToInt32(dataRow[0]);
string str = "";
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
if (Convert.ToInt32(dataRow[0]) == key)
{
str += dataRow[1] + " " + dataRow[2] + "шт, ";
}
else
{
str = str.Remove(str.Length - 2);
list.Add(key, str);
str = "";
key = Convert.ToInt32(dataRow[0]);
str += dataRow[1] + " " + dataRow[2] + "шт, ";
}
}
str = str.Remove(str.Length - 2);
list.Add(key, str);
}
return(list);
}
public void PrescriptionsPrint(SortTypes sort, string name = "")
{
PrescriptionsListView.Items.Clear();
if (name != "")
{
query = Commands.SelectPrescriptions(sort, name);
}
else
{
query = Commands.SelectPrescriptions(sort);
}
ListViewItem item;
if (connectionType == ConnectionTypes.Connected)
{
ConnectedData.SetCommand(query);
int[] size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
int row = size[0];
int column = size[1];
string[,] data = new string[row, column];
data = ConnectedData.GetTableData();
Dictionary <int, string> list = GetPrescriptionsDiagnoses();
Dictionary <int, string> list2 = GetPrescriptionsMedications();
for (int i = 0; i < row; i++)
{
item = new ListViewItem(data[i, 0]);
for (int j = 1; j < column; j++)
{
if (j == 4 || j == 5)
{
bool value = Convert.ToBoolean(data[i, j]);
if (value == true)
{
item.SubItems.Add("+");
}
else
{
item.SubItems.Add("-");
}
}
else
{
item.SubItems.Add(data[i, j]);
}
}
if (list.ContainsKey(Convert.ToInt32(data[i, 0])))
{
item.SubItems.Add(list[Convert.ToInt32(data[i, 0])]);
}
else
{
item.SubItems.Add("-");
}
if (list2.ContainsKey(Convert.ToInt32(data[i, 0])))
{
item.SubItems.Add(list2[Convert.ToInt32(data[i, 0])]);
}
else
{
item.SubItems.Add("-");
}
PrescriptionsListView.Items.Add(item);
}
}
else
{
dataSet = DisconnectedData.GetTableData(query);
DataTable dataTable = dataSet.Tables[0];
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable.Rows[i];
item = new ListViewItem(dataRow[0].ToString());
for (int j = 1; j < dataTable.Columns.Count; j++)
{
if (j == 4 || j == 5)
{
bool value = Convert.ToBoolean(dataRow[j]);
if (value == true)
{
item.SubItems.Add("+");
}
else
{
item.SubItems.Add("-");
}
}
else
{
item.SubItems.Add(dataRow[j].ToString());
}
}
Dictionary <int, string> list = GetPrescriptionsDiagnoses();
Dictionary <int, string> list2 = GetPrescriptionsMedications();
if (list.ContainsKey(Convert.ToInt32(dataRow[0])))
{
item.SubItems.Add(list[Convert.ToInt32(dataRow[0])]);
}
else
{
item.SubItems.Add("-");
}
if (list2.ContainsKey(Convert.ToInt32(dataRow[0])))
{
item.SubItems.Add(list2[Convert.ToInt32(dataRow[0])]);
}
else
{
item.SubItems.Add("-");
}
PrescriptionsListView.Items.Add(item);
}
}
}
public void MedicationsPrint(SortTypes sort, string name = "")
{
double sum = 0;
int countPills = 0;
int countSolutes = 0;
MedicationsListView.Items.Clear();
if (name != "")
{
query = Commands.SelectMedications(sort, name);
}
else
{
query = Commands.SelectMedications(sort);
}
ListViewItem item;
if (connectionType == ConnectionTypes.Connected)
{
ConnectedData.SetCommand(query);
int[] size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
int row = size[0];
int column = size[1];
string[,] data = new string[row, column];
data = ConnectedData.GetTableData();
for (int i = 0; i < row; i++)
{
item = new ListViewItem(data[i, 0]);
for (int j = 1; j < column; j++)
{
if (j == 2)
{
double value = Convert.ToDouble(data[i, j]);
item.SubItems.Add(Math.Round(value, 2).ToString() + " грн");
sum += value;
}
else
{
item.SubItems.Add(data[i, j]);
}
if (j == 5 && data[i, j] == "Таблетки")
{
countPills++;
}
else if (j == 5 && data[i, j] == "Раствор")
{
countSolutes++;
}
}
MedicationsListView.Items.Add(item);
}
}
else
{
dataSet = DisconnectedData.GetTableData(query);
DataTable dataTable = dataSet.Tables[0];
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable.Rows[i];
item = new ListViewItem(dataRow[0].ToString());
for (int j = 1; j < dataTable.Columns.Count; j++)
{
if (j == 2)
{
double value = Convert.ToDouble(dataRow[j]);
item.SubItems.Add(Math.Round(value, 2).ToString() + " грн");
sum += value;
}
else
{
item.SubItems.Add(dataRow[j].ToString());
}
if (j == 5 && dataRow[j].ToString() == "Таблетки")
{
countPills++;
}
else if (j == 5 && dataRow[j].ToString() == "Раствор")
{
countSolutes++;
}
}
MedicationsListView.Items.Add(item);
}
}
LabelMedicationsSumPriceValue.Text = Math.Round(sum, 2).ToString() + " грн";
LabelMedicationsSumPillsValue.Text = countPills.ToString();
LabelMedicationsSumSolutesValue.Text = countSolutes.ToString();
}
public void StorehouseFPrint(SortTypes sort, string name = "")
{
StorehouseFListView.Items.Clear();
if (name != "")
{
query = Commands.SelectStorehouseF(sort, name);
}
else
{
query = Commands.SelectStorehouseF(sort);
}
ListViewItem item;
if (connectionType == ConnectionTypes.Connected)
{
ConnectedData.SetCommand(query);
int[] size = new int[2];
size = ConnectedData.GetRowAndColumnCount();
int row = size[0];
int column = size[1];
string[,] data = new string[row, column];
data = ConnectedData.GetTableData();
for (int i = 0; i < row; i++)
{
item = new ListViewItem(data[i, 0]);
for (int j = 1; j < column; j++)
{
if (j == 5 || j == 6)
{
DateTime value = Convert.ToDateTime(data[i, j]);
item.SubItems.Add(value.ToShortDateString());
}
else
{
item.SubItems.Add(data[i, j]);
}
}
StorehouseFListView.Items.Add(item);
}
}
else
{
dataSet = DisconnectedData.GetTableData(query);
DataTable dataTable = dataSet.Tables[0];
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable.Rows[i];
item = new ListViewItem(dataRow[0].ToString());
for (int j = 1; j < dataTable.Columns.Count; j++)
{
if (j == 5 || j == 6)
{
DateTime value = Convert.ToDateTime(dataRow[j]);
item.SubItems.Add(value.ToShortDateString());
}
else
{
item.SubItems.Add(dataRow[j].ToString());
}
}
StorehouseFListView.Items.Add(item);
}
}
}