public ActionResult ViewDrugsDetails()
{
List <AdminDrugDetailsModel> lst = new List <AdminDrugDetailsModel>();
using (ProjectEntities db = new ProjectEntities())
{
var getdata = db.Drugs.Where(a => a.IsDeleted == false);
foreach (var item in getdata)
{
lst.Add(new AdminDrugDetailsModel
{
DrugId = item.DrugId,
DrugName = item.DrugName,
ManufactureDate = Convert.ToDateTime(item.ManufactureDate),
ExpiredDate = Convert.ToDateTime(item.ExpiredDate),
UsedFor = item.UsedFor,
SideEffects = item.SideEffects,
TotalQuantityAvailable = Convert.ToInt32(item.TotalQuantityAvailable),
});
}
}
AdminDrugDetailsModel model = new AdminDrugDetailsModel();
model.lstdrugdetail = lst;
return(View(model));
}
public ActionResult EditDrugDetails(int id)
{
AdminDrugDetailsModel model = new AdminDrugDetailsModel();
using (ProjectEntities db = new ProjectEntities())
{
var getdata = db.Drugs.SingleOrDefault(a => a.DrugId == id);
model.DrugId = getdata.DrugId;
model.DrugName = getdata.DrugName;
model.ManufactureDate = Convert.ToDateTime(getdata.ManufactureDate);
model.ExpiredDate = Convert.ToDateTime(getdata.ExpiredDate);
model.UsedFor = getdata.UsedFor;
model.SideEffects = getdata.SideEffects;
model.TotalQuantityAvailable = Convert.ToInt32(getdata.TotalQuantityAvailable);
model.IsDeleted = Convert.ToBoolean(getdata.IsDeleted);
return(View("AddDrugDetails", model));
}
}
public ActionResult PostDrugDetails(AdminDrugDetailsModel model)
{
using (ProjectEntities db = new ProjectEntities())
{
if (model.DrugId == 0)
{
// insert
db.InsertDrugDetails(model.DrugName, model.ManufactureDate, model.ExpiredDate, model.UsedFor,
model.SideEffects, model.TotalQuantityAvailable, model.IsDeleted);
ViewBag.Message = "Inserted";
}
else
{
// update
db.UpdateDrugDetails(model.DrugId, model.DrugName, model.ManufactureDate, model.ExpiredDate,
model.UsedFor, model.SideEffects, model.TotalQuantityAvailable, model.IsDeleted);
ViewBag.Message = "Updated";
}
}
return(View("AddDrugDetails"));
}
