// When clicked "Create new Request" Button //
private void B_Click(object sender, RoutedEventArgs e)
{
if (A.identy == 1)
{
Dposition.Visibility = Visibility.Visible;
pos.Visibility = Visibility.Visible;
ExpireDate.Visibility = Visibility.Visible;
ExDate.Visibility = Visibility.Visible;
//t1.Text != null && t2.Text != null && ExDate.Text != null && pos.Text != null
}
l1.Visibility = Visibility.Visible;
l2.Visibility = Visibility.Visible;
t1.Visibility = Visibility.Visible;
t2.Visibility = Visibility.Visible;
b1.Visibility = Visibility.Visible;
b2.Visibility = Visibility.Visible;
B.Visibility = Visibility.Hidden;
grid.Visibility = Visibility.Visible;
grid.ItemsSource = null;
ChangeDetails.Visibility = Visibility.Visible;
DeleteDetails.Visibility = Visibility.Visible;
Connection conn = new Connection();
conn.add();
SqlCommand sq = new SqlCommand("select count(stock_id) from Stock", conn.con);
int cou = (Int32)sq.ExecuteScalar();
if (cou == 0)
{
count = 0;
}
else {
SqlCommand sq1 = new SqlCommand("select top 1 * from Stock order by stock_id desc", conn.con);
count = (Int32)sq1.ExecuteScalar();
}
count++;
conn.exit();
}
// used to send request //
private void b2_Click(object sender, RoutedEventArgs e)
{
B.Visibility = Visibility.Visible;
DateTime dt = DateTime.Now;
TimeSpan t = DateTime.Now.TimeOfDay;
int state = 0;
int dest=0;
if (A.identy != 1 && A.identy != 2 && A.identy != 3)
dest = 3;
else if (A.identy == 2 || A.identy == 3)
dest = 1;
Connection conn=new Connection();
conn.add();
if (A.identy != 1) {
SqlCommand cmd11 = new SqlCommand("insert into RequestNotification(RequestDate,stock_id,RequestTime,Status,ws_id,Destination) values('" + dt + "','" + count + "','" + t + "','" + state + "','" + A.identy + "','" + dest + "');", conn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
}
if (A.identy == 1) {
labal.Content = "Do You sure you need to store such details";
SqlCommand cm = new SqlCommand("update Stock set ws_id='" + 1 + "' where stock_id='" + count + "'", conn.con);
SqlDataReader dr = cm.ExecuteReader();
dr.Close();
}
//MessageBox.Show("Success");
b2.Visibility = Visibility.Hidden;
l1.Visibility = Visibility.Hidden;
l2.Visibility = Visibility.Hidden;
t1.Visibility = Visibility.Hidden;
t2.Visibility = Visibility.Hidden;
b1.Visibility = Visibility.Hidden;
Dposition.Visibility = Visibility.Hidden;
pos.Visibility = Visibility.Hidden;
ExpireDate.Visibility = Visibility.Hidden;
ExDate.Visibility = Visibility.Hidden;
ChangeDetails.Visibility = Visibility.Hidden;
DeleteDetails.Visibility = Visibility.Hidden;
//////////////////////////////////////////
//grid.Visibility = Visibility.Hidden;
labal.Visibility = Visibility.Visible;
Yes.Visibility = Visibility.Visible;
No.Visibility = Visibility.Visible;
conn.exit();
}
// used to change Request or Recived Pharmaceuticals quantity //
private void Button_Click(object sender, RoutedEventArgs e)
{
Connection c=new Connection();
try
{
c.add();
SqlCommand comm = new SqlCommand("update Stock set ph_quantity='" + t22.Text + "' where stock_id='" + S + "' and ph_id='" + t11.Text + "'", c.con);
SqlDataReader dr = comm.ExecuteReader();
dr.Close();
}
catch (Exception ex) {
MessageBox.Show("Not working");
}
t11.Text = "";
t22.Text = "";
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + S + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid123.ItemsSource = dt.DefaultView;
c.exit();
}
// used to view extended request details from IPD,OPD
private void ListBox4_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Phar_notify.Visibility = Visibility.Hidden;
ReqNotify.Visibility = Visibility.Hidden;
MSRequest.Visibility = Visibility.Hidden;
grid123.Visibility = Visibility.Visible;
back.Visibility = Visibility.Hidden;
g11.Visibility = Visibility.Visible;
try
{
String selItem = ListBox4.SelectedItem.ToString();
String[] B = selItem.Split(' ');
int x = Int32.Parse(B[1]);
int y = Int32.Parse(B[4]);
Connection C1 = new Connection();
C1.add();
SqlCommand cmds = new SqlCommand("select stock_id from RequestNotification where Request_id='" + x + "'", C1.con);
S = (Int32)cmds.ExecuteScalar();
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + S + "' ", C1.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid123.ItemsSource = dt.DefaultView;
SqlCommand sq = new SqlCommand("select ws_name from Workstaion where ws_id='" + y + "'", C1.con);
String wor = (String)sq.ExecuteScalar();
C1.exit();
label1.Content = "Requested from " + wor;
label1.Visibility = Visibility.Visible;
approve.Visibility = Visibility.Visible;
Reject.Visibility = Visibility.Visible;
}
catch (Exception ex124)
{
//MessageBox.Show("Good");
}
}
private void Reject_Click(object sender, RoutedEventArgs e)
{
Connection cn = new Connection();
try
{
cn.add();
SqlCommand cmd11 = new SqlCommand("update RequestNotification set Status='" + 2 + "' where stock_id='" + S + "'", cn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
//Add_ListBox();
approve.Visibility = Visibility.Hidden;
Reject.Visibility = Visibility.Hidden;
g11.Visibility = Visibility.Hidden;
back.Visibility = Visibility.Visible;
cn.exit();
}
catch (Exception exe)
{
MessageBox.Show("No exis");
}
}
//delete drugs details //
private void DeleteDetails_Click(object sender, RoutedEventArgs e)
{
try
{
Connection c=new Connection();
c.add();
if (t1.Text != "")
{
SqlCommand com = new SqlCommand("delete Stock where stock_id='" + count + "' and ph_id='" + t1.Text + "'", c.con);
SqlDataReader dr = com.ExecuteReader();
dr.Close();
}
else {
MessageBox.Show("Enter Drug_id");
}
if (A.identy == 1)
{
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity,ph_expire_date,ph_position from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
else
{
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
t2.Text = "";
pos.Text = "";
ExDate.Text = "";
t1.Text = "";
t2.Text = "";
}
catch (Exception v)
{
MessageBox.Show("Invalid Drug ID!!!");
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////
private void Accept_Click(object sender, RoutedEventArgs e)
{
Connection cn = new Connection();
cn.add();
try
{
if (ListBox3.SelectedIndex != -1)
ListBox3.Items.RemoveAt(ListBox3.SelectedIndex);
SqlCommand cmd11 = new SqlCommand("update RequestNotification set Status='" + 3 + "' where stock_id='" + S + "'", cn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
Accept.Visibility = Visibility.Hidden;
approve.Visibility = Visibility.Hidden;
Reject.Visibility = Visibility.Hidden;
g11.Visibility = Visibility.Hidden;
Cancel.Visibility = Visibility.Hidden;
ABack.Visibility = Visibility.Visible;
grid123.Visibility = Visibility.Hidden;
Connection c = new Connection();
c.add();
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ph_quantity,ph_expire_date,ph_position from Stock where stock_id='" + S + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
AcceptDrugsDetails.ItemsSource = dt.DefaultView;
c.exit();
AcceptDrugsDetails.Visibility = Visibility.Visible;
PositionAdd.Visibility = Visibility.Visible;
ADD.Visibility = Visibility.Visible;
}
catch (Exception ex1)
{
MessageBox.Show("No exis");
}
cn.exit();
}
private void adds_Click(object sender, RoutedEventArgs e)
{
Connection c = new Connection();
c.add();
try
{
SqlCommand com = new SqlCommand("update Stock set ph_position='" +T2.Text + "' where stock_id='" + AcceptStockID + "' and ph_id='" + T1.Text + "'", c.con);
SqlDataReader dr = com.ExecuteReader();
dr.Close();
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ph_quantity,ph_expire_date,ph_position from Stock where stock_id='" + AcceptStockID + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
AcceptDrugsDetails.ItemsSource = dt.DefaultView;
T1.Text = null;
T2.Text = null;
}
catch (Exception Ep) {
MessageBox.Show("not");
}
c.exit();
//SqlCommand com = new SqlCommand("insert into Stock(ph_position) values('" + T2 + "') where ph_id='"+T1+"';",c.con);
}
private void ADD_Click(object sender, RoutedEventArgs e)
{
ADD.Visibility = Visibility.Hidden;
PositionAdd.Visibility = Visibility.Hidden;
Connection conn = new Connection();
conn.add();
try
{
SqlCommand cmd11 = new SqlCommand("update Stock set ws_id='" + A.identy + "' where stock_id='" + AcceptStockID + "'", conn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
List<int> phid=new List<int>();
List<int> qenty = new List<int>();
SqlCommand sql=new SqlCommand("select * from Stock where stock_id='"+AcceptStockID+"'",conn.con);
SqlDataReader d=sql.ExecuteReader();
while (d.Read()) {
int a = d.GetInt32(1);
phid.Add(a);
int b = d.GetInt32(7);
qenty.Add(b);
}
d.Close();
for (int i = 0; i < phid.Count; i++) {
SqlCommand cm = new SqlCommand("update PharmaceuticalWorkstation set ExistQuentity=ExistQuentity+'" + qenty[i] + "' where ws_id='" + A.identy + "' and ph_id='" + phid[i] + "'", conn.con);
SqlDataReader dr = cm.ExecuteReader();
dr.Close();
}
phid.Clear();
qenty.Clear();
View_Near_To_Finish_Pharmaceuticals();
//SqlCommand cm = new SqlCommand("update PharmaceuticalWorkstation set ExistQuentity= where stock_id='" + AcceptStockID + "'", conn.con);
}
catch (Exception n)
{
MessageBox.Show(n.ToString());
}
}
void View_Near_To_Finish_Pharmaceuticals()
{
//////////////////////used to view near to finish drugs ///////////////////
try
{
Connection c = new Connection();
c.add();
SqlCommand cmd = new SqlCommand("select ph_id,ph_name,ExistQuentity from PharmaceuticalWorkstation where ws_id='" + A.identy + "' and ExistQuentity<=StaderdQuentity;", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("PharmaceuticalWorkstation");
da.Fill(dt);
NearToFinish.ItemsSource = dt.DefaultView;
}
catch (Exception w)
{
MessageBox.Show("Cant view Near to finish Details");
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
void View_Request_Details()
{
Connection co = new Connection();
try
{
co.add();
SqlCommand command = new SqlCommand("select * from RequestNotification where Status='"+0+"'", co.con); // used to select didn't see Requests //
SqlDataReader DR = command.ExecuteReader();
while (DR.Read()) {
DateTime date = DR.GetDateTime(0);
int word = DR.GetInt32(3); // used to store Requested workstaion ID //
int id = DR.GetInt32(5); // used to store Request ID //
if(word!=1 && word!=2 && word!=3)
ListBox2.Items.Add("Request_ID: "+id+" From Workstation_ID: "+word); // used to store Words/Lab/Theaters Requests //
else if (word == 2 || word == 3) {
ListBox4.Items.Add("Request_ID: " + id + " From Workstation_ID: " + word); // used to store IPD/OPD Requests //
}
}
DR.Close();
co.exit();
}
catch (Exception e) {
MessageBox.Show("Incorrect");
}
}
void View_Accepted_Details()
{
Connection co = new Connection();
try
{
co.add();
SqlCommand command = new SqlCommand("select * from RequestNotification where Status='" + 1 + "'", co.con); // used to select accepted request details //
SqlDataReader DR = command.ExecuteReader();
String v;
while (DR.Read())
{
//DateTime date = DR.GetDateTime(0);
int word = DR.GetInt32(3);
int id = DR.GetInt32(5);
if (word != 2 && word != 3)
v = "IPD";
else
v = "Main Store";
if(A.identy==word)
ListBox3.Items.Add("Request_ID: "+ id +" From Workstation_ID:"+ word+" Accepted by "+v); // used to show requests that are acepted by IPD //
}
DR.Close();
SqlCommand command1 = new SqlCommand("select * from RequestNotification where Status='" + 2 + "'", co.con); // used to select Rejected request details //
SqlDataReader DR1 = command1.ExecuteReader();
while (DR1.Read())
{
//DateTime date = DR.GetDateTime(0);
int word1 = DR1.GetInt32(3);
int id1 = DR1.GetInt32(5);
if (A.identy == word1)
ListBox3.Items.Add("Request_ID: " + id1 + " From Workstation_ID:" + word1 + " Rejected by IPD"); //used to view Rejected Request details //
}
DR1.Close();
co.exit();
}
catch (Exception e)
{
MessageBox.Show("Incorrect");
}
}
void Show_Requested_Details()
{
Connection co = new Connection();
co.add();
SqlCommand cms = new SqlCommand("select stock_id from RequestNotification where Destination='" + A.identy + "' and Status='" + 0 + "' ", co.con); // used to select request from IPD according to Log in Workstation //
SqlDataReader dr = cms.ExecuteReader();
int c = 0;
while (dr.Read())
{
c += 1;
}
dr.Close();
co.exit();
if (c != 0)
{
if (A.identy != 2 && A.identy != 3 && A.identy != 1) // words/Lab/Theaters //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Hidden;
}
else if (A.identy == 3) // IPD //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Visible;
ListBox2.Visibility = Visibility.Visible;
View_Request_Details();
}
else if (A.identy == 2) // OPD //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Hidden;
}
else if (A.identy == 1)
{
ReqNotify.Visibility = Visibility.Hidden;
MSRequest.Visibility = Visibility.Visible;
View_Request_Details();
}
}
else
{
if (A.identy != 2 && A.identy != 3 && A.identy != 1) // words/Lab/Theaters //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Hidden;
}
else if (A.identy == 3) // IPD //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Visible;
ListBox2.Visibility = Visibility.Hidden;
}
else if (A.identy == 2) // OPD //
{
Accepted.Visibility = Visibility.Visible;
ReqNotify.Visibility = Visibility.Hidden;
}
else if (A.identy == 1)
{
ReqNotify.Visibility = Visibility.Hidden;
MSRequest.Visibility = Visibility.Visible;
ListBox4.Visibility = Visibility.Hidden;
}
}
}
void set_details()
{
Connection c = new Connection();
c.add();
if (A.identy == 1)
{
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity,ph_expire_date,ph_position from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
else
{
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
}
private void Cancel_Click(object sender, RoutedEventArgs e)
{
Connection cn = new Connection();
cn.add();
try
{
if (ListBox3.SelectedIndex != -1)
ListBox3.Items.RemoveAt(ListBox3.SelectedIndex);
SqlCommand cmd11 = new SqlCommand("update RequestNotification set Status='" + 4 + "' where stock_id='" + S + "'", cn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
Accept.Visibility = Visibility.Hidden;
approve.Visibility = Visibility.Hidden;
Reject.Visibility = Visibility.Hidden;
g11.Visibility = Visibility.Hidden;
Cancel.Visibility = Visibility.Hidden;
ABack.Visibility = Visibility.Visible;
ADD.Visibility = Visibility.Hidden;
//AcceptDrugsDetails.Visibility = Visibility.Hidden;
PositionAdd.Visibility = Visibility.Hidden;
}
catch (Exception ex1)
{
MessageBox.Show("No exis");
}
cn.exit();
}
/// <summary>
/// ///////////////////////////////////////Add combo boxes/////////////////////////////////////
/// </summary>
void add_Location_Combo()
{
try
{
Connection myConnection = new Connection();
myConnection.add();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select ws_name from Workstaion", myConnection.con);
myReader = myCommand.ExecuteReader();
//string userText = MainMDI.globalstring;
while (myReader.Read())
{
Location.Items.Add(myReader.GetString(0));
}
}
catch (Exception b)
{
MessageBox.Show(b.ToString());
}
}
///used to change Drugs details///
private void ChangeDetails_Click(object sender, RoutedEventArgs e)
{
if (t1.Text == "")
MessageBox.Show("Please enter drug_id for save changes");
else
{
Connection c = new Connection();
c.add();
try
{
if (t2.Text != "") {
SqlCommand cmd1 = new SqlCommand("update Stock set ph_quantity='"+t2.Text+"' where stock_id='"+count+"' and ph_id='"+t1.Text+"' ", c.con);
SqlDataReader dr1 = cmd1.ExecuteReader();
dr1.Close();
SqlCommand cmd2 = new SqlCommand("update Stock set quentity='" + t2.Text + "' where stock_id='" + count + "' and ph_id='"+t1.Text+"' ", c.con);
SqlDataReader dr2 = cmd2.ExecuteReader();
dr2.Close();
}
else if (pos.Text != "") {
SqlCommand cmd3 = new SqlCommand("update Stock set ph_position='" + pos.Text + "' where stock_id='"+count+"' and ph_id='"+t1.Text+"'", c.con);
SqlDataReader dr3 = cmd3.ExecuteReader();
dr3.Close();
}
else if (ExDate.Text != "")
{
SqlCommand cmd4 = new SqlCommand("update Stock set ph_expire_date='" + ExDate.Text + "' where stock_id='" + count + "' and ph_id='"+t1.Text+"' ", c.con);
SqlDataReader dr4 = cmd4.ExecuteReader();
dr4.Close();
}
set_details();
t2.Text = "";
pos.Text = "";
ExDate.Text = "";
t1.Text = "";
t2.Text = "";
}
catch (Exception w2)
{
MessageBox.Show("Invalid Drug ID!!!");
}
}
}
void add_PhName_Comb()
{
try
{
Connection myConnection = new Connection();
myConnection.add();
if (Location.SelectedIndex != -1)
{
Object selectedItem = Location.SelectedItem;
SqlCommand cmd = new SqlCommand("select ws_id from Workstaion where ws_name='" + selectedItem.ToString() + "'", myConnection.con);
int a = (Int32)cmd.ExecuteScalar();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select ph_name from PharmaceuticalWorkstation where ws_id='" + a + "' ", myConnection.con);
myReader = myCommand.ExecuteReader();
//string userText = MainMDI.globalstring;
while (myReader.Read())
{
DrugName.Items.Add(myReader.GetString(0));
}
myReader.Close();
}
}
catch (Exception b)
{
MessageBox.Show(b.ToString());
}
}
private void DrugType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
Connection c = new Connection();
c.add();
Object selectedItem1 = Location.SelectedItem;
SqlCommand cmd = new SqlCommand("select ws_id from Workstaion where ws_name='" + selectedItem1.ToString() + "'", c.con);
int a = (Int32)cmd.ExecuteScalar();
Object selectedItem2 = DrugType.SelectedItem;
String b = selectedItem2.ToString();
//Location.SelectedIndex = -1;
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ExistQuentity,ph_type from PharmaceuticalWorkstation where ws_id='" + a + "' and ph_type='" + b + "'", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("PharmaceuticalWorkstation");
da.Fill(dt);
database.ItemsSource = dt.DefaultView;
}
catch (Exception e123)
{
//MessageBox.Show(e.ToString());
}
}
///when approve request by IPD or Main Store///
private void approve_Click(object sender, RoutedEventArgs e)
{
Connection cn = new Connection();
cn.add();
if (A.identy == 3 || A.identy==1)
{
try
{
SqlCommand cmd11 = new SqlCommand("update RequestNotification set Status='" + 1 + "' where stock_id='" + S + "'", cn.con);
SqlDataReader d11 = cmd11.ExecuteReader();
d11.Close();
approve.Visibility = Visibility.Hidden;
Reject.Visibility = Visibility.Hidden;
g11.Visibility = Visibility.Hidden;
back.Visibility = Visibility.Visible;
//////////////////////////////////////////////////////////////////////////////////////////////////////
List<int> phid = new List<int>();
List<int> qenty = new List<int>();
List<int> Existqenty = new List<int>();
SqlCommand sql = new SqlCommand("select * from Stock where stock_id='" + S + "'", cn.con);
SqlDataReader d = sql.ExecuteReader();
while (d.Read())
{
int a = d.GetInt32(1);
phid.Add(a);
int b = d.GetInt32(7);
qenty.Add(b);
}
d.Close();
for (int j = 0; j < phid.Count; j++) {
SqlCommand scmd = new SqlCommand("select ExistQuentity from PharmaceuticalWorkstation where ws_id='" + A.identy + "' and ph_id='" + phid[j] + "'", cn.con);
Existqenty.Add((Int32)scmd.ExecuteScalar());
}
for (int i = 0; i < phid.Count; i++)
{
if (qenty[i] <= Existqenty[i])
{
SqlCommand cm = new SqlCommand("update PharmaceuticalWorkstation set ExistQuentity=ExistQuentity-'" + qenty[i] + "' where ws_id='" + A.identy + "' and ph_id='" + phid[i] + "'", cn.con);
SqlDataReader dr = cm.ExecuteReader();
dr.Close();
}
else {
SqlCommand cm123 = new SqlCommand("update Stock set ph_quantity='" + 0 + "' where stock_id='" + S + "' and ph_id='" + phid[i] + "'", cn.con);
SqlDataReader dr1 = cm123.ExecuteReader();
dr1.Close();
}
}
phid.Clear();
qenty.Clear();
Existqenty.Clear();
View_Near_To_Finish_Pharmaceuticals();
//SqlCommand cm = new SqlCommand("update PharmaceuticalWorkstation set ExistQuentity= where stock_id='" + AcceptStockID + "'", conn.con);
}
catch (Exception ex1)
{
MessageBox.Show("No exis");
}
}
cn.exit();
}
private void ListBox3_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Phar_notify.Visibility = Visibility.Hidden;
ReqNotify.Visibility = Visibility.Hidden;
Accepted.Visibility = Visibility.Hidden;
grid123.Visibility = Visibility.Visible;
ABack.Visibility = Visibility.Visible;
back.Visibility = Visibility.Hidden;
try
{
String selItem = ListBox3.SelectedItem.ToString();
String[] B = selItem.Split(' ');
int x = Int32.Parse(B[1]);
String state = B[4];
String k;
if (A.identy == 2 || A.identy == 3)
k = "Main Store";
else
k = "IPD";
if (state == "Accepted")
{
g11.Visibility = Visibility.Visible;
label1.Content = "Request accepted by "+k;
Accept.Visibility = Visibility.Visible;
}
else {
g11.Visibility = Visibility.Hidden;
label1.Content = "Request rejected by "+k;
Cancel.Visibility = Visibility.Visible;
}
Connection C1 = new Connection();
C1.add();
SqlCommand cmds = new SqlCommand("select stock_id from RequestNotification where Request_id='" + x + "'", C1.con);
S = (Int32)cmds.ExecuteScalar();
if (state == "Accepted")
AcceptStockID = S;
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + S + "' ", C1.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid123.ItemsSource = dt.DefaultView;
C1.exit();
label1.Visibility = Visibility.Visible;
}
catch (Exception ex124)
{
//MessageBox.Show("Good");
}
}
// used to add pharmaceuticals to created stock //
private void b1_Click(object sender, RoutedEventArgs e)
{
try
{
Connection c = new Connection();
c.add();
if (A.identy == 1) /// if user log in using Main Store ///
{
if (t1.Text != "" && t2.Text != "" && ExDate.Text != "" && pos.Text != "")
{
SqlCommand cmmand = new SqlCommand("select ph_id from Pharmaceuticals where ph_id='" + t1.Text + "' ", c.con);
SqlDataReader d = cmmand.ExecuteReader();
int count1 = 0;
while (d.Read())
{
count1 += 1;
}
d.Close();
if (count1 == 1)
{
SqlCommand sqcom = new SqlCommand("select ph_name from Pharmaceuticals where ph_id='" + t1.Text + "' ", c.con);
String s1 = sqcom.ExecuteScalar().ToString();
DateTime today = DateTime.Today;
if (ExDate.Text == null) {
MessageBox.Show("invalid");
}
SqlCommand cmd = new SqlCommand("insert into Stock(stock_id,ph_id,ph_quantity,quentity,ph_name,ph_expire_date,ph_position) values('" + count + "','" + t1.Text + "','" + t2.Text + "','" + t2.Text + "','" + s1 + "','" + ExDate.Text + "','" + pos.Text + "');", c.con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Close();
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity,ph_expire_date,ph_position from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
else
MessageBox.Show("Parmecutical ID is in valid!");
t1.Text = "";
t2.Text = "";
ExDate.Text = "";
pos.Text = "";
c.exit();
}
else
{
MessageBox.Show("All data must input!");
}
}
else {
if (t1.Text != "" && t2.Text != "")
{
SqlCommand cm = new SqlCommand("select ph_id from Pharmaceuticals where ph_id='" + t1.Text + "' ", c.con);
SqlDataReader d = cm.ExecuteReader();
int count1 = 0;
while (d.Read())
{
count1 += 1;
}
d.Close();
if (count1 == 1)
{
SqlCommand sq = new SqlCommand("select ph_name from Pharmaceuticals where ph_id='" + t1.Text + "' ", c.con);
String s1 = sq.ExecuteScalar().ToString();
SqlCommand cmd = new SqlCommand("insert into Stock(stock_id,ph_id,ph_quantity,quentity,ph_name) values('" + count + "','" + t1.Text + "','" + t2.Text + "','" + t2.Text + "','" + s1 + "');", c.con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Close();
SqlCommand sq1 = new SqlCommand("select ph_id,ph_name,ph_quantity from Stock where stock_id='" + count + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(sq1);
DataTable dt = new DataTable("Stock");
da.Fill(dt);
grid.ItemsSource = dt.DefaultView;
}
else
MessageBox.Show("Parmecutical ID is in valid!");
t1.Text = "";
t2.Text = "";
c.exit();
}
else {
MessageBox.Show("All data must input!!!");
}
}
}
catch (Exception) {
MessageBox.Show("check Input!!");
}
}
private void Location_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
Connection c = new Connection();
c.add();
Object selectedItem = Location.SelectedItem;
header.Content = selectedItem.ToString()+" Drug Warehouse";
header.Visibility = Visibility.Visible;
SqlCommand cmd = new SqlCommand("select ws_id from Workstaion where ws_name='" + selectedItem.ToString() + "'", c.con);
int a = (Int32)cmd.ExecuteScalar();
SqlCommand cmds1 = new SqlCommand("select ph_id,ph_name,ExistQuentity,ph_type from PharmaceuticalWorkstation where ws_id='" + a + "' ", c.con);
SqlDataAdapter da = new SqlDataAdapter(cmds1);
DataTable dt = new DataTable("PharmaceuticalWorkstation");
da.Fill(dt);
database.ItemsSource = dt.DefaultView;
//DrugID.SelectedIndex = -1;
DrugID.Items.Clear();
add_PhID_Comb();
DrugName.Items.Clear();
add_PhName_Comb();
DrugType.Items.Clear();
add_PhType_combo();
}
catch (Exception e111)
{
MessageBox.Show(e111.ToString());
}
}
private void b1_Click(object sender, RoutedEventArgs e)
{
Connection c = new Connection();
c.add();
String user_name = t1.Text;
String pass_word = p.Password;
SqlCommand cmd = new SqlCommand("select user_name,password from login where user_name='" + user_name + "' and password='******' ",c.con);
SqlDataReader dr;
dr= cmd.ExecuteReader();
int count = 0;
while (dr.Read())
{
count += 1;
}
dr.Close();
if (count == 1)
{
//MessageBox.Show("Login sucess ");
SqlCommand cm = new SqlCommand("select emp_id from login where user_name='" + user_name + "' and password='******'",c.con);
int a = (Int32)cm.ExecuteScalar();
SqlCommand cm1=new SqlCommand("select ws_name from Workstaion where ws_id='"+a+"'",c.con);
String works = (String)cm1.ExecuteScalar();
A.identy = a;
if (a == 3 || a == 4 || a == 5 || a == 6 || a == 7 || a==1 ||a==2) {
Window1 a1 = new Window1();
a1.Title = "Log in "+works;
a1.Show();
this.Hide();
}
}
else
{
MessageBox.Show("User Name or Password is Incorrect!");
}
c.exit();
}