public int Delete() { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblProject project = dc.tblProjects.Where(p => p.Id == Id).FirstOrDefault(); if (project != null) { ProjectLanguageList pll = new ProjectLanguageList(); pll.LoadByProjectId(project.Id); foreach (ProjectLanguage pl in pll) { pl.Delete(); } dc.tblProjects.Remove(project); return(dc.SaveChanges()); } else { throw new Exception("Project not found"); } } } catch (Exception ex) { throw ex; } }
// Inserts project without portfolio public void Insert(Guid userId) { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblProject project = new tblProject() { Id = Guid.NewGuid(), Name = Name, Location = Location, Filepath = Filepath, PrivacyId = PrivacyId, Image = Image, Description = Description, UserId = userId, DateCreated = DateCreated, Purpose = Purpose, Environment = Environment, Challenges = Challenges, FuturePlans = FuturePlans, Collaborators = Collaborators, LastUpdated = LastUpdated, SoftwareUsed = SoftwareUsed, StatusId = StatusId }; dc.tblProjects.Add(project); dc.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public IHttpActionResult put(tblProject item) { ProjectBL obj = new ProjectBL(); obj.Updateproject(item); return(Ok("Record Updated")); }
protected string addProjectVersionArticle(projectVersionEditViewModel viewModel, SASDdbContext db) { string ret; tblArticle ta = new tblArticle(db); tblProject tp = new tblProject(); string projectName = tp.nameById(viewModel.editModel.projectId.ToString()); article prjArticle = ta.GetByProjectId(viewModel.editModel.projectId.ToString()); article pva = new article(); pva.articleId = (Guid)viewModel.editModel.versionArticleId; pva.createtime = DateTime.Now; pva.articleTitle = $"project {projectName} version " + $"{viewModel.editModel.version}"; pva.articleHtmlContent = string.Format(@" <h1>{0} version {1}</h1> <p>{2}</p> ", projectName, viewModel.editModel.version, viewModel.editModel.versionDescription); pva.articleContent = string.Format("{0} {1} {2}" , projectName, viewModel.editModel.version , viewModel.editModel.versionDescription); pva.isDir = true; pva.belongToArticleDirId = prjArticle.articleId; pva.articleType = ARTICLE_TYPE.Project.ToString(); pva.articleStatus = ARTICLE_STATUS.New.ToString(); pva.priority = 1; pva.projectId = viewModel.editModel.projectId; ret = ta.Add(pva); ret += ta.SaveChanges(); return(ret); }
public async Task <IHttpActionResult> PuttblProject(int id, tblProject tblProject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblProject.Project_ID) { return(BadRequest()); } db.Entry(tblProject).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tblProjectExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// method for deleting the project /// </summary> private void DeleteProjectExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { int id = project.ProjectID; // checking the action MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure you want to delete the project?", "Delete Confirmation", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { tblProject projectToDelete = (from x in context.tblProjects where x.ProjectID == id select x).First(); // deleting the project context.tblProjects.Remove(projectToDelete); context.SaveChanges(); // updating the list ProjectList = GetAllProjects().ToList(); MessageBox.Show("The project deleted successfully."); // logging the action FileActions.FileActions.Instance.Deleting(FileActions.FileActions.path, FileActions.FileActions.actions, "project", projectToDelete.ProjectName); } } } catch (Exception) { MessageBox.Show("The project can not be deleted, please try again."); } }
public void UpdateTask(tblTask taskitem) { try { using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities()) { tblTask taskupdate = db1.tblTasks.SingleOrDefault(x => x.TaskId == taskitem.TaskId); tblProject projectupdate = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskupdate.ProjectId); projectupdate.Nooftasks = projectupdate.Nooftasks - 1; taskupdate.TaskName = taskitem.TaskName; taskupdate.TStartDate = taskitem.TStartDate; taskupdate.TEndDate = taskitem.TEndDate; taskupdate.TPriority = taskitem.TPriority; taskupdate.TStatus = taskitem.TStatus; taskupdate.ParentId = taskitem.ParentId; taskupdate.ProjectId = taskitem.ProjectId; taskupdate.UserId = taskitem.UserId; taskupdate.ParentTaskName = taskitem.ParentTaskName; tblProject projectupdate1 = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskitem.ProjectId); projectupdate1.Nooftasks = projectupdate1.Nooftasks + 1; db1.SaveChanges(); } } catch { } }
public IHttpActionResult PutProjects(int id, tblProject project) { if (id != project.ID) { return(BadRequest()); } db.Entry(project).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProjectExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// Select Project Command through command interface /// </summary> private void SelectProject(Object p) { ProjectModel selectedProject = GetProject((int)p); Globals.Project_ID = (int)p; Globals.ProjectSelected = true; ProjectSelected = true; Globals.ProjectName = selectedProject.ProjectName; Globals.ContractNo = selectedProject.ContractNo; selectedProject.LastOpened = DateTime.Now; // Store the current DateTime in the selected project record so it can be used to sort the project list EDBEntities eDB = new EDBEntities(); tblProject Rec = eDB.tblProjects.Where(o => o.ID == selectedProject.ID).FirstOrDefault(); Rec.LastOpened = selectedProject.LastOpened; Rec.LastOpenedBy = Environment.UserName; eDB.SaveChanges(); IsBackStageOpen = false; MainTitle = Globals.ContractNo + Globals.ProjectName; TypeViewModelLocator.GetTypeVM(); ObjectViewModelLocator.GetObjectVM(); TemplateViewModelLocator.GetTemplateVM(); PropertyViewModelLocator.GetPropertyVM(); AspectViewModelLocator.GetAspectVM(); AttributeViewModelLocator.GetAttributeVM(); ObjectAssociationViewModelLocator.GetObjectAssociationVM(); ObjectRequirementViewModelLocator.GetObjectRequirementVM(); TemplateAssociationViewModelLocator.GetTemplateAssociationVM(); TemplateRequirementViewModelLocator.GetTemplateRequirementVM(); }
public IHttpActionResult post(tblProject item) { ProjectBL obj = new ProjectBL(); obj.AddProject(item); return(Ok("Record added")); }
public ActionResult EditProject(tblProject model, List <HttpPostedFileBase> listImage) { foreach (var item in listImage) { if (item == null) { continue; } var newName = item.FileName.Insert(item.FileName.LastIndexOf('.'), $"{DateTime.Now:_ddMMyyyy}"); var path = Server.MapPath("/Uploads/News/" + newName); item.SaveAs(path); var image = new tblImage { Image = newName, URL = "/Uploads/News/" + newName, ProjectId = model.Id, DictionaryId = 47 }; db.tblImage.Add(image); } db.Entry(model).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
protected void rptTaskFile_ItemCommand(object source, RepeaterCommandEventArgs e) { try { var DC = new DataClassesDataContext(); if (e.CommandName == "Download") { tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(e.CommandArgument)); tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID); tblProject ProjectData = DC.tblProjects.Single(ob => ob.ProjectID == ModuleData.ProjectID); Response.Clear(); Response.ContentType = "application/zip"; Response.AddHeader("content-disposition", "filename=" + ProjectData.Title + "_" + ModuleData.Title + "_" + TaskData.Title + ".zip"); using (ZipFile zip = new ZipFile()) { zip.AddDirectory(Server.MapPath("UploadTaskFile/") + @TaskData.SubmittedFile); zip.Save(Response.OutputStream); } } } catch (Exception ex) { int session = Convert.ToInt32(Session["EmpID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
public ActionResult DeleteConfirmed(int id) { tblProject tblProject = db.tblProjects.Find(id); db.tblProjects.Remove(tblProject); db.SaveChanges(); return(RedirectToAction("Index")); }
public void DeleteProject(int Id) { using (FinalSBADBEntities db1 = new FinalSBADBEntities()) { tblProject ts = db1.tblProjects.Where(d => d.ProjectId == Id).FirstOrDefault(); db1.tblProjects.Remove(ts); db1.SaveChanges(); } }
protected void btnAssignProject_Click(object sender, EventArgs e) { try { var DC = new DataClassesDataContext(); foreach (RepeaterItem item in rptEmployeeList.Items) { RadioButton rd = (RadioButton)item.FindControl("rdEmployee"); if (rd.Checked) { EmpID = Convert.ToInt32(rd.Text); } } //Assign Project Manager bool acknow = ProjectObject.AssignProject(ProjectID, EmpID, Convert.ToInt32(Session["AdminID"])); //ProjectName tblProject ProjectName = (from ob in DC.tblProjects where ob.ProjectID == ProjectID select ob).Single(); //Notification tblNotification Notification = new tblNotification(); Notification.Title = "Assign Project Manager"; Notification.Description = "You are selected Project Manager for" + " " + ProjectName.Title; Notification.CreatedOn = DateTime.Now; Notification.CreatedBy = Convert.ToInt32(Session["AdminID"]); DC.tblNotifications.InsertOnSubmit(Notification); DC.SubmitChanges(); tblNotification NID = (from obID in DC.tblNotifications orderby obID.NotificationID descending select obID).First(); tblNotificationDetail Detail = new tblNotificationDetail(); Detail.NotificationID = NID.NotificationID; Detail.PersonID = EmpID; Detail.IsAdmin = false; Detail.IsRead = false; Detail.IsNotify = false; DC.tblNotificationDetails.InsertOnSubmit(Detail); DC.SubmitChanges(); Response.Redirect("ViewProject.aspx"); //Response.Write(acknow); } catch (Exception ex) { int session = Convert.ToInt32(Session["AdminID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
public ActionResult Edit([Bind(Include = "Project_ID,Customer_Name,Creation_Date,Application,Total_Cost,Status,Quotation_Link,PaymentAgreement_Link,Priority,Created_by,Payments,Agreement_Status,Project_Title")] tblProject tblProject) { if (ModelState.IsValid) { db.Entry(tblProject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblProject)); }
public async Task <IHttpActionResult> GettblProject(int id) { tblProject tblProject = await db.tblProjects.FindAsync(id); if (tblProject == null) { return(NotFound()); } return(Ok(tblProject)); }
public void AddProject(tblProject item) { using (FinalSBADBEntities db1 = new FinalSBADBEntities()) { item.Nooftasks = 0; item.completed = 0; item.Pstatus = false; db1.tblProjects.Add(item); db1.SaveChanges(); } }
public async Task <IHttpActionResult> PosttblProject(tblProject tblProject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblProjects.Add(tblProject); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = tblProject.Project_ID }, tblProject)); }
public FacilityViewModal(int locid) { _locid = locid; _tblBuildingSystem = new tblBuildingSystem(); _tblProject = new tblProject(); _tblServiceContract = new tblServiceContract(); BuildingSystemList = _tblBuildingSystem.GetAll(); ProjectList = _tblProject.GetAll(); ServiceContractList = _tblServiceContract.GetAll(); }
public void LoadById() { using (PortfolioEntities dc = new PortfolioEntities()) { //This is Test guid from CreateNewProject (all string inputs are "111", user is joe@wetzel) Guid projectGuid = Guid.Parse("797c8d2b-d1ba-4bba-825d-eb28bab26cf8"); tblProject project = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid); Assert.AreEqual("111", project.Description); } }
public void DeleteProject(int Id) { try { using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities()) { tblProject ts = db1.tblProjects.Where(d => d.ProjectId == Id).FirstOrDefault(); db1.tblProjects.Remove(ts); db1.SaveChanges(); } } catch { } }
public OperationStatus AddNewProject(ProjectCustomModel objProjectModel) { OperationStatus status = OperationStatus.Error; try { using (dbcontext = new ResourceManagementEntities()) { if (objProjectModel.ProjectId == 0) { var rs = dbcontext.tblProjects.FirstOrDefault(x => x.Title == objProjectModel.Title && x.IsDeleted == false); if (rs == null) { tblProject _addProject = new tblProject { Title = objProjectModel.Title, Description = objProjectModel.Description, Documents = objProjectModel.Documents, Image = objProjectModel.Image, AlliasName = objProjectModel.AlliasName, ProjectType = objProjectModel.ProjectType, StartDate = objProjectModel.StartDate, EndDate = objProjectModel.EndDate, IsActive = true, IsDeleted = false, CreatedDate = DateTime.Now, CreatedBy = objProjectModel.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = objProjectModel.ModifiedBy, }; dbcontext.tblProjects.Add(_addProject); dbcontext.SaveChanges(); status = OperationStatus.Success; } else { status = OperationStatus.Duplicate; } } } } catch (Exception ex) { dbcontext.Dispose(); status = OperationStatus.Exception; throw ex; } return(status); }
public IHttpActionResult DeleteProject(int id) { tblProject objProject = db.tblProjects.Find(id); if (objProject == null) { return(NotFound()); } db.tblProjects.Remove(objProject); db.SaveChanges(); return(Ok(objProject)); }
public async Task <IHttpActionResult> DeletetblProject(int id) { tblProject tblProject = await db.tblProjects.FindAsync(id); if (tblProject == null) { return(NotFound()); } db.tblProjects.Remove(tblProject); await db.SaveChangesAsync(); return(Ok(tblProject)); }
// GET: Projects/Delete/6 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblProject tblProject = db.tblProjects.Find(id); if (tblProject == null) { return(HttpNotFound()); } return(View(tblProject)); }
public void AddProject(tblProject item) { using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities()) { try { item.Nooftasks = 0; item.completed = 0; item.PStatus = false; db1.tblProjects.Add(item); db1.SaveChanges(); } catch { }; } }
public static SelectList projectList() { List <SelectListItem> _prjLst = new List <SelectListItem>(); tblProject tp = new tblProject(); List <project> prjs = tp.getAll().ToList(); foreach (project p in prjs) { _prjLst.Add(new SelectListItem() { Text = p.projectName, Value = p.projectId.ToString() }); } return(new SelectList(_prjLst, "Value", "Text", null)); }
protected void lnkTaskFile_Click(object sender, EventArgs e) { var DC = new DataClassesDataContext(); tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(ltrTaskID.Text)); tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID); tblProject ProjectData = DC.tblProjects.Single(ob => ob.ProjectID == ModuleData.ProjectID); Response.Clear(); Response.ContentType = "application/zip"; Response.AddHeader("content-disposition", "filename=" + ProjectData.Title + "_Supporting_TaskFile" + ".zip"); using (ZipFile zip = new ZipFile()) { zip.AddDirectory(Server.MapPath("UploadFiles/") + @hdnTaskFile.Value); zip.Save(Response.OutputStream); } }
public void DeleteTest() { using (PortfolioEntities dc = new PortfolioEntities()) { Guid projectGuid = Guid.Parse("11112222-3333-4444-5555-666677778888"); tblProject project = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid); dc.tblProjects.Remove(project); dc.SaveChanges(); tblProject deletedProject = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid); Assert.IsNull(deletedProject); } }
/// <summary> /// InsertVolunteerContext - Will insert a record into Volunteer table via SProc /// </summary> /// <param name="_cVolunteer"></param> public sp_Project_DM InsertProjectContext(ref sp_Project_DM _cProject) { using (VolTeerEntities context = new VolTeerEntities()) { var cProject = new tblProject { ProjectID = _cProject.ProjectID, ProjectName = _cProject.ProjectName, ProjectDesc = _cProject.ProjectDesc, AddrID = _cProject.AddrID, ActiveFlg = _cProject.ActiveFlg }; context.tblProjects.Add(cProject); context.SaveChanges(); return _cProject; } }
public static tblProject CreatetblProject(int projectID, string projectName) { tblProject tblProject = new tblProject(); tblProject.ProjectID = projectID; tblProject.ProjectName = projectName; return tblProject; }
public void AddTotblProject(tblProject tblProject) { base.AddObject("tblProject", tblProject); }