public Project GetProj(string projectName) { RetrieveTables(); // get a fresh copy of the database tables before every query to prevent errors Project fetchedProject = new Project(); try { var fetchedProjectRow = from Row in ProjectTable.AsEnumerable() where Row.Field <string>("projectName") == projectName select Row; if (fetchedProjectRow.AsEnumerable().Count() == 0) // project not found { return(null); } fetchedProject.defconScale = (from Row in ProjectTable.AsEnumerable() where Row.Field <string>("projectName") == projectName select Row.Field <int>("defconScale")).ToList().ElementAt(0); fetchedProject.dueDate = (from Row in ProjectTable.AsEnumerable() where Row.Field <string>("projectName") == projectName select Row.Field <DateTime>("dueDate")).ToList().ElementAt(0); fetchedProject.projectName = projectName; } catch (SqlException e) { return(null); } return(fetchedProject); }
public IHttpActionResult PostProjectTable(ProjectTable projectTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ProjectTables.Add(projectTable); try { db.SaveChanges(); } catch (DbUpdateException) { if (ProjectTableExists(projectTable.ProjectId)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = projectTable.ProjectId }, projectTable)); }
public int RemoveProj(string projectName) { RetrieveTables(); // get a fresh copy of the database tables before every query to prevent errors try { // check if the user is already gone List <string> fetchedProjNames = (from Column in ProjectTable.AsEnumerable() // pulls existing usernames select Column.Field <string>("projectName")).ToList(); if (fetchedProjNames.Contains(projectName)) { string query = "DELETE FROM Project WHERE projectName = '" + projectName + "';"; ExecuteSQLCommand(query); return(0); } else { return(0); } } catch (SqlException e) { return(-1); } }
public TenantController(UserTable userTable, UserManager <User> userMgr, ProjectTable projectTable, NotificationTable notificationTable) { _userTable = userTable; _userMgr = userMgr; _projectTable = projectTable; _notificationTable = notificationTable; }
public HomePageController(UserTable userTable, ProjectTable projectTable, TenantTable tenantTable, ServiceOrderTable serviceOrderTable) { _userTable = userTable; _projectTable = projectTable; _tenantTable = tenantTable; _serviceOrderTable = serviceOrderTable; }
public void RetrieveTables() // public for testing { using (SqlConnection serverConnection = new SqlConnection(conString)) { string query = "select * from Project"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { ProjectTable.Clear(); // create data adapter to read table into DataTable object using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(ProjectTable); } query = "select * from [User]"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { UserTable.Clear(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(UserTable); } query = "select * from Task"; using (SqlCommand cmd = new SqlCommand(query, serverConnection)) { TaskTable.Clear(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) da.Fill(TaskTable); } } }
public bool Update(int projectId, ProjectTable projects) { try { var query = (from update in db.Projects.Where(x => x.ProjectId == projectId) select update).SingleOrDefault(); if (query != null) { query.ProjectId = projectId; query.ProjectName = projects.ProjectName; query.StartDate = projects.StartDate; query.EndDate = projects.EndDate; query.Priority = projects.Priority; query.UserId = projects.UserId; db.Entry(query).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception) { return(false); } return(true); }
public async Task <IActionResult> PutProjectTable([FromBody] ProjectTable projectTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } projectTable.SyncStatus = true; projectTable.RowVersion = _context.ProjectTable .Select(p => p.RowVersion) .DefaultIfEmpty(0) .Max() + 1; _context.Entry(projectTable).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProjectTableExists(projectTable.Name)) { return(NotFound()); } else { throw; } } return(Ok(projectTable.RowVersion)); }
public IHttpActionResult PutProjectTable(int id, ProjectTable projectTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != projectTable.ProjectId) { return(BadRequest()); } db.Entry(projectTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProjectTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// Execute public override object InternalExecute(Program program) { if (EqualitySorts != null) { ProjectTableMap table = new ProjectTableMap(this, program); try { table.Open(); return(table); } catch { table.Dispose(); throw; } } else { ProjectTable table = new ProjectTable(this, program); try { table.Open(); return(table); } catch { table.Dispose(); throw; } } }
public Form1() { InitializeComponent(); var keyval1 = new KeyValue("key1", "1"); var keyval1_2 = new KeyValue("key1", "2"); var keyval2 = new KeyValue("key2", 7); var keyval2_2 = new KeyValue("key2", 8); var keyValueSchema = new KeyValueSchema("key1", typeof(string).ToString(), new List <KeyValue> { keyval1, keyval1_2 }); var keyValueSchema2 = new KeyValueSchema("key2", typeof(int).ToString(), new List <KeyValue> { keyval1, keyval1_2 }); var row = new Row("p1", "p2", "p3", new List <KeyValue> { keyval1, keyval2 }); var row2 = new Row("p4", "p5", "p6", new List <KeyValue> { keyval1_2, keyval2_2 }); var proj = new ProjectTable("t1", new List <Row> { row, row2 }, new List <KeyValueSchema> { keyValueSchema, keyValueSchema2 }); }
public int SetProjectDefconLevel(string projectName, int newLevel) // sets the new level passed. The newLevel is NOT additive { RetrieveTables(); // get a fresh copy of the database tables before every query to prevent errors try { // check if the user is already gone List <string> fetchedProjNames = (from Column in ProjectTable.AsEnumerable() // pulls existing usernames select Column.Field <string>("projectName")).ToList(); if (fetchedProjNames.Contains(projectName)) { string query = "UPDATE Project SET defconScale = " + newLevel + " WHERE projectName = '" + projectName + "';"; ExecuteSQLCommand(query); return(0); } else { return(0); } } catch (SqlException e) { return(-1); } }
public ServiceController(ServiceOrderTable serviceOrderTable, TenantTable tenantTable, ProjectTable projectTable, UserTable userTable, PaymentTable paymentTable) { _serviceOrderTable = serviceOrderTable; _tenantTable = tenantTable; _projectTable = projectTable; _userTable = userTable; _paymentTable = paymentTable; }
public ActionResult DeleteConfirmed(int id) { ProjectTable projectTable = db.ProjectTables.Find(id); db.ProjectTables.Remove(projectTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public NotificationController(ServiceOrderTable serviceOrderTable, TenantTable tenantTable, UserTable userTable, NotificationTable notificationTable, ProjectTable projectTable) { _serviceOrderTable = serviceOrderTable; _tenantTable = tenantTable; _userTable = userTable; _notificationTable = notificationTable; _projectTable = projectTable; }
public IHttpActionResult GetProjectTable(int id) { ProjectTable projectTable = db.ProjectTables.Find(id); if (projectTable == null) { return(NotFound()); } return(Ok(projectTable)); }
public ActionResult Edit([Bind(Include = "project_id,title,user_id")] ProjectTable projectTable) { if (ModelState.IsValid) { projectTable.user_id = db.AspNetUsers.Where(x => x.UserName == User.Identity.Name).FirstOrDefault().Id; db.Entry(projectTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.user_id = new SelectList(db.AspNetUsers, "Id", "Email", projectTable.user_id); return(View(projectTable)); }
public void Destroy(projectViewModle db) { var entity = new ProjectTable(); entity.ProjectID = db.ProjectID; entities.ProjectTable.Attach(entity); entities.ProjectTable.Remove(entity); entities.SaveChanges(); }
public bool Add(ProjectTable projects) { try { db.Projects.Add(projects); db.SaveChanges(); } catch (Exception) { return(false); } return(true); }
public ResourceManagerDatabaseSchema(string databaseLocation, SqlSchemaVerifier schemaVerifier) : base(databaseLocation, schemaVerifier) { ProjectTable = new ProjectTable(this); PersonTable = new PersonTable(this); WeeklyScheduleTable = new WeeklyScheduleTable(this); ResourceBlockTable = new ResourceBlockTable(this); SqlTables.Add(ProjectTable); SqlTables.Add(PersonTable); SqlTables.Add(WeeklyScheduleTable); SqlTables.Add(ResourceBlockTable); }
// GET: Projects/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProjectTable projectTable = db.ProjectTables.Find(id); if (projectTable == null) { return(HttpNotFound()); } return(View(projectTable)); }
public IHttpActionResult DeleteProjectTable(int id) { ProjectTable projectTable = db.ProjectTables.Find(id); if (projectTable == null) { return(NotFound()); } db.ProjectTables.Remove(projectTable); db.SaveChanges(); return(Ok(projectTable)); }
// GET: Projects/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProjectTable projectTable = db.ProjectTables.Find(id); if (projectTable == null) { return(HttpNotFound()); } ViewBag.user_id = new SelectList(db.AspNetUsers, "Id", "Email", projectTable.user_id); return(View(projectTable)); }
public JsonResult GetSparkLineChartData() { var dataBar = new List <Object[]>(); var projectStat = new ProjectTable(); foreach (var item in db.Tickets.Where(s => s.TicketStatusId != 5).ToList()) { dataBar.Add(new Object[] { item.TicketAttachments.Count() }); } return(Json(dataBar)); }
public IHttpActionResult UpdateProject(ProjectTable projects) { if (ModelState.IsValid) { try { bl.Update(projects.ProjectId, projects); } catch (Exception) { return(Ok("Error is occured during updated !")); } return(Ok("Record is updated Sucessfully !")); } return(Ok()); }
public JsonResult GetBarChartData() { var dataBar = new List <Object[]>(); var projectStat = new ProjectTable(); foreach (var item in db.Tickets.Where(s => s.TicketStatusId != 5).GroupBy(p => p.TicketPriorityId).Select(data => new { Id = data.Key, RecordCount = data.Count().ToString() }).ToList()) { dataBar.Add(new Object[] { db.TicketPriorities.Find(item.Id).Name, item.RecordCount }); } return(Json(dataBar)); }
// GET: AjaxDonutChartData public JsonResult GetDonutChartData() { var projectStat = new ProjectTable(); var dataChart = new List <MorrisChartData>(); foreach (var item in db.Projects.GroupBy(p => p.ProjectStatusId).Select(data => new { Id = data.Key, RecordCount = data.Count().ToString() }).Where(s => s.Id != 4).ToList()) { dataChart.Add(new MorrisChartData { label = db.ProjectStatuses.Find(item.Id).Status, value = item.RecordCount }); } return(Json(dataChart)); }
public string ProjectName() { int H = 0; H = int.Parse(Session["ProId"].ToString()); using (IndividualCounselingEntities entities = new IndividualCounselingEntities()) { ProjectTable xx = entities.ProjectTable.Where(c => c.ProjectID == H) .Select(i => i).Single(); ViewBag.ProjectName = xx.ProjectName.ToString(); } return(ViewBag.ProjectName); }
public void Update(projectViewModle db) { var entity = new ProjectTable(); entity.ProjectID = db.ProjectID; entity.ProjectName = db.ProjectName; entity.StartDate = db.StartDate.Date; entity.EndDate = db.EndDate.Date; entity.Description = db.Description; entity.Status = db.Status; entities.ProjectTable.Attach(entity); entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); }
public IHttpActionResult AddProject(ProjectTable projects) { if (ModelState.IsValid) { try { bl.Add(projects); } catch (Exception) { return(Ok("Error is occured during inserted !")); } return(Ok("Record is added Sucessfully !")); } return(Ok()); }
public List<ProjectTable> possibleProjectsAdd(string role, int id) { List<ProjectTable> possibleProjects = db.ProjectTables.ToList(); foreach (JunctionTableProjectAndAccountV2 junc in db.JunctionTableProjectAndAccountV2.ToList()) { if(junc.AID == id && junc.Role.Contains(role)) { ProjectTable proj = new ProjectTable(); proj = db.ProjectTables.Find(junc.PId); possibleProjects.Remove(proj); } } return possibleProjects; }
public ActionResult ApplyProjects(int id, int Aid) { dynamic myModel = new ExpandoObject(); myModel.MemberTableAdd = possibleMembersAdd(id); myModel.MemberTableRemove = possibleMembersRemove(id); myModel.JunctionTableEdit = possibleMembersEdit(id); ProjectTable table = new ProjectTable(); table.ProjectId = id; myModel.ProjectTable = table; leaderTableV2 leader = new leaderTableV2(); leader.Id = Aid; myModel.leader = leader; return View("ApplyProjects", myModel); }