コード例 #1
0
        public ActionResult Addmedicine()
        {
            list_medicine k    = new list_medicine();
            SqlConnection conn = new SqlConnection("Data Source=UET\\NUMANSQL;Initial Catalog=DB1;Integrated Security=True");

            conn.Open();
            DataTable ds = new DataTable();

            if (conn.State == System.Data.ConnectionState.Open)
            {
                SqlCommand cmd = new SqlCommand("  Select Medicine.Id,Medicine.Name,Medicine.Formula,Medicine.Category,Medicine.Price,MedicineInventory.MedicinePerPack,MedicineInventory.PurchasePricePack,MedicineInventory.SellingPriceItem,MedicineInventory.ThresholdQuantity FROM Medicine INNER JOIN MedicineInventory ON Medicine.Id=MedicineInventory.MedicineId", conn);

                SqlDataAdapter j = new SqlDataAdapter();
                j.SelectCommand = cmd;
                j.Fill(ds);
                foreach (DataRow t in ds.Rows)
                {
                    k.l.Add(new Medicine {
                        Id = Convert.ToInt32(t["Id"]), Name = t["Name"].ToString(), Formula = t["Formula"].ToString(), Category = t["Category"].ToString(), Price = Convert.ToInt32(t["Price"]), MedicinePerPack = Convert.ToInt32(t["MedicinePerPack"]), PurchasePricePack = Convert.ToInt32(t["PurchasePricePack"]), SellingPriceItem = Convert.ToInt32(t["SellingPriceItem"]), ThresholdQuantity = Convert.ToInt32(t["ThresholdQuantity"])
                    });
                }
                return(View(k));
            }



            else
            {
                return(View());
            }
        }
コード例 #2
0
        public ActionResult Addmedicine(list_medicine s)
        {
            SqlConnection conn = new SqlConnection(constr);

            conn.Open();
            if (conn.State == System.Data.ConnectionState.Open)
            {
                string query1 = "Insert into [Medicine] Values('" + s.med.Name.ToString() + "','" + s.med.Formula.ToString() + "','" + s.med.Category.ToString() + "','" + Convert.ToInt32(s.med.Price) + "' )";

                SqlCommand cmd3 = new SqlCommand(query1, conn);
                cmd3.ExecuteNonQuery();
                string     qeury = "Insert into [MedicineInventory] Values ((Select Max(Id) from [Medicine]) ,'" + Convert.ToInt32(s.med.MedicinePerPack) + "','" + Convert.ToInt32(s.med.PurchasePricePack) + "','" + Convert.ToInt32(s.med.SellingPriceItem) + "','" + s.med.ThresholdQuantity + "')";
                SqlCommand ss    = new SqlCommand(qeury, conn);
                ss.ExecuteNonQuery();
                return(RedirectToAction("addmedicine"));
            }
            return(View());
        }
コード例 #3
0
        public ActionResult delete_medicine(int?id)
        {
            list_medicine k    = new list_medicine();
            SqlConnection conn = new SqlConnection("Data Source=UET\\NUMANSQL;Initial Catalog=DB1;Integrated Security=True");

            conn.Open();
            DataTable ds = new DataTable();

            if (conn.State == System.Data.ConnectionState.Open)
            {
                SqlDataAdapter sda1 = new SqlDataAdapter(" Select Medicine.Id,Medicine.Name,Medicine.Formula,Medicine.Category,Medicine.Price,MedicineInventory.MedicinePerPack,MedicineInventory.PurchasePricePack,MedicineInventory.SellingPriceItem,MedicineInventory.ThresholdQuantity FROM Medicine INNER JOIN MedicineInventory ON Medicine.Id=MedicineInventory.MedicineId", conn);

                DataTable TT = new DataTable();

                sda1.Fill(TT);                  //filling the table
                foreach (DataRow dr in TT.Rows) // dt is a DataTable
                {
                    if (id == Convert.ToInt32(dr["Id"]))
                    {
                        string q = "Delete From Medicine where Medicine .Id='" + id + "'";

                        SqlCommand cmd = new SqlCommand(q, conn);
                        cmd.ExecuteNonQuery();
                        string qq = "Delete From MedicineInventory where MedicineInventory.MedicineId='" + id + "'";

                        SqlCommand cmd2 = new SqlCommand(qq, conn);
                        cmd2.ExecuteNonQuery();
                    }
                }
                SqlDataAdapter sda11 = new SqlDataAdapter(" Select Medicine.Id,Medicine.Name,Medicine.Formula,Medicine.Category,Medicine.Price,MedicineInventory.MedicinePerPack,MedicineInventory.PurchasePricePack,MedicineInventory.SellingPriceItem,MedicineInventory.ThresholdQuantity FROM Medicine INNER JOIN MedicineInventory ON Medicine.Id=MedicineInventory.MedicineId ", conn);
                DataTable      TT1   = new DataTable();
                sda11.Fill(TT1);
                foreach (DataRow dr in TT1.Rows)  // dt is a DataTable
                {
                    k.l.Add(new Medicine {
                        Id = Convert.ToInt32(dr["Id"]), Name = dr["Name"].ToString(), Formula = dr["Formula"].ToString(), Category = dr["Category"].ToString(), Price = Convert.ToInt32(dr["Price"]), MedicinePerPack = Convert.ToInt32(dr["MedicinePerPack"]), PurchasePricePack = Convert.ToInt32(dr["PurchasePricePack"]), SellingPriceItem = Convert.ToInt32(dr["SellingPriceItem"])
                    });
                }
            }

            return(View("addmedicine", k));
        }
コード例 #4
0
        public ActionResult Edit_medicne(list_medicine s, int?id)
        {
            SqlConnection con = new SqlConnection(constr);

            con.Open();
            if (con.State == System.Data.ConnectionState.Open)
            {
                string     q   = "UPDATE [Medicine] SET  Medicine.Name='" + s.med.Name.ToString() + "',Medicine.Formula='" + s.med.Formula.ToString() + "',Medicine.Category='" + s.med.Category.ToString() + "',Medicine.Price='" + Convert.ToInt32(s.med.Price) + "' where Medicine.Id='" + id + "'";
                SqlCommand cmd = new SqlCommand(q, con);
                cmd.ExecuteNonQuery();
                string     qq   = "UPDATE [MedicineInventory] SET  MedicineInventory.MedicinePerPack='" + Convert.ToInt32(s.med.MedicinePerPack) + "',MedicineInventory.PurchasePricePack='" + Convert.ToInt32(s.med.PurchasePricePack) + "',MedicineInventory.SellingPriceItem='" + Convert.ToInt32(s.med.SellingPriceItem) + "' ,MedicineInventory.ThresholdQuantity='" + Convert.ToInt32(s.med.ThresholdQuantity) + "'where MedicineInventory.MedicineId ='" + id + "'";
                SqlCommand cmd2 = new SqlCommand(qq, con);
                cmd2.ExecuteNonQuery();

                return(RedirectToAction("addmedicine"));
            }


            return(View());
        }
コード例 #5
0
        public ActionResult Edit_medicne(int?id)
        {
            list_medicine k    = new list_medicine();
            Medicine      m    = new Medicine();
            SqlConnection conn = new SqlConnection("Data Source=UET\\NUMANSQL;Initial Catalog=DB1;Integrated Security=True");

            conn.Open();
            DataTable ds = new DataTable();

            if (conn.State == System.Data.ConnectionState.Open)
            {
                SqlDataAdapter sda1 = new SqlDataAdapter("Select * FROM Medicine INNER JOIN MedicineInventory ON Medicine.Id=MedicineInventory.MedicineId", conn);
                DataTable      TT   = new DataTable();
                sda1.Fill(TT);
                foreach (DataRow dr in TT.Rows)  // dt is a DataTable
                {
                    k.l.Add(new Medicine {
                        Id = Convert.ToInt32(dr["Id"]), Name = dr["Name"].ToString(), Formula = dr["Formula"].ToString(), Category = dr["Category"].ToString(), Price = Convert.ToInt32(dr["Price"]), MedicinePerPack = Convert.ToInt32(dr["MedicinePerPack"]), PurchasePricePack = Convert.ToInt32(dr["PurchasePricePack"]), SellingPriceItem = Convert.ToInt32(dr["SellingPriceItem"]), ThresholdQuantity = Convert.ToInt32(dr["ThresholdQuantity"])
                    });

                    if (id == Convert.ToInt32(dr["Id"]))
                    {
                        m.Id = id;

                        m.Name              = dr["Name"].ToString();
                        m.Formula           = dr["Formula"].ToString();
                        m.Category          = dr["Category"].ToString();
                        m.Price             = Convert.ToInt32(dr["Price"]);
                        m.MedicinePerPack   = Convert.ToInt32(dr["MedicinePerPack"]);
                        m.PurchasePricePack = Convert.ToInt32(dr["PurchasePricePack"]);
                        m.SellingPriceItem  = Convert.ToInt32(dr["SellingPriceItem"]);
                        m.ThresholdQuantity = Convert.ToInt32(dr["ThresholdQuantity"]);
                    }
                }
                k.med = m;
            }
            return(View("addmedicine", k));
        }