//dodawanie nowego skryptu
public bool AddNewScript(Script script)
{
string query = "INSERT INTO Script VALUES(@UserID, @DateOfCreate, @Path, @NameOfProject, @TypeOfDb, (SELECT Id FROM InstanceOfDb WHERE Name = @name), @UniqueName, @Version)";
string query2 = "INSERT INTO ListOfScript VALUES(@UserID, (SELECT Id FROM Script WHERE UniqueName = @UniqueName))";
query += query2;
SqlCommand cmd = new SqlCommand(query, con);
script.Path = "C:\\Praca inzynierska\\Projekt\\Pliki\\" + script.UniqueName;
cmd.Parameters.AddWithValue("@UserID", script.UserID);
cmd.Parameters.AddWithValue("@DateOfCreate", script.DateOfCreate);
cmd.Parameters.AddWithValue("@Path", script.Path);
cmd.Parameters.AddWithValue("@NameOfProject", script.NameOfProject);
cmd.Parameters.AddWithValue("@TypeOfDb", script.TypeOfDb);
cmd.Parameters.AddWithValue("@name", script.InstOfDb.Name);
cmd.Parameters.AddWithValue("@UniqueName", script.UniqueName);
cmd.Parameters.AddWithValue("@Version", script.Version);
int rows = cmd.ExecuteNonQuery();
if (rows == 2)
{
File file = new File();
if (file.CreateFile(script.Path, script.Content))
return true;
else
return false;
}
else
return false;
}
public PartialViewResult ScriptInfo(int id)
{
Script sc = new Script();
SQL sql = new SQL();
sql.Connect();
sc = sql.ReturnScriptByID(id);
sc.InOfDb = sql.ReturnNameOfInstance(sc.InstOfDb.ID);
File file = new File();
sc.Content = file.ReturnContentOfScript(sc.Path);
sql.Close();
return PartialView("_ScriptInfo", sc);
}
//usuwanie skryptu
public ActionResult RemoveScript(int id)
{
Script sc = new Script();
SQL sql = new SQL();
sql.Connect();
sc = sql.ReturnScriptByID(id);
sql.DeleteScriptFromList(sc.ID);
File f = new File();
f.RemoveFile(sc.Path);
sql.DeleteScriptFromScript(sc.ID);
//AccountVM vm = new AccountVM(User.Identity.Name);
User user = sql.ReturnUserByName(User.Identity.Name);
AccountVM vm = new AccountVM(user);
sql.Close();
return View("Account", vm);
}