public ActionResult Add(int id)
{
AddWorkspaceView workspace = new AddWorkspaceView();
workspace.fk_Factoryid_Factory = id;
return(View(workspace));
}
//public bool AddNewWorkSpace(AddWorkspaceView WorkSpaceView)
//{
//}
public void PopulateSelections(AddWorkspaceView WorkSpaceView)
{
var factories = factoryrepos.GetAllFactories();
List <SelectListItem> selectListFactories = new List <SelectListItem>();
List <SelectListGroup> groups = new List <SelectListGroup>();
bool yra = false;
foreach (var item in factories)
{
selectListFactories.Add(new SelectListItem()
{
Value = Convert.ToString(item.id_Factory)
});
}
}
public bool AddNewWorkSpace(AddWorkspaceView WorkSpaceView)
{
string connStr = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(connStr);
string sqlQuery = "INSERT INTO workspace (`name`, `description`, `fk_Factoryid_Factory`) VALUES (?name, ?description, ?fk_Factoryid_Factory)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlQuery, mySqlConnection);
mySqlCommand.Parameters.Add("?name", MySqlDbType.VarChar).Value = WorkSpaceView.name;
mySqlCommand.Parameters.Add("?description", MySqlDbType.Int32).Value = WorkSpaceView.description;
mySqlCommand.Parameters.Add("?fk_Factoryid_Factory", MySqlDbType.Int32).Value = WorkSpaceView.fk_Factoryid_Factory;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
public bool addWorkspace(AddWorkspaceView model)
{
List <FactoryListView> Factories = new List <FactoryListView>();
string connStr = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(connStr);
string sqlQuery = @"INSERT INTO `workspace`(`name`, `description`, `id_Workspace`, `fk_Factoryid_Factory`) VALUES
(?name,?description,NULL, ?fk_Factoryid_Factory)";
MySqlCommand mySqlCommand = new MySqlCommand(sqlQuery, mySqlConnection);
mySqlCommand.Parameters.Add("?name", MySqlDbType.VarChar).Value = model.name;
mySqlCommand.Parameters.Add("?description", MySqlDbType.VarChar).Value = model.description;
mySqlCommand.Parameters.Add("?fk_Factoryid_Factory", MySqlDbType.Int32).Value = model.fk_Factoryid_Factory;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
public ActionResult Add(AddWorkspaceView model)
{
factoryrepos.addWorkspace(model);
return(RedirectToAction("Index"));
}
