public ActionResult Patch([FromBody] EditInfo info)
{
if (info.CarRequest)
{
List <int> carIds = new List <int>();
CarIds.updateCarIds(carIds);
return(Json(carIds));
}
var empty = new List <Person>();
if (Edit.editPerson(info) == false)
{
return(Json(empty));
}
if (lastFilter != null && Filter.filterPersons(lastFilter) == false)
{
return(Json(empty));
}
else if (Select.updatePersons(selectStr) == false)
{
return(Json(empty));
}
return(Json(persons));
}
public ActionResult DeleteRequest([FromBody] DeleteInfo info)
{
var empty = new List <Person>();
if (Delete.DeletePerson(info) == false)
{
return(Json(empty));
}
if (lastFilter != null && Filter.filterPersons(lastFilter) == false)
{
return(Json(empty));
}
else if (Select.updatePersons(selectStr) == false)
{
return(Json(empty));
}
return(Json(persons));
}
public ActionResult Put([FromBody] EditInfo info)
{
var empty = new List <Person>();
if (Add.addPerson(info) == false)
{
return(Json(empty));
}
if (lastFilter != null && Filter.filterPersons(lastFilter) == false)
{
return(Json(empty));
}
else if (Select.updatePersons(selectStr) == false)
{
return(Json(empty));
}
return(Json(persons));
}
public static bool DeletePerson(DeleteInfo info)
{
// query holds string for sql delete command, transaction handled
StringBuilder query = new StringBuilder("BEGIN TRANSACTION BEGIN TRY DELETE FROM OSOBY WHERE");
// records are chosend based on osoba_id which values are stored in info instance
foreach (var id in info.PersonId)
{
query.Append(string.Format(" osoba_id={0} OR", id));
}
// removing last "OR"
query.Remove(query.Length - 2, 2);
query.Append(" COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION END CATCH ");
return(Select.updatePersons(query.ToString()));
}
// handles manager login request
public static bool SaveLogin(LoginInfo info)
{
if (info.Trusted)
{
HomeController.connString = string.Format("Server={0};Database={1};Trusted_Connection=True;", info.ServerName, info.DbName);
}
else
{
HomeController.connString = string.Format("Server={0};Database={1};User Id={2};Password={3};", info.ServerName, info.DbName, info.Login, info.Password);
}
bool succ = false;
// this query is used to check if given database is available
var cmdStr = "select count(*) from master.dbo.sysdatabases where name = @database";
try
{
using (var sqlConnection = new SqlConnection(HomeController.connString))
{
using (var cmd = new SqlCommand(cmdStr, sqlConnection))
{
cmd.Parameters.Add("@database", System.Data.SqlDbType.NVarChar).Value = info.DbName;
sqlConnection.Open();
succ = Convert.ToInt32(cmd.ExecuteScalar()) == 1;
}
}
}
catch
{
succ = false;
}
// if no error happened, persons updated by default select string
return(succ && Select.updatePersons(HomeController.selectStr));
}
public ActionResult Persons()
{
Select.updatePersons(selectStr);
return(Json(persons));
}
