Ejemplo n.º 1
0
        public ActionResult Index()
        {
            var db       = new PharmacyEntities();
            var products = db.Products.ToList();

            return(View(products));
        }
Ejemplo n.º 2
0
        public ActionResult FindClient(ClientSearchModel model)
        {
            PharmacyEntities entities = new PharmacyEntities();

            model.ClientResultList = new ClientListModel();
            if (model.SearchingClientData.FirstName != null)
            {
                model.ClientResultList.ClientList = entities.MainClientDatas.Where(
                    x => (x.FirstName.Contains(model.SearchingClientData.FirstName))).ToList();
            }
            if (model.SearchingClientData.LastName != null)
            {
                model.ClientResultList.ClientList = entities.MainClientDatas.Where(
                    x => (x.LastName.Contains(model.SearchingClientData.LastName))).ToList();
            }
            if (model.SearchingClientData.Email != null)
            {
                model.ClientResultList.ClientList = entities.MainClientDatas.Where(
                    x => (x.Email.Contains(model.SearchingClientData.Email))).ToList();
            }

            model.SearchingClientData = new MainClientData();
            model.SearchStatus        = true;
            return(View(model));
        }
Ejemplo n.º 3
0
        public ActionResult Index(string barcode)
        {
            //using (MemoryStream memoryStream = new MemoryStream())
            //{
            //    using (Bitmap bitMap = new Bitmap(barcode.Length * 40, 80))
            //    {
            //        using (Graphics graphics = Graphics.FromImage(bitMap))
            //        {
            //            Font oFont = new Font("IDAutomationHC39M", 16);
            //            PointF point = new PointF(2f, 2f);
            //            SolidBrush whiteBrush = new SolidBrush(Color.White);
            //            graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height);
            //            SolidBrush blackBrush = new SolidBrush(Color.DarkBlue);
            //            graphics.DrawString("*" + barcode + "*", oFont, blackBrush, point);
            //        }

            //        bitMap.Save(memoryStream, ImageFormat.Jpeg);

            //        ViewBag.BarcodeImage = "data:image/png;base64," + Convert.ToBase64String(memoryStream.ToArray());
            //    }
            //}

            ViewBag.Barcode = barcode;

            var db    = new PharmacyEntities();
            var model = db.Products.Where(x => x.Barcode != null).ToList();

            return(View(model));
        }
Ejemplo n.º 4
0
        public ActionResult Index()
        {
            var db    = new PharmacyEntities();
            var model = db.Products.Where(x => x.Barcode != null).ToList();

            return(View(model));
        }
Ejemplo n.º 5
0
        private void addButton_Click_1(object sender, EventArgs e)
        {
            using (PharmacyEntities db = new PharmacyEntities())
            {
                PointsOfSale buff = new PointsOfSale();

                try
                {
                    buff.id = Convert.ToInt32(idTextBox.Text);
                }
                catch (FormatException)
                {
                    MessageBox.Show("Неверно введенные данные!");
                    return;
                }

                buff.AddressOfPoint = adressTexBox.Text;
                db.PointsOfSale.Add(buff);

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateException)
                {
                    MessageBox.Show("ID не должен повторяться!");
                    return;
                }
            }
            Close();
        }
Ejemplo n.º 6
0
 public ActionResult GetAllProduct(string Type)
 {
     using (PharmacyEntities dc = new PharmacyEntities()) {
         var result = dc.prGetProduct(Type).ToList();
         return(Json(result, JsonRequestBehavior.AllowGet));
     }
     return(Json("", JsonRequestBehavior.AllowGet));
 }
Ejemplo n.º 7
0
        public ActionResult Clients()
        {
            PharmacyEntities entities = new PharmacyEntities();
            ClientListModel  model    = new ClientListModel();

            model.ClientList = entities.MainClientDatas.ToList();

            return(View(model));
        }
Ejemplo n.º 8
0
 public ActionResult GetProductInfo(string ProductCode, string Type)
 {
     using (PharmacyEntities dc = new PharmacyEntities())
     {
         var result = dc.prSalesProduct(ProductCode, Type).ToList();
         return(Json(result, JsonRequestBehavior.AllowGet));
     }
     //return Json("", JsonRequestBehavior.AllowGet);
 }
Ejemplo n.º 9
0
        public EditDialogManufacturesForm(int id)
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                nameTextBox.Text = db.Manufactures.Find(id).NameManufacture;
            }

            this.id = id;
        }
Ejemplo n.º 10
0
        public EditDialogPointsOfSaleForm(int id)
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                adressTexBox.Text = db.PointsOfSale.Find(id).AddressOfPoint;

                this.id = id;
            }
        }
Ejemplo n.º 11
0
        public AddDialogMedicalPreparationsForm()
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                foreach (var item in db.Manufactures)
                {
                    manufacturesComboBox.Items.Add(item.NameManufacture);
                }
            }
        }
Ejemplo n.º 12
0
        // GET: Reports
        public ActionResult Stock()
        {
            var result = new ReportStockModel();

            var application = new ApplicationDbContext();
            var db          = new PharmacyEntities();
            var users       = application.Users.ToList();
            var products    = db.Products.ToList();

            result.Users    = users;
            result.Products = products;
            return(View(result));
        }
Ejemplo n.º 13
0
        public ActionResult InsertSalesItem(string ProductCode, int Quantity, string UnitPrice, string TotalCost, int RestOfAmount)
        {
            var      UserID = "1001";
            DateTime today  = DateTime.Today;

            using (PharmacyEntities dc = new PharmacyEntities())
            {
                var result = dc.prISalesIntem(ProductCode, Quantity, UnitPrice, TotalCost, RestOfAmount, UserID, today, "").ToString();
                //var result = dc.prISalesIntem("6", 1, "10", "20", RestOfAmount, UserID, today, "").ToString();
                return(Json(result, JsonRequestBehavior.AllowGet));
            }
            return(Json("", JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 14
0
        public AddDialogProductListForm()
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                foreach (var item in db.MedicalPreparations)
                {
                    medicalPreparationsComboBox.Items.Add(item.NamePreparation);
                }
                foreach (var item in db.PointsOfSale)
                {
                    pointsOfSaleComboBox.Items.Add(item.AddressOfPoint);
                }
            }
        }
Ejemplo n.º 15
0
        private void addButton_Click(object sender, EventArgs e)
        {
            using (PharmacyEntities db = new PharmacyEntities())
            {
                ProductList buff = new ProductList();

                try
                {
                    buff.ProductID = Convert.ToInt32(idTextBox.Text);
                }
                catch (FormatException)
                {
                    MessageBox.Show("Неверно введенные данные!");
                    return;
                }

                foreach (var item in db.MedicalPreparations)
                {
                    if (medicalPreparationsComboBox.Text == item.NamePreparation)
                    {
                        buff.ProductID = item.id;
                        break;
                    }
                }

                foreach (var item in db.PointsOfSale)
                {
                    if (pointsOfSaleComboBox.Text == item.AddressOfPoint)
                    {
                        buff.PointOfSaleID = item.id;
                        break;
                    }
                }

                buff.shelfLife = dateTimePicker1.Value;

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateException)
                {
                    MessageBox.Show("ID не должен повторяться!");
                    return;
                }
            }
        }
Ejemplo n.º 16
0
        // GET: Client
        public ActionResult Details(MainClientData model)
        {
            PharmacyEntities   entities  = new PharmacyEntities();
            ClientDetailsModel viewModel = new ClientDetailsModel();

            if ((model != null) && (model.id != 0))
            {
                viewModel.MainData  = model;
                viewModel.EyeData   = entities.EyeClientDatas.First(x => x.ClientId == model.id);
                viewModel.OtherData = entities.OtherClientDatas.First(x => x.ClientId == model.id);
                return(View(viewModel));
            }
            else
            {
                return(HttpNotFound("Sorry but this page is not exists."));
            }
        }
Ejemplo n.º 17
0
        public ActionResult Index(int id)
        {
            var db     = new PharmacyEntities();
            var model  = db.Products.Find(id);
            var detail = new ProductDetailModel()
            {
                id          = model.ID,
                ProductName = model.ProductName,
                Unit        = model.Unit,
                Price       = model.Buy,
                Category    = model.Category.CateName,
                Barcode     = model.Barcode,
                uuid        = System.Guid.NewGuid().ToString()
            };

            return(Json(detail, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 18
0
 private void editButton_Click(object sender, EventArgs e)
 {
     using (PharmacyEntities db = new PharmacyEntities())
     {
         db.PointsOfSale.Find(id).AddressOfPoint = adressTexBox.Text;
         try
         {
             db.SaveChanges();
         }
         catch (DbUpdateException)
         {
             MessageBox.Show("Ошибка!");
             return;
         }
         Close();
     }
 }
Ejemplo n.º 19
0
        private void editButton_Click(object sender, EventArgs e)
        {
            using (PharmacyEntities db = new PharmacyEntities())
            {
                try
                {
                    db.ProductList.Find(id).id = Convert.ToInt32(idTextBox.Text);
                }
                catch (FormatException)
                {
                    MessageBox.Show("Неверно введенные данные!");
                    return;
                }

                foreach (var item in db.MedicalPreparations)
                {
                    if (medicalPreparationsComboBox.Text == item.NamePreparation)
                    {
                        db.ProductList.Find(id).ProductID = item.id;
                    }
                }

                foreach (var item in db.PointsOfSale)
                {
                    if (pointsOfSaleComboBox.Text == item.AddressOfPoint)
                    {
                        db.ProductList.Find(id).PointOfSaleID = item.id;
                    }
                }

                db.ProductList.Find(id).shelfLife = dateTimePicker.Value;

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateException)
                {
                    MessageBox.Show("Ошибка");
                    return;
                }
            }
            Close();
        }
Ejemplo n.º 20
0
        private void AddButton_Click(object sender, EventArgs e)
        {
            using (PharmacyEntities db = new PharmacyEntities())
            {
                MedicalPreparations buff = new MedicalPreparations();

                try
                {
                    buff.id = Convert.ToInt32(idTextBox.Text);
                    buff.NamePreparation = nameTextBox.Text;

                    foreach (var item in db.Manufactures)
                    {
                        if (manufacturesComboBox.Text == item.NameManufacture)
                        {
                            buff.ManufactureID = item.id;
                            break;
                        }
                    }

                    buff.Price          = Convert.ToDouble(priceTextBox.Text);
                    buff.CountInPackage = Convert.ToInt32(countTextBox.Text);
                }
                catch (FormatException)
                {
                    MessageBox.Show("Неверно введенные данные!");
                    return;
                }

                db.MedicalPreparations.Add(buff);

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateException)
                {
                    MessageBox.Show("ID не должен повторяться!");
                    return;
                }
            }

            this.Close();
        }
Ejemplo n.º 21
0
 public ActionResult Create(CreateClientModel model)
 {
     if (ModelState.IsValid)
     {
         PharmacyEntities entities = new PharmacyEntities();
         entities.MainClientDatas.Add(model.MainData);
         entities.SaveChanges();
         int mainDataId = entities.MainClientDatas.First(x => x.Email == model.MainData.Email).id;
         model.OtherData.ClientId = mainDataId;
         model.EyeData.ClientId   = mainDataId;
         entities.OtherClientDatas.Add(model.OtherData);
         entities.EyeClientDatas.Add(model.EyeData);
         entities.SaveChanges();
         return(RedirectToAction("FindClient"));
     }
     else
     {
         return(View(model));
     }
 }
Ejemplo n.º 22
0
        private void AddButton_Click(object sender, EventArgs e)
        {
            using (PharmacyEntities db = new PharmacyEntities())
            {
                db.Manufactures.Find(this.id).NameManufacture = nameTextBox.Text;

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateException)
                {
                    MessageBox.Show("ID не должен повторяться!");
                    return;
                }
            }


            this.Close();
        }
        public EditDialogMedicalPreparationsForm(int id)
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                nameTextBox.Text = db.MedicalPreparations.Find(id).NamePreparation;

                foreach (var items in db.Manufactures)
                {
                    manufacturesComboBox.Items.Add(items.NameManufacture);
                }

                priceTextBox.Text = db.MedicalPreparations.Find(id).Price.ToString();

                countTextBox.Text = db.MedicalPreparations.Find(id).CountInPackage.ToString();

                this.id = id;
            }
        }
Ejemplo n.º 24
0
        public EditDialogProductListForm(int id)
        {
            InitializeComponent();

            using (PharmacyEntities db = new PharmacyEntities())
            {
                idTextBox.Text = db.ProductList.Find(id).id.ToString();

                foreach (var item in db.MedicalPreparations)
                {
                    medicalPreparationsComboBox.Items.Add(item.NamePreparation);
                }
                foreach (var item in db.PointsOfSale)
                {
                    pointsOfSaleComboBox.Items.Add(item.AddressOfPoint);
                }

                dateTimePicker.Value = db.ProductList.Find(id).shelfLife;
            }



            this.id = id;
        }
Ejemplo n.º 25
0
        public ActionResult Barcode(string Barcode)
        {
            var db    = new PharmacyEntities();
            var model = db.Products.Where(x => x.Barcode == Barcode).FirstOrDefault();

            try
            {
                var detail = new ProductDetailModel()
                {
                    id          = model.ID,
                    ProductName = model.ProductName,
                    Unit        = model.Unit,
                    Price       = model.Buy,
                    Barcode     = model.Barcode,
                    uuid        = System.Guid.NewGuid().ToString()
                };
                return(Json(detail, JsonRequestBehavior.AllowGet));
            }
            catch (Exception)
            {
                var detail = new ProductDetailModel();
                return(Json(detail, JsonRequestBehavior.AllowGet));
            }
        }
Ejemplo n.º 26
0
 public Form1()
 {
     InitializeComponent();
     _db = new PharmacyEntities();
 }
Ejemplo n.º 27
0
 public DeleteType(ComboBox cmb)
 {
     InitializeComponent();
     _db  = new PharmacyEntities();
     _cmb = cmb;
 }
 public MedicinesListController()
 {
     _context = new PharmacyEntities();
 }