public static void sendData(this client cs)//chek input >> connect >> send prescription to server >> db
{
int cnt = 0;
try
{
connectToServer("127.0.0.1", 8001);
}
catch (Exception) { }
MedSchd med = new MedSchd();
med.ClientId = cs.text_id.Text;
med.PharmacistId = cs.Pharmacist_number_txt.Text;
med.MedId = cs.comboMed.SelectedItem.ToString();
if (cs.MorningText.Text == "")
{
med.AmountMorning = 0;
}
else
{
med.AmountMorning = Int32.Parse(cs.MorningText.Text);
}
if (cs.NoonText.Text == "")
{
med.AmountNoon = 0;
}
else
{
med.AmountNoon = Int32.Parse(cs.NoonText.Text);
}
if (cs.NightText.Text == "")
{
med.AmountNight = 0;
}
else
{
med.AmountNight = Int32.Parse(cs.NightText.Text);
}
med.StartTime = DateTime.Now;
med.DaysLong = Int32.Parse(cs.NumOfDays_txt.Text);
string medSchd_json = JsonConvert.SerializeObject(med);
MedSchd med2 = JsonConvert.DeserializeObject <MedSchd>(medSchd_json);
while (cnt < 2)
{
if (cnt == 0)
{
writer.Write("prescription");
cnt++;
}
else
{
writer.Write(medSchd_json);
cnt++;
}
}
}
public void clientHandler(object clientConection)//פתיחת סטרים וקבלת מידע מהלקוח.. הצגת הודעה על העברה מוצלחת או בעיה בהעברה
{
NewClient newC = new NewClient();
string str = "";
int cnt = 0;
TcpClient client = clientConection as TcpClient;
if (client == null)
{
throw new Exception("A non valid connection");
}
NetworkStream stream = client.GetStream();
BinaryReader reader = new BinaryReader(stream);
BinaryWriter writer = new BinaryWriter(stream);
writer.Write("Starting Loop");
while (client.Connected)
{
str = reader.ReadString();
if (str == "EXIT")
{
client.Close();
}
else if (str == "prescription")
{
medSchd_json = reader.ReadString();
medSchd = JsonConvert.DeserializeObject <MedSchd>(medSchd_json);
initConnection();
cnt++;
}
else if (str == "clientId")
{
try
{
string id = reader.ReadString();
bool found = false;
DataSet ds_old_Client_id = new DataSet();
SqlDataAdapter da_old_Client_id = new SqlDataAdapter("SELECT * FROM Client", connection);
da_old_Client_id.Fill(ds_old_Client_id, "Client");
DataRow[] arr_client = ds_old_Client_id.Tables["Client"].Select("IdNumber =" + id);
foreach (DataRow dr in arr_client)
{
found = true;
newC.ClientId += dr["IdNumber"];
newC.FirstName += dr["FirstName"];
newC.LastName += dr["LastName"];
newC.PhoneNumber += dr["PhoneNumber"];
}
if (!found)
{
newC.ClientId = null;
newC.FirstName = null;
newC.LastName = null;
newC.PhoneNumber = null;
string client_json = JsonConvert.SerializeObject(newC);
writer.Write(client_json);
}
else
{
string client_json = JsonConvert.SerializeObject(newC);
writer.Write(client_json);
}
cnt++;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else if (str == "PharmacistId")
{
try
{
string str_p = reader.ReadString();
string str_PN = "";
bool found = false;
DataSet ds_pharmacist = new DataSet();
SqlDataAdapter da_pharmacist = new SqlDataAdapter("SELECT * FROM pharmacist", connection);
da_pharmacist.Fill(ds_pharmacist, "pharmacist");
DataRow[] arr_p = ds_pharmacist.Tables["pharmacist"].Select("IdNumber =" + str_p);
foreach (DataRow dr in arr_p)
{
found = true;
str_PN += dr["FirstName"];
}
if (!found)
{
str_PN = "";
writer.Write(str_PN);
}
else
{
writer.Write(str_PN);
}
cnt++;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else if (str == "MedCombo")
{
DataSet ds_medCombo = new DataSet();
SqlDataAdapter da_medCombo = new SqlDataAdapter("SELECT BrandName FROM medicines", connection);
da_medCombo.Fill(ds_medCombo, "medicines");
DataRow[] arr_p = ds_medCombo.Tables["medicines"].Select();
var medList = ds_medCombo.Tables["medicines"]
.AsEnumerable()
.Select(medicine => new
{
BrnadName = medicine.Field <string>("BrandName")
});
string med_str = "";
foreach (var med in medList)
{
med_str += med.BrnadName.Trim() + ",";
}
writer.Write(med_str);
}
}
}
public static void sendData(this client cs)//בדיקת תקינות ושליחת מידע
{
int cnt = 0;
connectToServer("127.0.0.1", 8001);
MedSchd med = new MedSchd();
med.ClientId = cs.text_id.Text;
med.PharmacistId = Int32.Parse(cs.Pharmacist_number_txt.Text);
med.MedId = cs.comboMed.SelectedItem.ToString();
if (cs.MorningText.Text == "")
{
med.AmountMorning = 0;
}
else
{
med.AmountMorning = Int32.Parse(cs.MorningText.Text);
}
if (cs.NoonText.Text == "")
{
med.AmountNoon = 0;
}
else
{
med.AmountNoon = Int32.Parse(cs.NoonText.Text);
}
if (cs.NightText.Text == "")
{
med.AmountNight = 0;
}
else
{
med.AmountNight = Int32.Parse(cs.NightText.Text);
}
med.StartTime = DateTime.Now;
med.DaysLong = Int32.Parse(cs.NumOfDays_txt.Text);
string medSchd_json = JsonConvert.SerializeObject(med);
MedSchd med2 = JsonConvert.DeserializeObject <MedSchd>(medSchd_json);
while (cnt < 2)
{
if (cnt == 0)
{
writer.Write("prescription");
cnt++;
}
else
{
writer.Write(medSchd_json);
cnt++;
}
}
//איפוס משתנים לאחר שליחה
cs.text_id.Text = "";
cs.text_fName.Text = "";
cs.text_lName.Text = "";
cs.paneldays.Visible = true;
cs.MorningText.Text = "";
cs.NoonText.Text = "";
cs.NightText.Text = "";
cs.comboMed.SelectedIndex = -1;
cs.NumOfDays_txt.Text = "";
cs.PhoneNumberText.Text = "";
}
