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