public void Search_Process(int seqid, TProtocol iprot, TProtocol oprot)
{
Search_args args = new Search_args();
args.Read(iprot);
iprot.ReadMessageEnd();
Search_result result = new Search_result();
try
{
result.Success = iface_.Search(args.Name);
oprot.WriteMessageBegin(new TMessage("Search", TMessageType.Reply, seqid));
result.Write(oprot);
}
catch (TTransportException)
{
throw;
}
catch (Exception ex)
{
Console.Error.WriteLine("Error occurred in processor:");
Console.Error.WriteLine(ex.ToString());
TApplicationException x = new TApplicationException(TApplicationException.ExceptionType.InternalError, " Internal error.");
oprot.WriteMessageBegin(new TMessage("Search", TMessageType.Exception, seqid));
x.Write(oprot);
}
oprot.WriteMessageEnd();
oprot.Transport.Flush();
}
private void Search_2_Click(object sender, EventArgs e)
{
connection.Open();
Search_result.Text = string.Empty;
string name = TxtDname.Text;
cmd = new SqlCommand("select * From Drug where D_name = '" + name + "' ", connection);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Drug Number: " + dr["D_nom"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Name: " + dr["D_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Price: " + dr["D_price"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Place: " + dr["D_place"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Quantity: " + dr["Quantity"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug EX._date: " + dr["EX_date"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Prescription: " + dr["prescription"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug_classification: " + dr["classification"].ToString() + Environment.NewLine);
Search_result.AppendText("Producer Name: " + dr["producer_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Provider_num: " + dr["provider_num"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Number: " + dr["Br_num"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
public void Search_Process(int seqid, TProtocol iprot, TProtocol oprot)
{
Search_args args = new Search_args();
args.Read(iprot);
iprot.ReadMessageEnd();
Search_result result = new Search_result();
try {
result.Success = iface_.Search(args.Request);
} catch (InvalidOperation ex) {
result.Ex = ex;
}
oprot.WriteMessageBegin(new TMessage("Search", TMessageType.Reply, seqid));
result.Write(oprot);
oprot.WriteMessageEnd();
oprot.Transport.Flush();
}
private void Search_Click(object sender, EventArgs e)
{
Search_result.Text = string.Empty;
string name = TxtBname.Text;
cmd = new SqlCommand("select * From Branch where Place = '" + name + "' ", connection);
connection.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Branch Name: " + dr["Place"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Phone: " + dr["B_phone"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Address: " + dr["Address"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
public Dictionary <int, List <MSSurfing.TClient.Domain.Users.TUser> > recv_Search()
{
TMessage msg = iprot_.ReadMessageBegin();
if (msg.Type == TMessageType.Exception)
{
TApplicationException x = TApplicationException.Read(iprot_);
iprot_.ReadMessageEnd();
throw x;
}
Search_result result = new Search_result();
result.Read(iprot_);
iprot_.ReadMessageEnd();
if (result.__isset.success)
{
return(result.Success);
}
throw new TApplicationException(TApplicationException.ExceptionType.MissingResult, "Search failed: unknown result");
}
private void Search_2_Click(object sender, EventArgs e)
{
connection.Open();
Search_result.Text = string.Empty;
string name = TxtAname.Text;
cmd = new SqlCommand("select * From Accessories where A_name = '" + name + "' ", connection);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Accessory Number: " + dr["A_num"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Name: " + dr["A_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Place: " + dr["A_place"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Quantity: " + dr["Quantity"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory EX._date: " + dr["EX_date"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory classification: " + dr["Classification"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Number: " + dr["Br_num"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
public SearchResult recv_Search()
{
TMessage msg = iprot_.ReadMessageBegin();
if (msg.Type == TMessageType.Exception)
{
TApplicationException x = TApplicationException.Read(iprot_);
iprot_.ReadMessageEnd();
throw x;
}
Search_result result = new Search_result();
result.Read(iprot_);
iprot_.ReadMessageEnd();
if (result.__isset.success)
{
return(result.Success);
}
if (result.__isset.ex)
{
throw result.Ex;
}
throw new TApplicationException(TApplicationException.ExceptionType.MissingResult, "Search failed: unknown result");
}
