public int Update(MedicalCheckup medicalCheckup)
{
UpdateCommand.Parameters["@ID"].Value = medicalCheckup.ID;
UpdateCommand.Parameters["@ItemName"].Value = medicalCheckup.ItemName;
UpdateCommand.Parameters["@CompanyID"].Value = medicalCheckup.CompanyID;
UpdateCommand.Parameters["@MMK"].Value = medicalCheckup.MMK;
UpdateCommand.Parameters["@USD"].Value = medicalCheckup.USD;
UpdateCommand.Parameters["@CheckList"].Value = medicalCheckup.CheckList;
UpdateCommand.Parameters["@Status"].Value = medicalCheckup.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
public int Insert(MedicalCheckup medicalCheckup)
{
InsertCommand.Parameters["@ItemName"].Value = medicalCheckup.ItemName;
InsertCommand.Parameters["@CompanyID"].Value = medicalCheckup.CompanyID;
InsertCommand.Parameters["@MMK"].Value = medicalCheckup.MMK;
InsertCommand.Parameters["@USD"].Value = medicalCheckup.USD;
InsertCommand.Parameters["@CheckList"].Value = medicalCheckup.CheckList;
InsertCommand.Parameters["@Status"].Value = medicalCheckup.Status;
int returnValue = -1;
try
{
InsertCommand.Connection.Open();
returnValue = (int)InsertCommand.ExecuteScalar();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
InsertCommand.Connection.Close();
}
return(returnValue);
}
public ActionResult DeleteConfirmed(int id)
{
MedicalCheckup medicalcheckup = db.MedicalCheckups.Find(id);
db.MedicalCheckups.Remove(medicalcheckup);
db.SaveChanges();
return(RedirectToAction("Details", "MedicalTreatment"));
}
//
// GET: /MedicalCheckup/Details/5
public ActionResult Details(int id = 0)
{
MedicalCheckup medicalcheckup = db.MedicalCheckups.Find(id);
if (medicalcheckup == null)
{
return(HttpNotFound());
}
return(View(medicalcheckup));
}
public ActionResult Edit(MedicalCheckup medicalcheckup)
{
if (ModelState.IsValid)
{
db.Entry(medicalcheckup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "MedicalTreatment"));
}
ViewBag.MedicalTreatmentId = new SelectList(db.MedicalTreatments, "MedicalTreatmentId", "Diagnosis", medicalcheckup.MedicalTreatmentId);
return(View(medicalcheckup));
}
//
// GET: /MedicalCheckup/Edit/5
public ActionResult Edit(int id = 0)
{
MedicalCheckup medicalcheckup = db.MedicalCheckups.Find(id);
if (medicalcheckup == null)
{
return(HttpNotFound());
}
ViewBag.MedicalTreatmentId = new SelectList(db.MedicalTreatments, "MedicalTreatmentId", "Diagnosis", medicalcheckup.MedicalTreatmentId);
return(View(medicalcheckup));
}
public ActionResult Create(MedicalCheckup medicalcheckup)
{
if (ModelState.IsValid)
{
db.MedicalCheckups.Add(medicalcheckup);
db.SaveChanges();
return(RedirectToAction("Details", "MedicalTreatment"));
}
ViewBag.MedicalTreatmentId = new SelectList(db.MedicalTreatments, "MedicalTreatmentId", "Diagnosis", medicalcheckup.MedicalTreatmentId);
return(View(medicalcheckup));
}
private MedicalCheckup DataTableToEntity(DataTable dt)
{
MedicalCheckup medicalCheckup = new MedicalCheckup();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
medicalCheckup.ID = Convert.ToInt32(dr["ID"]);
}
else
{
medicalCheckup.ID = 0;
}
if (Null.IsNotNull(dr["ItemName"]))
{
medicalCheckup.ItemName = Convert.ToString(dr["ItemName"]);
}
else
{
medicalCheckup.ItemName = string.Empty;
}
if (Null.IsNotNull(dr["CompanyID"]))
{
medicalCheckup.CompanyID = Convert.ToInt32(dr["CompanyID"]);
}
else
{
medicalCheckup.CompanyID = 0;
}
if (Null.IsNotNull(dr["MMK"]))
{
medicalCheckup.MMK = Convert.ToDecimal(dr["MMK"]);
}
else
{
medicalCheckup.MMK = 0.00m;
}
if (Null.IsNotNull(dr["USD"]))
{
medicalCheckup.USD = Convert.ToDecimal(dr["USD"]);
}
else
{
medicalCheckup.USD = 0.00m;
}
if (Null.IsNotNull(dr["CheckList"]))
{
medicalCheckup.CheckList = Convert.ToString(dr["CheckList"]);
}
else
{
medicalCheckup.CheckList = string.Empty;
}
if (Null.IsNotNull(dr["Status"]))
{
medicalCheckup.Status = Convert.ToString(dr["Status"]);
}
else
{
medicalCheckup.Status = string.Empty;
}
}
}
return(medicalCheckup);
}
//
// GET: /MedicalCheckup/Create
public ActionResult Create()
{
var medicalcheckup = new MedicalCheckup();
return(View(medicalcheckup));
}
