public ProjectMapping UpdateMappig(int projId, int cpId, string colName)
{
ProjectMapping mapping =
_db.ProjectMappings.SingleOrDefault(pm => pm.ProjectId == projId && pm.CPId == cpId);
try
{
if (mapping != null)
{
mapping.CPId = cpId;
mapping.PropertyName = colName;
mapping.ProjectId = projId;
}
else
{
mapping = new ProjectMapping();
mapping.ProjectId = projId;
mapping.CPId = cpId;
mapping.PropertyName = colName;
_db.ProjectMappings.Add(mapping);
}
_db.SaveChanges();
return(mapping);
}
catch (Exception err)
{
throw err;;
}
}
public ActionResult UpdateMapping(int CPId, int ProjectId, string Column)
{
JSONResult result = new JSONResult();
ProjectMapping mapping = null;
ProjectMapping checkData;
List <ProjectMapping> mappingList =
iProjectMapping.GetProjectMappingsById(ProjectId);
if (mappingList.Count > 0)
{
checkData = mappingList.SingleOrDefault(cp => cp.CPId == CPId);
if (checkData != null && string.Compare(checkData.PropertyName, Column) == 0)
{
result.Code = "2";
return(Json(result));
}
}
try
{
mapping = iProjectMapping.UpdateMappig(ProjectId, CPId, Column);
result.Code = "1";
result.Message = SuccessMessage;
}
catch (Exception err)
{
result.Code = "0";
result.Message = ErrorMessage;
}
return(Json(result));
}
static MongoDataContext()
{
ProductMapping.Register();
MachineMapping.Register();
ProjectMapping.Register();
AddressMapping.Register();
}
public ActionResult GetProjectChartPropertyList(int id)
{
KBProject project = iProj.GetKBProjectById(id);
List <ProjectMapping> mappingList = iProjectMapping.GetProjectMappingsById(id);
List <ChartProperty> chartPropertiesList = iProperty.GetChartPropertyList(project.ChartId);
List <ChartPropertyProjectViewModel> chartPropProjList = new List <ChartPropertyProjectViewModel>();
ChartPropertyProjectViewModel chartProperty = null;
ProjectMapping mapping = null;
foreach (ChartProperty item in chartPropertiesList)
{
chartProperty = new ChartPropertyProjectViewModel();
chartProperty.CPId = item.CPId;
chartProperty.CPName = item.CPName;
mapping = mappingList.SingleOrDefault(mp => mp.CPId == item.CPId);
if (mapping != null)
{
chartProperty.Column = mapping.PropertyName;
}
chartPropProjList.Add(chartProperty);
}
var data = JsonConvert.SerializeObject(chartPropProjList, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(new { total = chartPropProjList.Count, rows = data }, JsonRequestBehavior.AllowGet));
}
public ActionResult TeamTimeEntry(FormCollection form)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
ProjectMapping ObjPM = new ProjectMapping();
TeamEntryData obj = new TeamEntryData();
try
{
var curmonth = DateTime.Now.Month;
var month = objdb.Master_TeamMonths.Where(o => o.Id < curmonth).ToList();
var userId = (int)Session["UserId"];
int BranchID = (int)objdb.Users.FirstOrDefault(o => o.UserID == userId).BranchId;
ViewBag.Months = new SelectList(month, "Id", "Months", (curmonth - 1));
ViewBag.Projects = new SelectList(LoadProjects(), "ProjectID", "ProjectName");
ObjPM.Members = GetMembers(obj);
obj.ProjectMembersDetails = GetMembers(obj);
obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId);
obj.IsTeamData = true;
obj.DateFrom = DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.DateTo = DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.MemberList, Date: DateTime.Today.AddDays(-1), IsAscending: true, BranchId: BranchID);
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(obj));
}
public ActionResult Display(string id)
{
string json = string.Empty;
KBProject projData = iProj.GetProjectByURL(id);
DataTable table = iProj.TestSQL(projData.ProjectSQL, projData.ProjectId);
Lazy <C3JSLine> line = null;
Lazy <C3JSBar> bar = null;
switch (projData.Chart.ChartType)
{
case "Line":
ChartProperty chartPtyCatalog =
iChartProperty.GetChartPropertyByCatalog(projData.ChartId);
ChartProperty chartPtyData =
iChartProperty.GetChartPropertyByData(projData.ChartId);
//取得專案設定的Chart對應屬性
List <ProjectMapping> projMappingList =
iProjectMapping.GetProjectMappingsById(projData.ProjectId);
//取得project的catalog col name
ProjectMapping projMappingCatalog =
projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyCatalog.CPId);
//取得project的data col name
ProjectMapping projMappingData =
projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyData.CPId);
line = new Lazy <C3JSLine>(() => new C3JSLine(table, projData.Chart.ChartScript));
json = line.Value.Generate(
projMappingList.Where(pm => pm.CPId == projMappingData.CPId).Select(pmc => pmc.PropertyName).ToArray(),
projMappingCatalog.PropertyName);
break;
case "Bar":
//bar = new Lazy<C3JSBar>(() => new C3JSBar(table, projData.Chart.ChartScript));
//bar.Value.Generate()
break;
default:
break;
}
ViewData["Script"] = json;
return(View());
}
public bool SaveProjectsToUser(List <string> selectedValues, string user)
{
var list = new List <int>();
if (string.IsNullOrEmpty(selectedValues.First()))
{
list = null;
}
else
{
list = selectedValues.Select(int.Parse).ToList();
}
List <ProjectMapping> projectList = new List <ProjectMapping>();
ProjectMapping project = new ProjectMapping();
projectList = this.context.Query <ProjectMapping>().Where(s => s.UserName == user && s.IsDeleted == false).ToList();
if (projectList != null)
{
foreach (ProjectMapping prj in projectList)
{
prj.IsDeleted = true;
prj.ModifiedBy = user;
prj.ModifiedDate = DateTime.Now;
this.context.Update(prj);
}
}
if (list != null)
{
foreach (int lst in list)
{
project.IsDeleted = false;
project.ProjectId = lst;
project.UserName = user;
project.CreatedBy = user;
project.CreatedDate = DateTime.Now;
project.ModifiedBy = user;
project.ModifiedDate = DateTime.Now;
this.context.Add(project);
}
}
return(true);
}
// [DSRCAuthorize(Roles = "Vice President, Project Manager, Tech Lead,Head - Quality")]
public ActionResult TeamTimeEntry(ProjectMapping ObjPM, TeamEntryData teamobj, FormCollection form)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
ViewMembers obj1 = new ViewMembers();
TeamEntryData obj = new TeamEntryData();
try
{
int userId = (int)(Session["UserID"]);
int BranchID = (int)objdb.Users.FirstOrDefault(o => o.UserID == userId).BranchId;
string projectID = (form["ProjectList"] == "") ? "0" : form["ProjectList"].ToString();
int PId = Convert.ToInt32(projectID);
ViewBag.Projects = new SelectList(LoadProjects(), "ProjectID", "ProjectName", projectID);
//if (Convert.ToInt32(teamobj.MemberId) == 0 || teamobj.MemberId==null)
if (teamobj.MemberId == null || teamobj.MemberId == "0")
{
obj.ProjectMembersDetails = GetMembers(teamobj, PId);
obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId);
obj.IsTeamData = true;
obj.MemberId = "0";
}
else
{
obj.ProjectMembersDetails = null;
obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId);
obj.IsTeamData = obj.MemberId == "0";
}
if (Convert.ToString(form["DateFrom"]) != null)
{
DateTime FDate = DateTime.ParseExact(Convert.ToString(form["DateFrom"]), "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (obj.IsTeamData)
{
//obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.MemberList, Date: FDate, IsAscending:true, BranchId: BranchID);
obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.ProjectMembersDetails as List <TeamMember>, Date: FDate, IsAscending: true, BranchId: BranchID);
}
else
{
DateTime ToDate = DateTime.ParseExact(form["DateTo"], "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.EmployeeData = null;
obj.EmployeeData = TimeEntryHelper.GetSingleMemberData(EmpId: teamobj.MemberId, FromDate: FDate, ToDate: ToDate, IsAscending: true, BranchId: BranchID);
if (ToDate == FDate)
{
int count = Convert.ToInt32((ToDate - FDate).TotalDays + 1);
ViewData["totaldays"] = count;
}
else
{
int count = Convert.ToInt32((ToDate - FDate).TotalDays + 1);
ViewData["totaldays"] = count;
}
}
}
var holidaysCount = 0;
double businessDays = 0;
using (var dbhrms = new DSRCManagementSystemEntities1())
{
var FromDate = Convert.ToDateTime(obj.DateFrom);
var ToDate = Convert.ToDateTime(obj.DateTo);
foreach (var item in dbhrms.Master_holiday.Where(holiday => holiday.Date >= FromDate && holiday.Date <= ToDate))
{
if (item.Date != null)
{
var tempDate = ((DateTime)item.Date);
if (tempDate.DayOfWeek != DayOfWeek.Saturday && tempDate.DayOfWeek != DayOfWeek.Sunday)
{
holidaysCount++;
}
}
}
businessDays = 1 + ((ToDate - FromDate).TotalDays * 5 - (FromDate.DayOfWeek - ToDate.DayOfWeek) * 2) / 7 - holidaysCount;
}
ViewBag.businessDays = businessDays;
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(obj));
}
