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