public messageModel update(projectModel value)
{
messageModel result = new messageModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
int ret = context.sp_project_update_v2(value.prj_id, value.prj_name, value.start_date, value.stop_date, value.prj_detail, value.prj_status, userId);
}
result.status = "S";
result.message = "";
}
catch (Exception ex)
{
result.status = "E";
result.message = ex.Message.ToString();
}
return(result);
}
private void btnDelete_Click(object sender, EventArgs e)
{
string project = txtProject.Text;
if (project != "")
{
projectModel projectMod = new projectModel();
ProjectController projControll = new ProjectController();
projectMod.ProjectId = Convert.ToInt32(projectList.CurrentRow.Cells[0].Value.ToString());
Boolean projectAdded = projControll.AddProject(projectMod);;
if (projectAdded)
{
MessageBox.Show("Project successfully Deleted!");
makeFieldsBlank();
this.Close();
}
else
{
MessageBox.Show("Unable to Delete Project!");
}
}
else
{
MessageBox.Show("Project field is empty!");
txtProject.Focus();
}
}
// GET api/<controller>/5
public List <itemDeployedModel> Get(int id)
{
IoTDatabaseDataContext db = new IoTDatabaseDataContext();
List <itemDeployedModel> items = new List <itemDeployedModel>();
List <ItemDeployed> list = (from item in db.ItemDeployeds
where id == item.deployedID
select item).ToList();
foreach (ItemDeployed item in list)
{
projectModel newProject = new projectModel(item.Project.projectName);
typeModel newType = new typeModel(item.Item.SubType.Type.typeID, item.Item.SubType.Type.typeName);
subTypeModel newSubType = new subTypeModel(item.Item.SubType.subTypeID, newType, item.Item.SubType.subTypeName, item.Item.SubType.description);
itemModel itemModel = new itemModel(item.itemID, newSubType, item.Item.itemNote);
itemDeployedModel newDeploy = new itemDeployedModel(newProject, itemModel, item.location, item.date.ToString(), item.notes);
items.Add(newDeploy);
}
return(items);
}
// POST: api/project
public HttpResponseMessage Post([FromBody] projectModel value)
{
if (value == null)
{
return(null);
}
JavaScriptSerializer js = new JavaScriptSerializer();
projectService service = new projectService();
HttpResponseMessage response = null;
Object result = null;
switch (value.method)
{
case "master":
result = service.master(value);
break;
case "search":
result = service.search(value);
break;
case "detail":
result = service.detail(value);
break;
case "insert":
result = service.insert(value);
break;
case "update":
result = service.update(value);
break;
//case "delete":
// result = service.delete(value);
// break;
default:
break;
}
string json = js.Serialize(result);
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
return(response);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string project = txtProject.Text;
string createdDate = txtCreatedDate.Text;
string enddate = txtEndDate.Text;
if (!string.IsNullOrEmpty(project) && !string.IsNullOrEmpty(createdDate) && !string.IsNullOrEmpty(enddate)
)
{
if (project != "")
{
projectModel projectMod = new projectModel();
ProjectController projControll = new ProjectController();
projectMod.ProjectId = Convert.ToInt32(projectList.CurrentRow.Cells[0].Value.ToString());
projectMod.ProjectName = project;
projectMod.CreatedDate = createdDate;
projectMod.EndDate = enddate;
projectMod.Username = userName;
Boolean updateProject = projControll.UpdateProject(projectMod);;
if (updateProject)
{
MessageBox.Show("Update successfully!");
makeFieldsBlank();
this.Close();
}
else
{
MessageBox.Show("Unable to update Project!");
}
}
else
{
MessageBox.Show("please Fill Created Date!");
txtCreatedDate.Focus();
}
}
else
{
MessageBox.Show("Please enter Project name!");
txtProject.Focus();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string project = txtProject.Text;
string createdDate = txtCreatedDate.Text;
string enddate = txtEndDate.Text;
if (!string.IsNullOrEmpty(project) && !string.IsNullOrEmpty(createdDate) && !string.IsNullOrEmpty(enddate)
)
{
if (project != "")
{
projectModel projectMod = new projectModel();
ProjectController projControll = new ProjectController();
projectMod.ProjectName = project;
projectMod.CreatedDate = createdDate;
projectMod.EndDate = enddate;
Boolean projectAdded = projControll.AddProject(projectMod);;
if (projectAdded)
{
MessageBox.Show("Project successfully Created!");
makeFieldsBlank();
this.Close();
}
else
{
MessageBox.Show("Unable to create Project!");
}
}
else
{
MessageBox.Show("please Fill Created Date!");
txtCreatedDate.Focus();
}
}
else
{
MessageBox.Show("Please enter Project name!");
txtProject.Focus();
}
}
public messageModel insert(projectModel value)
{
messageModel result = new messageModel();
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
System.Data.Entity.Core.Objects.ObjectParameter myOutputParamInt = new System.Data.Entity.Core.Objects.ObjectParameter("r_id", typeof(Int32));
using (var context = new StandardCanEntities())
{
int ret = context.sp_project_insert_v3(value.prj_name, value.start_date, value.stop_date, value.prj_detail, value.prj_status, userId, myOutputParamInt);
}
if (myOutputParamInt.Value != null)
{
int r_id = Convert.ToInt32(myOutputParamInt.Value);
result.status = "S";
result.message = "";
result.value = r_id.ToString();
}
else
{
result.status = "E";
result.message = "";
}
}
catch (Exception ex)
{
result.status = "E";
result.message = ex.Message.ToString();
}
return(result);
}
public Boolean DeleteBug(projectModel project)
{
Boolean userDeleted = false;
string query = "delete from project where bugId='" + project.ProjectId + "';";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
int affectedRows = commandDatabase.ExecuteNonQuery();
if (affectedRows > 0)
{
userDeleted = true;
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(userDeleted);
}
public Boolean UpdateProject(projectModel project)
{
Boolean isUpdated = false;
string query = "update project set userName ='******', projectName='" + project.ProjectName + "', createdDate= '" + project.CreatedDate + "', EndDate='" + project.EndDate + "' where projectId ='" + project.ProjectId + "';";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
int updatedRow = commandDatabase.ExecuteNonQuery();
if (updatedRow > 0)
{
isUpdated = true;
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(isUpdated);
}
public projectMasterModel master(projectModel value)
{
projectMasterModel result = new projectMasterModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string sql = "select convert(nvarchar(4), MPJ_YEAR) code, convert(nvarchar(4), MPJ_YEAR) [text] ";
sql += " from MAS_PROJECT ";
sql += " where MPJ_YEAR is not null ";
sql += " group by MPJ_YEAR ";
result.year = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = "select convert(nvarchar(5), MPJ_ID) code ";
sql += " , MPJ_NAME [text] ";
sql += " from MAS_PROJECT ";
sql += " where MPJ_STATUS = 1 ";
sql += " order by MPJ_NAME ";
result.project = context.Database.SqlQuery <dropdown>(sql).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
public IEnumerable <sp_project_search_v2_Result> search(projectModel value)
{
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_project_search_v2_Result> result = context.sp_project_search_v2(value.year_from, value.year_to, value.prj_from, value.prj_to, value.prj_name, value.status_id).AsEnumerable();
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Boolean AddProject(projectModel project)
{
Boolean userAdded = false;
string query = "insert into project (projectName, createdDate, EndDate,userName)" +
"values ('" + project.ProjectName + "', '" + project.CreatedDate + "', '" + project.EndDate + "','" + project.Username + "' );";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
int affectedRows = commandDatabase.ExecuteNonQuery();
if (affectedRows > 0)
{
userAdded = true;
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(userAdded);
}
public ActionResult ProjectMain()
{
List <IEnumerable <projUser> > memberslist = new List <IEnumerable <projUser> >();
List <projectModel> ProjectsList = new List <projectModel>();
ReviseDBEntities con = new ReviseDBEntities();
string userId = Session["userid"].ToString();
var prj = con.projUsers.Where(u => u.userid == userId).ToList();
List <projUser> Nodup = new List <projUser>();
int prjScore = 0;
int usrScore = 0;
int usrproj = 0;
//if the connected user is admin, shows him all projects
if (con.users.Find(userId).IsAdmin == true)
{
prj = con.projUsers.ToList();
}
foreach (var temp in con.projects)
{
foreach (var tmp in prj)
{
if (tmp.projid == temp.ProjId)
{
Nodup.Add(tmp);
break;
}
}
}
foreach (var pr in Nodup) //shows only the projects the user is assign to
{
int active = 0;
projectModel proj = new projectModel();
proj.projid = pr.projid;
proj.Date = pr.project.creation_date.ToString("dd/MM/yyyy");
//updating the project status
foreach (var prjc in con.projCats.Where(p => p.projId == pr.projid).ToList())
{
if (prjc.isActive == true || prjc.isActive == null)
{
active++;
}
}
if (active == 0)
{
con.projects.Find(pr.projid).status = "Close";
con.SaveChanges();
proj.status = "Close";
}
else
{
if (con.projects.Find(pr.projid).status == "Open")
{
proj.status = pr.project.status;
}
else
{
con.projects.Find(pr.projid).status = "Open";
con.SaveChanges();
proj.status = "Open";
}
}
proj.projname = pr.project.ProjName;
proj.MemberRole = pr.role ?? 7;
memberslist.Add(con.projUsers.Where(u => u.projid == pr.projid));
usrproj = UserScoreCalc(pr.projid, userId);
//calculating the project score
foreach (var p in con.projUsers.Where(p => p.projid == pr.projid).ToList())
{
prjScore = prjScore + p.grade ?? prjScore;
}
usrScore = usrScore + usrproj;
con.projects.SingleOrDefault(p => p.ProjId == pr.projid).totalScore = prjScore;
con.SaveChanges();
proj.score = prjScore;
ProjectsList.Add(proj);
prjScore = 0;
}
con.users.Find(userId).score = usrScore;
con.SaveChanges();
Session["UserScore"] = usrScore;
Session["members"] = memberslist;
Session["projects"] = ProjectsList.ToList();
return(View(ProjectsList.ToList()));
}
