public ActionResult PostDrugOrder(DrugOrderModel model) { int mid = Convert.ToInt32(Session["MemberId"]); int year = Convert.ToInt32(DateTime.Now.Year); int month = Convert.ToInt32(DateTime.Now.Month); int minute = Convert.ToInt32(DateTime.Now.Minute); int ordernumber = Convert.ToInt32(string.Format("{0}{1}{2}", year, month, minute)); string orderstatus = "Requested"; using (ProjectEntities db = new ProjectEntities()) { var id = db.Patients.FirstOrDefault(a => a.MemberId == mid); int pid = id.PatientId; if (model.DrugName != "Select") { // insert db.InsertPatientDrugOrder(pid, model.DrugId, ordernumber, model.Quantity, DateTime.Now, orderstatus); ViewBag.Message = "Order Successful"; } else { ViewBag.Message = "Please Select Drug to be Ordered"; } } List <SelectListItem> lst = new List <SelectListItem>(); using (ProjectEntities db = new ProjectEntities()) { var getdata = db.Drugs.ToList(); foreach (var item in getdata) { lst.Add(new SelectListItem { Value = item.DrugId.ToString(), Text = item.DrugName }); } } DrugOrderModel model1 = new DrugOrderModel(); model1.lstDrugName = lst; return(View("RaiseDrugOrder", model1)); }