public ActionResult EditDrugs(int?ID)
{
CASDatabaseEntities db = new CASDatabaseEntities();
DrugDataModel dt = new DrugDataModel();
int id = Convert.ToInt32(ID);
var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault();
if (getData != null)
{
dt.DrugName = getData.DrugName;
dt.Manufacturer = getData.Manufacturer;
dt.Substitutions = getData.Substitutions;
dt.Uses = getData.Uses;
dt.SideEffects = getData.SideEffects;
dt.NotRecommended = getData.NotRecommended;
dt.MfgDate = getData.MfgDate;
dt.ExpDate = getData.ExpDate;
dt.QOH = getData.QOH;
dt.QOHType = getData.QOHType;
dt.Price = Convert.ToDouble(getData.Price);
dt.DiscountAmount = Convert.ToDouble(getData.DiscountAmount);
dt.IsDeleted = getData.IsDeleted;
}
return(View(dt));
}
public ActionResult AddDrugs(DrugDataModel dt)
{
CASDatabaseEntities db = new CASDatabaseEntities();
Drug objDrug = new Drug();
if (ModelState.IsValid)
{
var getData = db.Drugs.Where(m => m.DrugName == dt.DrugName).FirstOrDefault();
if (getData != null)
{
ViewBag.Text = "Drug Already Present. Only Updation Allowed";
}
else
{
if (dt.QOH == 0)
{
ViewBag.Text = "New Drug Cannot Be Entered With ZERO Quantity.";
}
else
{
if (dt.MfgDate > DateTime.Today || dt.ExpDate < DateTime.Today)
{
ViewBag.Text = "Invalid Manufacturing or Expiry Date";
}
else
{
objDrug.DrugName = dt.DrugName;
objDrug.Manufacturer = dt.Manufacturer;
objDrug.Substitutions = dt.Substitutions;
objDrug.MfgDate = dt.MfgDate;
objDrug.ExpDate = dt.ExpDate;
objDrug.Uses = dt.Uses;
objDrug.SideEffects = dt.SideEffects;
objDrug.NotRecommended = dt.NotRecommended;
objDrug.QOH = dt.QOH;
objDrug.QOHType = dt.QOHType;
objDrug.Price = Convert.ToDecimal(dt.Price);
objDrug.DiscountAmount = Convert.ToDecimal(dt.DiscountAmount);
objDrug.IsDeleted = false;
db.Drugs.Add(objDrug);
db.SaveChanges();
ViewBag.Text = "Drug Inserted Successfully";
}
}
}
}
return(View(dt));
}
public ActionResult DeleteDrugs(int?ID)
{
CASDatabaseEntities db = new CASDatabaseEntities();
DrugDataModel dt = new DrugDataModel();
int id = Convert.ToInt32(ID);
var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault();
if (getData != null)
{
getData.IsDeleted = true;
dt.IsDeleted = getData.IsDeleted;
db.SaveChanges();
}
return(RedirectToAction("ViewDrugs", "Admin"));
}
public ActionResult Drugs()
{
CASDatabaseEntities db = new CASDatabaseEntities();
List <DrugDataModel> list = new List <DrugDataModel>();
DrugDataModel dt = new DrugDataModel();
var getDetails = from d in db.Drugs
where d.IsDeleted == false
select new
{
d.DrugName,
d.Manufacturer,
d.Substitutions,
d.Uses,
d.SideEffects,
d.NotRecommended,
d.MfgDate,
d.ExpDate,
d.QOH,
d.QOHType,
d.Price,
d.DiscountAmount,
};
foreach (var item in getDetails)
{
list.Add(new DrugDataModel
{
DrugName = item.DrugName,
Manufacturer = item.Manufacturer,
Substitutions = item.Substitutions,
Uses = item.Uses,
SideEffects = item.SideEffects,
NotRecommended = item.NotRecommended,
MfgDate = item.MfgDate,
ExpDate = item.ExpDate,
QOH = item.QOH,
QOHType = item.QOHType,
Price = Convert.ToDouble(item.Price),
DiscountAmount = Convert.ToDouble(item.DiscountAmount),
});
}
dt.ListDrugs = list;
return(View(dt));
}
public ActionResult ViewDrugs()
{
CASDatabaseEntities db = new CASDatabaseEntities();
List <DrugDataModel> list = new List <DrugDataModel>();
DrugDataModel dt = new DrugDataModel();
var getDetails = from d in db.Drugs
select new
{
d.DrugID,
d.DrugName,
d.Manufacturer,
d.MfgDate,
d.ExpDate,
d.QOH,
d.QOHType,
d.Price,
d.DiscountAmount,
d.IsDeleted
};
foreach (var item in getDetails)
{
list.Add(new DrugDataModel
{
DrugID = item.DrugID,
DrugName = item.DrugName,
Manufacturer = item.Manufacturer,
MfgDate = item.MfgDate,
ExpDate = item.ExpDate,
QOH = item.QOH,
QOHType = item.QOHType,
Price = Convert.ToDouble(item.Price),
DiscountAmount = Convert.ToDouble(item.DiscountAmount),
IsDeleted = item.IsDeleted,
});
}
dt.ListDrugs = list;
return(View(dt));
}
public ActionResult EditDrugs(int?ID, DrugDataModel dt)
{
CASDatabaseEntities db = new CASDatabaseEntities();
int id = Convert.ToInt32(ID);
var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault();
if (ModelState.IsValid)
{
if (getData != null)
{
if (getData.QOH == 0 && dt.QOH > 0)
{
getData.IsDeleted = false;
}
else if (dt.QOH > 0 && dt.IsDeleted == false)
{
getData.IsDeleted = false;
}
else
{
getData.IsDeleted = true;
}
getData.DrugName = dt.DrugName;
getData.Manufacturer = dt.Manufacturer;
getData.Substitutions = dt.Substitutions;
getData.Uses = dt.Uses;
getData.SideEffects = dt.SideEffects;
getData.NotRecommended = dt.NotRecommended;
getData.MfgDate = dt.MfgDate;
getData.ExpDate = dt.ExpDate;
getData.QOH = dt.QOH;
getData.QOHType = dt.QOHType;
getData.Price = Convert.ToDecimal(dt.Price);
getData.DiscountAmount = Convert.ToDecimal(dt.DiscountAmount);
db.SaveChanges();
}
}
return(RedirectToAction("ViewDrugs", "Salesperson"));
}
