public ActionResult ViewOrderDetails()
{
int mid = Convert.ToInt32(Session["MemberId"]);
List <DrugOrderModel> lst = new List <DrugOrderModel>();
using (ProjectEntities db = new ProjectEntities())
{
var id = db.Patients.FirstOrDefault(a => a.MemberId == mid);
int pid = id.PatientId;
var getdata = db.PatientOrderDetails.Where(a => a.PatientId == pid);
foreach (var item in getdata)
{
lst.Add(new DrugOrderModel
{
DrugId = item.DrugId,
DrugName = item.Drug.DrugName,
OrderNumber = Convert.ToInt32(item.OrderNumber),
Quantity = Convert.ToInt32(item.Quantity),
OrderDate = Convert.ToDateTime(item.OrderedDate),
OrderStatus = item.OrderStatus
});
}
}
DrugOrderModel model = new DrugOrderModel();
model.lstDrugOrder = lst;
return(View(model));
}
public ActionResult Add(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
int ElementsToDiscount = int.Parse(collection["add"]);
if (ElementsToDiscount <= Storage.Instance.drugList.ElementAt(id - 1).Stock)
{
int updateStock = Storage.Instance.drugList.ElementAt(id - 1).Stock - ElementsToDiscount;
Storage.Instance.drugList.ElementAt(id - 1).Stock = updateStock;
var drugExpended = new DrugOrderModel
{
Name = collection["name"],
Address = collection["address"],
Nit = collection["nit"],
Id = Storage.Instance.drugList.ElementAt(id - 1).Id,
DrugName = Storage.Instance.drugList.ElementAt(id - 1).DrugName,
Description = Storage.Instance.drugList.ElementAt(id - 1).Description,
Producer = Storage.Instance.drugList.ElementAt(id - 1).Producer,
Price = Storage.Instance.drugList.ElementAt(id - 1).Price,
Stock = ElementsToDiscount,
Total = Storage.Instance.drugList.ElementAt(id - 1).Price *ElementsToDiscount,
};
if (updateStock == 0)
{
DrugModel.Delete(Storage.Instance.drugList.ElementAt(id - 1).DrugName);
}
Storage.Instance.drugCartList.Add(drugExpended);
return(RedirectToAction("Cart"));
}
else
{
return(View("ErrorMessage"));
}
//CALL HERE FUNCTION TO DELETE FROM TREE IF NO STOCK LEFT.
}
catch
{
return(View("ErrorMessage"));
}
}
public ActionResult PostOrderDetail(DrugOrderModel model)
{
using (ProjectEntities db = new ProjectEntities())
{
if (model.SupplierId != 0)
{
// insert
db.InsertDrugDelivery(model.OrderId, model.SupplierId, null);
return(Json("assigned"));
}
else
{
return(Json("Choose Supplier"));
}
}
}
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));
}
public ActionResult Index(FormCollection collection)
{
try
{
var drugName = collection["search"];
Storage.Instance.drugOrderList.Clear();
int drugPosition = DrugModel.Search(drugName) - 1;
DrugOrderModel drugFound = Storage.Instance.drugList.ElementAt(drugPosition);
Storage.Instance.drugOrderList.Add(drugFound);
return(View(Storage.Instance.drugOrderList));
}
catch
{
return(View("ErrorMessage"));
}
}
public ActionResult PostOrderDetail(DrugOrderModel model)
{
using (ProjectEntities db = new ProjectEntities())
{
if (model.Decision != null)
{
if (model.Decision == "Dispatched")
{
var getdata = db.PatientOrderDetails.SingleOrDefault(a => a.OrderId == model.OrderId);
string status = getdata.OrderStatus;
if (status != "Dispatched")
{
db.UpdatePatientOrderDetails(model.OrderId, model.Decision);
return(Json("Item Dispatched"));
}
else
{
return(Json("Oops! Item has already been Dispatched"));
}
}
else
{
var getdata = db.PatientOrderDetails.SingleOrDefault(a => a.OrderId == model.OrderId);
string status = getdata.OrderStatus;
if (status == "Dispatched")
{
db.UpdatePatientOrderDetails(model.OrderId, model.Decision);
db.UpdateDrugDelivery(model.OrderId, DateTime.Now);
return(Json("Item Delivered"));
}
else
{
return(Json("Ooops ! Item has not been Dispatched yet"));
}
}
}
else
{
return(Json("Please Choose Your Decision"));
}
}
}
public ActionResult ViewOrderDetail()
{
List <SelectListItem> lstsup = new List <SelectListItem>();
List <DrugOrderModel> lst = new List <DrugOrderModel>();
using (ProjectEntities db = new ProjectEntities())
{
var data = db.Suppliers.ToList(); // ddl supplier populated here
foreach (var item in data)
{
lstsup.Add(new SelectListItem
{
Value = item.SupplierId.ToString(),
Text = item.FirstName
});
}
var getdata = db.PatientOrderDetails.ToList(); // table record updated here
foreach (var item in getdata)
{
lst.Add(new DrugOrderModel
{
OrderId = item.OrderId,
PatientId = item.PatientId,
PatientName = item.Patient.FirstName,
DrugId = item.DrugId,
DrugName = item.Drug.DrugName,
OrderNumber = Convert.ToInt32(item.OrderNumber),
Quantity = Convert.ToInt32(item.Quantity),
OrderDate = Convert.ToDateTime(item.OrderedDate)
});
}
}
DrugOrderModel model = new DrugOrderModel(); // passing all records collected above to model
model.lstDrugOrder = lst;
model.lstSupplier = lstsup;
return(View(model));
}
public ActionResult RaiseDrugOrder()
{
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 model = new DrugOrderModel();
model.lstDrugName = lst;
return(View(model));
}
public ActionResult ViewPatientOrder()
{
int mid = Convert.ToInt32(Session["MemberId"]);
List <DrugOrderModel> lst = new List <DrugOrderModel>();
using (ProjectEntities db = new ProjectEntities())
{
var data = db.Suppliers.SingleOrDefault(a => a.MemberId == mid);
int sid = data.SupplierId;
var getdata = (from dd in db.DrugDeliveries join pod in db.PatientOrderDetails
on dd.OrderId equals pod.OrderId join p in db.Patients
on pod.PatientId equals p.PatientId join d in db.Drugs
on pod.DrugId equals d.DrugId
where dd.SupplierId == sid
select new { p.FirstName, p.Address, pod.OrderId, pod.OrderNumber, pod.Quantity,
d.DrugName, pod.OrderedDate }).ToList();
foreach (var item in getdata)
{
lst.Add(new DrugOrderModel
{
OrderId = item.OrderId,
OrderNumber = Convert.ToInt32(item.OrderNumber),
PatientName = item.FirstName,
DrugName = item.DrugName,
Address = item.Address,
Quantity = Convert.ToInt32(item.Quantity),
OrderDate = Convert.ToDateTime(item.OrderedDate)
});
}
}
DrugOrderModel model = new DrugOrderModel();
model.lstDrugOrder = lst;
return(View(model));
}
public ActionResult CSV(HttpPostedFileBase postedfile)
{
string FilePath;
if (postedfile != null)
{
string Path = Server.MapPath("~/Data/");
if (!Directory.Exists(Path))
{
Directory.CreateDirectory(Path);
}
FilePath = Path + System.IO.Path.GetFileName(postedfile.FileName);
postedfile.SaveAs(FilePath);
string csvData = System.IO.File.ReadAllText(FilePath);
csvData.Split();
foreach (string row in csvData.Split('\n'))
{
if (!string.IsNullOrEmpty(row))
{
try
{
Regex regx = new Regex("," + "(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");
string[] line = regx.Split(row);
string price = Convert.ToString(regx.Split(row)[4]);
price = price.Substring(1, price.Length - 1);
var drug = new DrugOrderModel
{
Id = Convert.ToInt32(regx.Split(row)[0]),
DrugName = line[1],
Description = line[2],
Producer = line[3],
Price = Convert.ToDouble(price),
Stock = Convert.ToInt32(regx.Split(row)[5]),
};
//SAVE MEDICINE ON THE LIST
Storage.Instance.drugList.Add(drug);
}
catch
{
}
}
}
using (var fileStream = new FileStream(FilePath, FileMode.Open))
{
using (var streamReader = new StreamReader(fileStream))
{
streamReader.ReadLine();
while (!streamReader.EndOfStream)
{
var row = streamReader.ReadLine();
Regex regx = new Regex("," + "(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");
string[] line = regx.Split(row);
var drug = new DrugModel
{
Id = Convert.ToInt32(line[0]),
Name = line[1],
};
//SAVE MEDICINE ON THE TREE
DrugModel.Add(drug);
}
}
}
}
return(View());
}
// GET: DrugOrder/Add/5
public ActionResult Add(int id)
{
DrugOrderModel drugToAdd = Storage.Instance.drugList.ElementAt(id - 1);
return(View(drugToAdd));
}
