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);
}
