// GET: EmployeePositions
public JsonResult Index()
{
return(Json(
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.SelectAllEmployeesPositions()).GetResult(),
JsonRequestBehavior.AllowGet
));
}
public bool Delete(EmployeePosition position)
{
if (position.Id < 0)
{
return(false);
}
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.DeleteEmployeesPositions(position), true);
return(true);
}
public static SQLConnectionHandler GetInstance()
{
if (instance == null)
{
lock (syncRoot)
{
if (instance == null)
{
instance = new SQLConnectionHandler();
}
}
}
return(instance);
}
public bool Insert(EmployeePosition position)
{
SQLConnectionHandler.GetInstance()
.Execute(SQLCommand.InsertEmployeesPositions(position), true);
return(true);
}
