Exemple #1
0
        // 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();
        }
Exemple #2
0
        // 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();
        }
Exemple #3
0
        // 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();
        }
Exemple #4
0
        // 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");
            }
        }
Exemple #5
0
        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");
            }
        }
Exemple #6
0
        //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!!!");
            }
        }
Exemple #7
0
        /////////////////////////////////////////////////////////////////////////////////////////////////////////
        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();
        }
Exemple #8
0
        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);
        }
Exemple #9
0
        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());
            }
        }
Exemple #10
0
        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");
            }
        }
Exemple #11
0
        ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
        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");
            }
        }
Exemple #12
0
        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");
            }
        }
Exemple #13
0
        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;

                }

            }
        }
Exemple #14
0
        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;
            }
        }
Exemple #15
0
        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();
        }
Exemple #16
0
 /// <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());
     }
 }
Exemple #17
0
        ///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!!!");

                }
            }
        }
Exemple #18
0
        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());
            }
        }
Exemple #19
0
        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());
            }
        }
Exemple #20
0
        ///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();
        }
Exemple #21
0
        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");
            }
        }
Exemple #22
0
        // 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!!");
            }
        }
Exemple #23
0
        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='" + pass_word + "' ",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='" + pass_word + "'",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();
        }