public ActionResult Create(list_of_diagnoses model)
{
try
{
diagnosesDAO.CreateDiagnosis(model);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{ }
return(RedirectToAction("Index"));
}
public list_of_diagnoses DetailsDiagnosis(int List_diagnoses_id)
{
List <list_of_diagnoses> listDiagnoses = new List <list_of_diagnoses>();
list_of_diagnoses list = new list_of_diagnoses();
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM list_of_diagnoses where List_diagnoses_id = @P0";
list = ctx.Database.SqlQuery <list_of_diagnoses>(query, List_diagnoses_id).ToList().First();
}
return(list);
}
public ActionResult Edit(list_of_diagnoses model)
{
try
{
int id = Convert.ToInt32(ControllerContext.RouteData.Values.Values.ElementAt(2));
diagnosesDAO.EditDiagnosis(model, id);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{ }
return(RedirectToAction("Index"));
}
public void EditDiagnosis(list_of_diagnoses model, int List_diagnoses_id)
{
using (var ctx = new PolyclinicEntities())
{
string query = "update list_of_diagnoses set Diagnose_name=@P1, Description=@P2 where List_diagnoses_id=@P0";
List <object> parameterList = new List <object> {
List_diagnoses_id,
model.Diagnose_name,
model.Description
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
public void CreateDiagnosis(list_of_diagnoses model)
{
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "INSERT INTO list_of_diagnoses (Diagnose_name, Description) VALUES(@P0, @P1)";
List <object> parameterList = new List <object> {
model.Diagnose_name,
model.Description
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
catch (Exception ex)
{ }
}
