public Person ControlPerson(string _email, string _password)
{
try
{
using (var context = new ProjectManagementEntities())
{
var user = context.Person.FirstOrDefault(x => x.Email == _email && x.Password == _password && x.Status > 0);
if (user != null)
{
return(user);
}
return(null);
}
}
catch (Exception exc)
{
throw exc;
}
}
public List <Project> GetAllDetailTaskProjectById(int _id)
{
try
{
var _personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id;
using (var context = new ProjectManagementEntities())
{
var list = new List <Project>();
var item = ProjectDB.GetInstance().GetProjeById(_id);
list.Add(item);
return(list);
}
}
catch (System.Exception exc)
{
throw exc;
}
}
public List <ChartDetailViewModel> GetChartDetail(string _milestoneName, int _projectId)
{
try
{
var returnList = new List <ChartDetailViewModel>();
using (var context = new ProjectManagementEntities())
{
var milestone = context.Milestone.FirstOrDefault(x => x.Name == _milestoneName.Trim() && x.ProjectId == _projectId);
if (milestone != null)
{
var steps = context.Step.Where(x => x.MilestoneId == milestone.Id).ToList();
foreach (var item in steps)
{
var assignedUser = context.Person.FirstOrDefault(x => x.Id == item.AssigneeUser);
var sprint = context.Sprint.FirstOrDefault(x => x.Id == item.SprintId);
returnList.Add(new ChartDetailViewModel()
{
AssigneeUserName = $"{assignedUser.Name} {assignedUser.Surname}",
SprintId = item.SprintId,
SprintName = sprint.Name,
TaskId = item.Id,
TaskName = item.Name,
TaskStatus = item.Status,
Workers = GetWorkersForChartDetail(item.Id)
});
}
}
return(returnList);
}
}
catch (Exception exc)
{
throw exc;
}
}
public ActionResult doNewCost(string tbID, string ddlProject, string ddlPartyB,
string dpDate, string nbMoney, string ddlMoneyUnit)
{
if (Session["username"] == null || Session["username"].Equals(""))
{
return(RedirectToAction("Index", "Session"));
}
if (!ValidateCostID(tbID))
{
ShowNotify(string.Format("存在{0}这样的支出编号", tbID), MessageBoxIcon.Warning);
UIHelper.TextBox("tbID").MarkInvalid("已存在相同的支出编号");
return(UIHelper.Result());
}
Cost cos = new Cost();
cos.ID = Convert.ToInt32(tbID);
cos.ProjectID = Convert.ToInt32(ddlProject);
cos.PartyBID = Convert.ToInt32(ddlPartyB);
cos.Money = computeMoney(nbMoney, ddlMoneyUnit);
cos.Date = parseDate(dpDate);
using (var db = new ProjectManagementEntities())
{
db.Cost.Add(cos);
try
{
db.SaveChanges();
ShowNotify("发票添加成功", MessageBoxIcon.Success);
UIHelper.Form("mainForm").Reset();
}
catch (System.Data.Entity.Validation.DbEntityValidationException)
{
ShowNotify("数据无效，请检查表单！", MessageBoxIcon.Error);
}
catch (Exception)
{
ShowNotify("服务器发生了未能处理的异常，请联系技术人员进行检测。", MessageBoxIcon.Error);
}
}
return(UIHelper.Result());
}
public ActionResult NewInvoice()
{
if (Session["username"] == null || Session["username"].Equals(""))
{
return(RedirectToAction("Index", "Session"));
}
NewInvoiceViewModel vm = new NewInvoiceViewModel();
using (var db = new ProjectManagementEntities())
{
//Get Project
DataTable dtPro = new DataTable();
dtPro.Columns.Add(new DataColumn("ID", typeof(string)));
dtPro.Columns.Add(new DataColumn("Name", typeof(string)));
var proArr = db.Project;
foreach (var pro in proArr)
{
var dtProRow = dtPro.NewRow();
dtProRow["ID"] = pro.ID;
dtProRow["Name"] = String.Format("(代码:{0}) {1}", pro.ID, pro.Name);
dtPro.Rows.Add(dtProRow);
}
vm.Project = dtPro;
//GetPartyB
DataTable dtPartyB = new DataTable();
dtPartyB.Columns.Add(new DataColumn("ID", typeof(string)));
dtPartyB.Columns.Add(new DataColumn("Name", typeof(string)));
var partyBArr = db.PartyB;
foreach (var partyB in partyBArr)
{
var dtPartyBRow = dtPartyB.NewRow();
dtPartyBRow["ID"] = partyB.ID;
dtPartyBRow["Name"] = "(代码:" + partyB.ID + ") " + partyB.Name;
dtPartyB.Rows.Add(dtPartyBRow);
}
vm.PartyB = dtPartyB;
}
return(View(vm));
}
public List <DateTime> GetProjectStartAndEndDate(int _projectId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var mileStoneList = context.Milestone.Where(x => x.Status > 0 && x.ProjectId == _projectId).ToList();
var startDate = mileStoneList.Select(x => x.StartDate).ToList().OrderBy(x => x).ToList().FirstOrDefault();
var endDate = mileStoneList.Select(x => x.EndDate).ToList().OrderByDescending(x => x).ToList().FirstOrDefault();
return(new List <DateTime>()
{
startDate, endDate
});
}
}
catch (Exception exc)
{
throw exc;
}
}
/// <summary>
/// Updated Project
/// </summary>
/// <param name="project">Project</param>
/// <returns>Boolean</returns>
public int UpdateProject(Project project)
{
using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities())
{
var existingProject = projectMngtEntity.tblProjects.Find(project.ProjectID);
if (existingProject != null)
{
existingProject.ProjectName = project.ProjectName;
existingProject.StartDt = project.StartDate;
existingProject.EndDt = project.EndDate;
existingProject.Priority = project.Priority;
//projectMngtEntity.Entry(existingProject).State = System.Data.Entity.EntityState.Modified;
return(projectMngtEntity.SaveChanges());
}
else
{
return(-1);
}
}
}
private int getDefaultProjectID()
{
using (var db = new ProjectManagementEntities())
{
// Search the ID
int now = Convert.ToInt32(System.DateTime.Now.ToString("yyyyMM"));
var pid = (from u in db.Project where u.ID / 1000 == now select u.ID);
//.Equals(System.DateTime.Now.ToString("yyyymm")))).Max(u=>u.ID);
//if (idres == null) { pid = System.DateTime.Now.ToString("yyyymm") + "0001"; }
int m;
if (pid.Count() == 0)
{
m = now * 1000 + 1;
}
else
{
m = pid.Max() + 1;
}
return(m);
}
}
/// <summary>
/// Updated User
/// </summary>
/// <param name="user">User</param>
/// <returns>int</returns>
public int UpdateUser(User user)
{
using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities())
{
var existingUser = projectMngtEntity.tblUsers.Find(user.UserID);
if (existingUser != null)
{
existingUser.FirstName = user.FirstName;
existingUser.LastName = user.LastName;
existingUser.EmployeeID = user.EmployeeID;
existingUser.ProjectID = user.ProjectID;
existingUser.TaskID = user.TaskID;
return(projectMngtEntity.SaveChanges());
}
else
{
return(-1);
}
}
}
public Department SaveDepartment(int _id, string _name, int _headOfDepartmentId)
{
try
{
using (var context = new ProjectManagementEntities())
{
if (_id == 0)
{
var Department = new Department()
{
Id = _id,
DepartmentName = _name,
Status = 1,
HeadOfDepartmentId = _headOfDepartmentId
};
context.Department.Add(Department);
int numberOfInserted = context.SaveChanges();
return(numberOfInserted > 0 ? Department : null);
}
else
{
var Department = context.Department.FirstOrDefault(x => x.Id == _id);
Department.Id = _id;
Department.DepartmentName = _name;
Department.Status = 1;
Department.HeadOfDepartmentId = _headOfDepartmentId;
int numberOfUpdated = context.SaveChanges();
return(numberOfUpdated > 0 ? Department : null);
}
}
}
catch (Exception exc)
{
throw exc;
}
}
public Team SaveTeam(int _id, string _name, int _departmentId)
{
try
{
using (var context = new ProjectManagementEntities())
{
if (_id == 0)
{
var Team = new Team()
{
Id = _id,
Name = _name,
Status = 1,
DepartmentId = _departmentId
};
context.Team.Add(Team);
int numberOfInserted = context.SaveChanges();
return(numberOfInserted > 0 ? Team : null);
}
else
{
var Team = context.Team.FirstOrDefault(x => x.Id == _id);
Team.Id = _id;
Team.Name = _name;
Team.Status = 1;
Team.DepartmentId = _departmentId;
int numberOfUpdated = context.SaveChanges();
return(numberOfUpdated > 0 ? Team : null);
}
}
}
catch (Exception exc)
{
throw exc;
}
}
public List <WhatsappMessageRedirectRepo> GetRedirectNotifications(int _userId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var returnList = new List <WhatsappMessageRedirectRepo>();
var headDepartmentIds = context.Department.Where(x => x.HeadOfDepartmentId == _userId).ToList().Select(x => x.Id).ToList();
var list = context.WhatsappMessageRedirect.Where(x => headDepartmentIds.Contains(x.DepartmentId) && x.Status > 0).ToList();
foreach (var item in list)
{
var department = context.Department.FirstOrDefault(x => x.Id == item.DepartmentId);
var message = context.WhatsappMessage.FirstOrDefault(x => x.Id == item.MessageId);
var redirectUser = context.Person.FirstOrDefault(x => x.Id == item.RedirectedUserId);
returnList.Add(new WhatsappMessageRedirectRepo()
{
RedirectDate = item.Date.ToString("dd/MM/yyyy HH:mm"),
MessageDate = message.Date.ToString("dd/MM/yyyy HH:mm"),
DepartmentId = item.DepartmentId,
DepartmentName = department != null ? department.DepartmentName : "Bilinmiyor",
Id = item.Id,
Message = message != null ? message.MessageContent : "Bilinmiyor",
MessageId = item.MessageId,
RedirectedUserId = item.RedirectedUserId,
RedirectedUserName = redirectUser != null ? $"{redirectUser.Name} {redirectUser.Surname}" : "Bilinmiyor",
Status = item.Status,
SenderNumber = message != null ? message.MessageFrom : "Bilinmiyor"
});
}
return(returnList);
}
}
catch (Exception exc)
{
throw exc;
}
}
public DashboardWidgets(int employeeID)
{
this.EmployeeID = employeeID;
dbContext = new ProjectManagementEntities();
Items = new ObservableCollection <Widget>();
var query = dbContext.Dashboard.Where(d => d.DashBoardID == employeeID);
foreach (var item in query)
{
Items.Add(new Widget()
{
WidgetID = (int)item.WidgetID,
WidgetName = item.WidgetDetail.WidgetName.ToString(),
Desc = item.WidgetDetail.WidgetDesc.ToString(),
CanvasLeft = (int)item.PositionLeft,
CanvasTop = (int)item.PositionTop,
ImagePath = new BitmapImage(new Uri(item.WidgetDetail.WidgetImagePath.ToString(), UriKind.Relative)),
WidgetWidth = (int)item.WidgetWidth,
WidgetHeight = (int)item.WidgetHeight
});
}
}
public void MakeMessagesSeen(int _messageId, int _userId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var message = context.Message.FirstOrDefault(x => x.Id == _messageId);
var allMessagesBetween = context.Message.Where(x => x.ReceiverId == message.SenderId && x.SenderId == message.ReceiverId).ToList();
allMessagesBetween.AddRange(context.Message.Where(x => x.SenderId == message.SenderId && x.ReceiverId == message.ReceiverId).ToList());
allMessagesBetween = allMessagesBetween.Where(x => x.ReceiverId == _userId).ToList();
foreach (var item in allMessagesBetween)
{
item.IsSeen = true;
context.SaveChanges();
}
}
}
catch (Exception exc)
{
throw exc;
}
}
public List <Category> GetCategoryNameandId(int _id)
{
try
{
using (var context = new ProjectManagementEntities())
{
var returnList = new List <Category>();
var list = context.Category.FirstOrDefault(x => x.Id == _id);
returnList.Add(new Category()
{
Id = list.Id,
Name = list.Name,
ProjectId = list.ProjectId
});
return(returnList);
}
}
catch (System.Exception exc)
{
throw exc;
}
}
public List <Category> GetCategoryById(int _CategoryId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var returnList = new List <Category>();
var list = context.Category.FirstOrDefault(x => x.Status > 0 && x.Id == _CategoryId);
returnList.Add(new Category()
{
Name = list.Name,
Id = list.Id,
ProjectId = list.ProjectId
});
return(returnList);
}
}
catch (Exception exc)
{
throw exc;
}
}
public bool DeleteMessage(int _messageId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var message = context.WhatsappMessage.FirstOrDefault(x => x.Id == _messageId);
if (message != null)
{
message.IsSeen = true;
int numberOfUpdated = context.SaveChanges();
return(numberOfUpdated > 0);
}
return(false);
}
}
catch (Exception exc)
{
throw exc;
}
}
public ActionResult ProvinceChange(string ddlProvince)
{
var ddlCity = UIHelper.DropDownList("ddlCity");
List <ListItem> items = new List <ListItem>();
items.Add(new ListItem("选择地区市", "-1", true));
if (ddlProvince != "-1")
{
using (var db = new ProjectManagementEntities()){
int ddlProvinceNum = Convert.ToInt32(ddlProvince);
var CityArr = db.City.Where(u => (u.ProvinceID == ddlProvinceNum));
foreach (var City in CityArr)
{
ListItem item = new ListItem();
item.Text = City.Name;
item.Value = City.ID.ToString();
items.Add(item);
}
}
}
ddlCity.LoadData(items.ToArray());
// 是否禁用
ddlCity.Enabled(!(ddlCity.Source.Items.Count == 1));
var ddlCounty = UIHelper.DropDownList("ddlCounty");
List <ListItem> items2 = new List <ListItem>();
items2.Add(new ListItem("选择县", "-1", true));
ddlCounty.LoadData(items2.ToArray());
ddlCounty.Enabled(false);
return(UIHelper.Result());
}
public bool DeleteSprint(int _sprintId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var sprint = context.Sprint.FirstOrDefault(x => x.Id == _sprintId);
if (sprint != null)
{
sprint.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
public bool DeleteCategory(int _CategoryId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var Category = context.Category.FirstOrDefault(x => x.Id == _CategoryId);
if (Category != null)
{
Category.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
public bool DeleteTask(int _TaskId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var Task = context.Task.FirstOrDefault(x => x.Id == _TaskId);
if (Task != null)
{
Task.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
public bool DeletePano(int _panoId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var board = context.Board.FirstOrDefault(x => x.Id == _panoId);
if (board != null)
{
board.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
/// <summary>
/// Updated Task
/// </summary>
/// <param name="task">Project</param>
/// <returns>int</returns>
public int UpdateTask(task.Task task)
{
using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities())
{
var existingTask = projectMngtEntity.tblTasks.Find(task.TaskID);
if (existingTask != null)
{
existingTask.ParentID = task.ParentTaskId;
existingTask.ProjectID = task.ProjectId;
existingTask.Task = task.TaskDesc;
existingTask.StartDt = task.StartDate;
existingTask.EndDt = task.EndDate;
existingTask.Priority = task.Priority;
existingTask.Status = task.Status;
return(projectMngtEntity.SaveChanges());
}
else
{
return(-1);
}
}
}
public bool DeleteRedirectedMessage(int _redirectId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var redirect = context.WhatsappMessageRedirect.FirstOrDefault(x => x.Id == _redirectId);
if (redirect != null)
{
redirect.Status = 0;
int numberOfUpdated = context.SaveChanges();
return(numberOfUpdated > 0);
}
return(false);
}
}
catch (Exception exc)
{
throw exc;
}
}
public Project Update(int id, Project project)
{
ProjectManagementEntities ctx = ProjectManagementEntities.Context;
Project proj = null;
try
{
proj = ctx.Projects.FirstOrDefault(x => x.Project_ID == id);
proj.Project_Name = project.Project_Name;
proj.Start_Date = project.Start_Date;
proj.End_Date = project.End_Date;
proj.Priority = project.Priority;
proj.Manager = project.Manager;
ctx.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw;
}
return(proj);
}
public bool DeleteGorev(int _gorevId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var gorev = context.Step.FirstOrDefault(x => x.Id == _gorevId);
if (gorev != null)
{
gorev.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
public bool DeleteMilestone(int _projeId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var milestone = context.Milestone.FirstOrDefault(x => x.Id == _projeId);
if (milestone != null)
{
milestone.Status = 0;
int numberOfDeleted = context.SaveChanges();
return(numberOfDeleted > 0);
}
}
return(false);
}
catch (System.Exception exc)
{
throw exc;
}
}
public JsonResult GetProjectPercentage()
{
try
{
using (var context = new ProjectManagementEntities())
{
var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id;
var pct = StepDB.GetInstance().GetProjectPercentage(_projectId);
pct.Gerceklesen = pct.Gerceklesen == null || pct.Gerceklesen.Trim() == "" ? "0" : pct.Gerceklesen;
var yuzde = Math.Round(Convert.ToDouble(pct.Gerceklesen.Replace(".", ",").Trim(), CultureInfo.GetCultureInfo("tr-TR")) * 100, 2);
return(Json(yuzde));
}
}
catch (System.Exception exc)
{
throw exc;
}
/*
* SET @pct = 0;
* SET @boardId = 0;
* SET @allItems = 0;
* SET @completedItems = 0;
*
* SET @boardId = (SELECT Id FROM Board AS B
* WHERE ProjectId = 1
* LIMIT 2,1);
*
* SET @allItems = (SELECT COUNT(1) FROM Step AS S INNER JOIN Milestone AS MS ON MS.Id = S.MilestoneId WHERE MS.ProjectId = 1);
* SET @completedItems = (SELECT COUNT(1) FROM Step AS S INNER JOIN Milestone AS MS ON MS.Id = S.MilestoneId INNER JOIN BoardStep AS BS ON BS.StepId = S.Id WHERE MS.ProjectId = 1 AND BS.BoardId = @boardId);
* SET @pct = (@completedItems * 100 / @allItems) / 100;
* SELECT @pct;
*/
}
public int FinishSprint(int _projectId)
{
try
{
using (var context = new ProjectManagementEntities())
{
var boards = context.Board.Where(x => x.ProjectId == _projectId & x.Status == 1).ToList();
var boardIds = boards.Select(x => x.Id).ToList();
var boardSteps = context.BoardStep.Where(x => boardIds.Contains(x.BoardId)).ToList();
var boardStepIds = boardSteps.Select(x => x.StepId).ToList();
var steps = context.Step.Where(x => boardStepIds.Contains(x.Id)).ToList();
var stepIds = steps.Select(x => x.Id).ToList();
var stepPerson = context.StepPerson.Where(x => stepIds.Contains(x.StepId)).ToList();
var stepPersonIds = stepPerson.Select(x => x.Id).ToList();
var control = context.StepPersonDetail.FirstOrDefault(x => stepPersonIds.Contains(x.StepPersonId) && x.EndDate == null);
if (control != null)
{
return(-1);
}
foreach (var item in steps)
{
item.Status = 3;
context.SaveChanges();
}
context.BoardStep.RemoveRange(boardSteps);
context.SaveChanges();
return(1);
}
}
catch (Exception exc)
{
throw exc;
}
}
public ActionResult DeleteProject(string ID)
{
if (Session["username"] == null || Session["username"].Equals(""))
{
return(RedirectToAction("Index", "Session"));
}
using (var db = new ProjectManagementEntities())
{
Project deleteItem = new Project {
ID = Convert.ToInt32(ID)
};
db.Project.Attach(deleteItem);
db.Project.Remove(deleteItem);
int result;
try
{
result = db.SaveChanges();
}
catch (Exception)
{
ShowNotify("服务器出现异常，删除失败", MessageBoxIcon.Error);
return(UIHelper.Result());
}
if (result > 0)
{
ShowNotify("成功删除", MessageBoxIcon.Success);
PageContext.Redirect(Url.Action("SearchProject"));
}
else
{
ShowNotify("删除失败", MessageBoxIcon.Error);
}
return(UIHelper.Result());
}
}
