public JsonResult SaveVersionInfo(string selFP, string txtFP, string chkSN, string selNL, string selPL, string txtUN, string chkFT, string txtFN) { var UserLastAction = (from ula in db.UserLastActions where ula.UserId == UserData.UserName && ula.Company == UserData.CompanyName select ula).FirstOrDefault(); if (UserLastAction != null) { var UploadFilesHeader = (from ufh in db.UploadFilesHeaders where ufh.UserId == UserData.UserName && ufh.CompanyName == UserData.CompanyName && ufh.Role == UserLastAction.Role select ufh).FirstOrDefault(); if (UploadFilesHeader != null) { UploadFilesHeader.SerialNoFlag = chkSN; UploadFilesHeader.FirstPositionField = selFP; UploadFilesHeader.FirstPosition = txtFP; UploadFilesHeader.KeyField = selNL; UploadFilesHeader.ParentField = selPL; UploadFilesHeader.FullNameFields = txtUN; UploadFilesHeader.FileType = chkFT; UploadFilesHeader.JSONFileName = txtFN; UploadFilesHeader.VersionNo++; UploadFilesHeader.CurrentVersionNo = UploadFilesHeader.VersionNo; UserLastAction.Version = UploadFilesHeader.VersionNo.ToString(); } else { UploadFilesHeaders UFH = new UploadFilesHeaders(); UFH.SerialNoFlag = chkSN; UFH.FirstPositionField = selFP; UFH.FirstPosition = txtFP; UFH.KeyField = selNL; UFH.ParentField = selPL; UFH.FullNameFields = txtUN; UFH.FileType = chkFT; UFH.JSONFileName = txtFN; UFH.Role = UserLastAction.Role; UFH.VersionNo = 1; UFH.CurrentVersionNo = 1; UserLastAction.Version = "1"; db.UploadFilesHeaders.Add(UFH); } UploadFileDetails UFD = new UploadFileDetails(); UFD.JSONFileName = txtFN; UFD.KeyDate = DateTime.Now; UFD.VersionNo = Convert.ToInt32(UserLastAction.Version); UFD.VersionStatus = "P"; UFD.Role = UserLastAction.Role; UFD.CompanyName = UserData.CompanyName; UFD.UserId = UserData.UserName; db.UploadFileDetails.Add(UFD); db.SaveChanges(); } // Updates the Table with new Version if (chkFT == "JSON") { UpdateTableWithJSON(UserLastAction.Role, UserLastAction.Role); } else if (chkFT == "XLSX") { UpdateTableWithJSON(UserLastAction.Role, UserLastAction.Role); } return(Json(new { Success = "Yes" })); }
public JsonResult SetSelectedValues(string KeyDate, string UsedView, string Country, string ShowLevel, string Levels, string Oper, string Version, string Role, string SelectedShape, string SelectedSkin, string SelectedShowPicture, string SelectedSplitScreen, string SelectedSplitScreenDirection, string SelectedTextColor, string SelectedBorderColor, string SelectedBorderWidth, string SelectedLineColor, string SelectedBoxWidth, string SelectedPortraitModeMultipleLevel, string SelectedFunctionalManagerType, string SelectedFMLine, string OrgChartType, string Type) { LoginUsers UserData = LI.GetLoginUserInfo(""); var UCA = (from uca in db.UserLastActions where uca.UserId == UserData.UserName select uca).FirstOrDefault(); if (UCA != null) { if (Type == "Role") { string UserRole = (Role == "User") ? "Finalyzer" : Role; UploadFilesHeaders UFH = null; if (UserRole != "Finalyzer") { UFH = (from ufh in db.UploadFilesHeaders where ufh.CompanyName == UserData.CompanyName && ufh.UserId == UserData.UserName && ufh.Role == UserRole select ufh).FirstOrDefault(); } else { UFH = (from ufh in db.UploadFilesHeaders where ufh.CompanyName == UserData.CompanyName && ufh.Role == UserRole select ufh).FirstOrDefault(); } if (UFH != null) { UCA.Version = UFH.VersionNo.ToString(); UCA.Role = Role; int UserVersion = UFH.VersionNo; var UFD = (from ufd in db.UploadFilesDetails where ufd.VersionNo == UserVersion select ufd).FirstOrDefault(); if (UFD != null) { UCA.ShowLevel = UFD.ShowLevel; } } else { UCA.Version = "-999"; UCA.Role = Role; } Session.Contents[UserData.UserName + "_MyModel"] = null; return(Json(new { Success = "Yes", ChartData = "Role Change", TreeData = "" })); } else if (Type == "View") { UCA.UsedView = UsedView; } else if (Type == "Level") { UCA.Levels = Levels; } else if (Type == "Type") { UCA.Oper = Oper; } else if (Type == "Settings") { UCA.UsedView = UsedView; UCA.SelectedShape = SelectedShape; UCA.SelectedSkin = SelectedSkin; UCA.SelectedShowPicture = SelectedShowPicture; UCA.SelectedSplitScreen = SelectedSplitScreen; UCA.SelectedSplitScreenDirection = SelectedSplitScreenDirection; UCA.SelectedTextColor = SelectedTextColor; UCA.SelectedBorderColor = SelectedBorderColor; UCA.SelectedBorderWidth = SelectedBorderWidth; UCA.SelectedLineColor = SelectedLineColor; UCA.SelectedBoxWidth = SelectedBoxWidth; UCA.SelectedPortraitModeMultipleLevel = SelectedPortraitModeMultipleLevel; UCA.SelectedFunctionalManagerType = SelectedFunctionalManagerType; UCA.SelectedFMLine = SelectedFMLine; UCA.OrgChartType = OrgChartType; UCA.Levels = Levels; } else if (Type == "") { UCA.KeyDate = KeyDate; UCA.Country = Country; UCA.ShowLevel = ShowLevel; } db.SaveChanges(); } string[] ChangeLevel = LI.GetOrgChartData(UCA.Role, UCA.Country, UCA.ShowLevel, UCA.ParentLevel, UCA.Levels, UCA.Oper, UCA.Version, UCA.OrgChartType, UCA.SelectedPortraitModeMultipleLevel, UCA.SelectedFunctionalManagerType); if (Session.Contents[UserData.UserName + "_MyModel"] != null) { MyModel MyModel = (MyModel)Session.Contents[UserData.UserName + "_MyModel"]; MyModel.ChartData = ChangeLevel[1]; if (Type == "Settings") { MyModel.View = UsedView; MyModel.SelectedShape = SelectedShape; MyModel.SelectedSkin = SelectedSkin; MyModel.SelectedShowPicture = SelectedShowPicture; MyModel.SelectedSplitScreen = SelectedSplitScreen; MyModel.SelectedSplitScreenDirection = SelectedSplitScreenDirection; MyModel.SelectedTextColor = SelectedTextColor; MyModel.SelectedBorderColor = SelectedBorderColor; MyModel.SelectedBorderWidth = SelectedBorderWidth; MyModel.SelectedBoxWidth = SelectedBoxWidth; MyModel.SelectedLineColor = SelectedLineColor; MyModel.SelectedPortraitModeMultipleLevel = SelectedPortraitModeMultipleLevel; MyModel.SelectedFunctionalManagerType = SelectedFunctionalManagerType; MyModel.SelectedFMLine = SelectedFMLine; MyModel.OrgChartType = OrgChartType; MyModel.Levels = Levels; } else if (Type == "View") { MyModel.View = UsedView; } else if (Type == "") { MyModel.KeyDate = KeyDate; MyModel.Country = Country; MyModel.ShowLevel = ShowLevel; } Session.Contents[UserData.UserName + "_MyModel"] = MyModel; } return(Json(new { Success = "Yes", ChartData = ChangeLevel[1], TreeData = ChangeLevel[0] })); }