//private mls_dbEntities db = new mls_dbEntities(); public ActionResult Index(string PageSizeSelect) { TempData["message"] = string.Empty; if (SessionWrapper.GetSession_Model() == null) { ImportViewModelManager modelManager = new ImportViewModelManager(); SessionWrapper.StoreSession_Model(modelManager); } return(View(SessionWrapper.GetSession_Model())); }
//public RemoveFormCollectionData(MSL.Helper.Session.ISessionState sessionState) : base(sessionState) { } //RemoveItemFromGrid public ImportViewModelManager RemoveItemFromGrid(FormCollection formCollection) { ImportViewModelManager fm = ((ImportViewModelManager)HttpContext.Current.Session["model"]); //int i = 0; ExcelViewModel _gridData = new ExcelViewModel(); List <ExcelViewModel> selectedRows = new List <ExcelViewModel>(); var appSettings = formCollection.AllKeys //.Where(k => k.StartsWith("selectedRow_")) .ToDictionary(k => k, k => formCollection[k]); //var asDictionary = formCollection.Cast<string>() // //.Where(key => key.StartsWith(prefix)) // .ToDictionary(key => key, key => formCollection[key]) // .ToList(); //var afterRemoveItem = fm.DataModel.Cast<string>() // //.Where(key => key.StartsWith("selectedRow_")) // .ToDictionary(key => key, key => formCollection[key]) // .ToList(); SelectedFormCollectionData selectedRow = new SelectedFormCollectionData(); selectedRows = selectedRow.SelectedRowFormCollection(formCollection); if (selectedRows.Count > 0) { foreach (var item in selectedRows) { if (!string.IsNullOrEmpty(item.SelectedRowId)) { foreach (var item1 in fm.DataModel.ToList()) { if (item.LocalName == item1.LocalName) { // remove bool removed = fm.DataModel.Remove(fm.DataModel.SingleOrDefault(x => x.LocalName == item.LocalName)); } } } } } return(fm); }
public ActionResult Index(string PageSizeSelect) { TempData["message"] = string.Empty; if (Session["storedevices"] == null) { ImportViewModelManager fm = new ImportViewModelManager(); fm = storedevices; Session["storedevices"] = fm; } else if (!string.IsNullOrEmpty(PageSizeSelect)) { if (Session["storedevices"] == null) { return(View("Index")); } Int16 pageSize = Convert.ToInt16(PageSizeSelect); ((ImportViewModelManager)(Session["storedevices"])).PageSize = pageSize; PageSizeSelect = null; } return(View(Session["storedevices"])); }
private static bool IsValidationGridDataFailed(FormCollection formCollection) { ImportViewModelManager model = new ImportViewModelManager(); model = SessionWrapper.GetSession_Model(); ExtractFormCollectionData extractFrmCollection = new ExtractFormCollectionData(); model.DataModel = extractFrmCollection.XtractFormCollectionData(formCollection); ValidateExcelData validateExcelData = new ValidateExcelData(); validateExcelData.RunValidationCheck(model.DataModel); //get the latest model data after validation done. model = SessionWrapper.GetSession_Model(); if (model.ValidationFailed.Count > 0) { return(true); } return(false); }
private void SubmitButton(FormCollection formCollection, string submitButton) { if (submitButton == Constants.SAVE_TO_DB) { if (formCollection.Count > 0 && formCollection != null) { if (SessionWrapper.GetSession_Model() != null) { if (IsValidationGridDataFailed(formCollection)) { DisplayInvalidData(); } else { ImportViewModelManager model = new ImportViewModelManager(); model = SessionWrapper.GetSession_Model(); ExtractFormCollectionData extractFrmCollection = new ExtractFormCollectionData(); model.DataModel = extractFrmCollection.XtractFormCollectionData(formCollection); SessionWrapper.StoreSession_Model(model); //save to db.... List <DisplayMessage> successMSG = UpsertClass.UpsertData(); DisplayStatus(successMSG); } } } } else if (submitButton == Constants.REFRESH_GRID) { Session.RemoveAll(); } else if (submitButton == Constants.REMOVE_ITEM_FROM_GRID) { RemoveItems(formCollection); } else if (submitButton == Constants.VALIDATE_DATA) { bool isValid = IsValidationGridDataFailed(formCollection); if (isValid) { DisplayInvalidData(); } else { DisplayValidData(); } } else if (Constants.SELECT_RECORD_ARRAY_LIST.Select(x => x.Trim()).Contains(submitButton)) { //AFTER POST THE PAGE IT LOOSES THE PREVIOUS SELECTION...!!! NEEDS TO FIND OUT HOW TO PERSIST THE RECORDS.. ShowRecords(submitButton); } else if (Constants.SELECT_PAGE_SIZE_ARRAY_LIST.Select(x => x.Trim()).Contains(submitButton)) { if (SessionWrapper.GetSession_Model() != null) { if (((ImportViewModelManager)(SessionWrapper.GetSession_Model())).DataModel.Count > 10) { SetPageSize(submitButton); } } } }
public void RunValidationCheck(List <ExcelViewModel> data) { List <ExcelViewModel> _validationFailed = new List <ExcelViewModel>(); List <ExcelViewModel> _validationPassed = new List <ExcelViewModel>(); List <ValidateDataViewModel> vdList = new List <ValidateDataViewModel>(); ImportViewModelManager model = new ImportViewModelManager(); RunValidationForDataSet rv = new RunValidationForDataSet(); //validate the data exists in the db... foreach (ExcelViewModel subItem in data) { ExcelViewModel excelModel = new ExcelViewModel(); foreach (var item in subItem.GetType().GetProperties()) { string name = (item).Name; ValidateDataViewModel isValidationFailed = new ValidateDataViewModel(); int _length = DataAnnotation.GetMaxLengthFromStringLengthAttribute(typeof(ExcelViewModel), name); #region validation checks if (name == Constants.Customer) { bool isDbNotFound = false; ClientCostCenterViewModel dbObject = (ClientCostCenterViewModel)SessionWrapper.GetSession_Customer().Find(s => s.Name.Trim() == subItem.Customer.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); #region backup //bool isLengthValid = false; //bool isExistsInDb = false; ////to capture all error desc ////List<String> errorMsgList = new List<String>(); //isValidationFailed = ValidatatingLength(subItem.Customer, _length, name, Constants.Customer); //AddToValidationErrorList(vdList, subItem, isValidationFailed); ////length add error msg. ////errorMsgList.Add(isValidationFailed.Desc); ////chk length //isLengthValid = ValidateLengthValue(isValidationFailed.Name, isValidationFailed.Desc); //ClientCostCenterViewModel dbObject = (ClientCostCenterViewModel)SessionWrapper.GetSession_Customer().Find(s => s.Name.Trim() == subItem.Customer.Trim()); //if (dbObject == null) //{ // isValidationFailed = ValidateDBValue(name, Constants.Customer); // AddToValidationErrorList(vdList, subItem, isValidationFailed); //} ////db add error msg. ////errorMsgList.Add(isValidationFailed.Desc); ////chk db //isExistsInDb = ValidateDbValue(isValidationFailed.Name, isValidationFailed.Desc); // string htmlTag = GetHtmlTag(isLengthValid, isExistsInDb); // if (!string.IsNullOrEmpty(htmlTag)) // { // subItem.SetValidationFailed.Customer_ValidationFailed = htmlTag; // //HelperUtil.HTML_ICON_DB_LENGTH(errorMsgList.) // isExistsInDb = false; // isLengthValid = false; // } #endregion } if (name == Constants.AssetTag) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.LocalName) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.SerialNumber) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.SystemState) { bool isDbNotFound = false; ServerStatesViewModel dbObject = (ServerStatesViewModel)SessionWrapper.GetSession_ServerStates().Find(s => s.Name.Trim() == subItem.SystemState.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.ServerType) { bool isDbNotFound = false; ServerTypesViewModel dbObject = (ServerTypesViewModel)SessionWrapper.GetSession_ServerTypes().Find(s => s.Name.Trim() == subItem.ServerType.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.Category) { bool isDbNotFound = false; ServerCategoriesViewModel dbObject = (ServerCategoriesViewModel)SessionWrapper.GetSession_ServerCategories().Find(s => s.Name.Trim() == subItem.Category.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.ServiceCategory) { bool isDbNotFound = false; ServiceCateogoriesViewModel dbObject = (ServiceCateogoriesViewModel)SessionWrapper.GetSession_ServiceCateogories().Find(s => s.Name.Trim() == subItem.ServiceCategory.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.Country) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.Domain) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.IsLocalSecurity) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.SecurityWaiver) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.SecurityWaiverNotes) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.OS) { bool isDbNotFound = false; OSTypesViewModel dbObject = (OSTypesViewModel)SessionWrapper.GetSession_OSTypes().Find(s => s.Name.Trim() == subItem.OS.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.OSMinor) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.OSPatchLevel) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.KernelPatch) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.PatchingGroup) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.ServiceIP) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.ServiceFQDN) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.ConsoleAccess) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.CPUCores) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.CPUCount) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.CPUModel) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.CPUSpeed) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.LocalDiskCapacity) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.LocalDiskSlotTotal) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.LocalDiskInstalled) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.LocalRaidLevel) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.PhysicalMemory) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.PurchaseDate) { DateTime value; if (!DateTime.TryParse(subItem.PurchaseDate.ToShortDateString(), out value)) { //make sure the format is correct isValidationFailed = ValidatatingLength(subItem.PurchaseDate.ToShortDateString(), _length, name, Constants.PurchaseDate); AddToValidationErrorList(vdList, subItem, isValidationFailed); } } if (name == Constants.SunHostId) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.TimeZone) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.StreetAddress) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.RegulationCompliance) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.InCluster) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.RebootAutomatic) //boolean???? { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.RebootNotes) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.MasterBackupServer) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.BackupIP) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.VMPlatform) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.VMHost) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.PrimaryApplication) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.BackupAgent) { bool isDbNotFound = false; BackupAgentsViewModel dbObject = (BackupAgentsViewModel)SessionWrapper.GetSession_BackupAgents().Find(s => s.Name.Trim() == subItem.BackupAgent.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.MonitorAgent) { bool isDbNotFound = false; MonitoringAgentsViewModel dbObject = (MonitoringAgentsViewModel)SessionWrapper.GetSession_MonitoringAgents().Find(s => s.Name.Trim() == subItem.MonitorAgent.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.Location) { bool isDbNotFound = false; SiteLocationsViewModel dbObject = (SiteLocationsViewModel)SessionWrapper.GetSession_SiteLocations().Find(s => s.Name.Trim() == subItem.Location.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.RackShelf) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.DCLocation) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.Model) { bool isDbNotFound = false; ModelTypesViewModel dbObject = (ModelTypesViewModel)SessionWrapper.GetSession_ModelTypes().Find(s => s.Name.Trim() == subItem.Model.Trim()); if (dbObject == null) { isDbNotFound = true; } rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, isDbNotFound); } if (name == Constants.AssetTag) { rv.Run_Validation(isValidationFailed, vdList, subItem, _length, name, false); } if (name == Constants.WarrantyEndDate) { DateTime value; if (!DateTime.TryParse(subItem.WarrantyEndDate.ToShortDateString(), out value)) { //make sure the format is correct isValidationFailed = ValidatatingLength(subItem.WarrantyEndDate.ToShortDateString(), _length, name, Constants.WarrantyEndDate); AddToValidationErrorList(vdList, subItem, isValidationFailed); } } #endregion } } _validationFailed = data.Where(x => x.Validations.Count > 0).ToList(); //copy the error item list _validationPassed = data.Where(x => x.Validations.Count == 0).ToList(); //copy the passed item list SessionWrapper.StoreSession_ShowInvalidRecords(_validationFailed); SessionWrapper.StoreSession_ShowValidRecords(_validationPassed); //ExcelViewModel excelViewModel = new ExcelViewModel(); //List<ExcelViewModel> excelViewModelList = new List<ExcelViewModel>(); //excelViewModel.ValidationFailed =_validationFailed; //excelViewModel.ValidationPassed = _validationPassed; model.DataModel = data.OrderBy(x => x.LocalName).ToList(); model.ValidationFailed = _validationFailed; model.ValidationPassed = _validationPassed; model.ValidationPassCount = _validationPassed.Count(); model.ValidationErrorCount = _validationFailed.Count(); SessionWrapper.StoreSession_Model(model); }
//public void StoreSession_Model(ImportViewModelManager list) //{ // SessionState.Store("model", list); //} //public ImportViewModelManager GetSession_Model() //{ // return ((ImportViewModelManager)SessionState.Get("model")); //} public static void StoreSession_Model(ImportViewModelManager list) { HttpContext.Current.Session["model"] = list; }
public ActionResult Index(HttpPostedFileBase file, FormCollection formCollection, string submitButton, IEnumerable <ImportViewModel> model1) { bool isPageSizeChange = false; string pageSizeDDL = string.Empty; if (formCollection.Count > 0) { if (string.IsNullOrEmpty(submitButton)) { foreach (string _formData in formCollection) { if (_formData == "PageSizeSelect") { pageSizeDDL = formCollection[_formData]; isPageSizeChange = true; break; } } } } if (isPageSizeChange) { if (Session["storedevices"] == null) { return(View("Index")); } Int16 pageSize = Convert.ToInt16(pageSizeDDL); ((ImportViewModelManager)(Session["storedevices"])).PageSize = pageSize; } else { if (file == null && formCollection.Count == 0 && submitButton == null) { InvalidFileSelected(); } else if (file != null) { if (Request.Files["file"].ContentLength > 0) { ReadExcelData_backup helper = new ReadExcelData_backup(); bool validate = helper.ValidateFileExtension(file); if (!validate) { InvalidFileSelected(); } else { string fileLocation = Server.MapPath("~/Excel/") + Request.Files["file"].FileName; //store the file name in session... Session.Add("fileLocation", fileLocation); //extract from excel file.... ReadExcelData_backup loadExcelData = new ReadExcelData_backup(); List <ImportViewModel> loadExcelDataList = loadExcelData.LoadDataFromExcel(fileLocation); if (Session["ErrorReadingExcel"] != null) { TempData["type"] = "danger"; TempData["title"] = "Invalid file!"; TempData["message"] = "Its not a valid file."; } ImportViewModelManager model = new ImportViewModelManager(); //validate the data... foreach (var item in loadExcelDataList) { if (item.Location.Contains("DATA CENTER PITTSBURGH")) { item.ValidationViewModel.LocationValidationFailed = "its not exists, wrong location name..."; } if (item.SerialNumber.Length < 10 || item.SerialNumber.Length > 10) { item.ValidationViewModel.SerialNumberValidationFailed = "serial number failed row"; } } model.DataModel = loadExcelDataList; Session["storedevices"] = model; } } } if (submitButton != null) { RemoveFormCollectionData removeItemFC = new RemoveFormCollectionData(); if (submitButton.ToLower() == "save to db") { if (formCollection.Count > 0 && formCollection != null) { if (Session["storedevices"] == null) { return(View("Index")); } //helper.LoadDataFormCollection(formCollection); } } else if (submitButton.ToLower() == "remove item from grid") { if (formCollection.Count > 0 && formCollection != null) { if (Session["storedevices"] == null) { return(View("Index")); } //get the updated data after it remove the items from the list. Session["storedevices"] = removeItemFC.RemoveItemFromGrid(formCollection); } } else { if (Session["storedevices"] == null) { return(View("Index")); } Int16 pageSize = Convert.ToInt16(submitButton); ((ImportViewModelManager)(Session["storedevices"])).PageSize = pageSize; submitButton = null; } } } return(View(Session["storedevices"])); }
private void ValidateExcelData(List <ExcelViewModel> getExcelDataList) { ImportViewModelManager model = new ImportViewModelManager(); ValidationFailedModel validationModel = new ValidationFailedModel(); //foreach (var item in getExcelDataList) //{ // if (item.SerialNumber.Length < 10 || item.SerialNumber.Length > 10 || item.Location.Contains("DATA CENTER PITTSBURGH")) // { // if (item.Location.Contains("DATA CENTER PITTSBURGH")) // { // item.ValidationViewModel.LocationValidationFailed = "its not exists, wrong location name..."; // validationModel.LocalNameValidationFailed = "its not exists, wrong location name..."; // } // if (item.SerialNumber.Length < 10 || item.SerialNumber.Length > 10) // { // item.ValidationViewModel.SerialNumberValidationFailed = "serial number failed row"; // validationModel.SerialNumberValidationFailed = "serial number failed row"; // // // } // item.IsValidationError = true; // } //} List <ExcelViewModel> _validationFailed = new List <ExcelViewModel>(); List <ExcelViewModel> _validationPassed = new List <ExcelViewModel>(); foreach (var item1 in getExcelDataList) { if (item1.IsValidationError) { ExcelViewModel fail = new ExcelViewModel { Location = item1.Location }; _validationFailed.Add(fail); } else { ExcelViewModel pass = new ExcelViewModel { Location = item1.Location }; _validationPassed.Add(pass); } } SessionWrapper.StoreSession_ShowInvalidRecords(_validationFailed); SessionWrapper.StoreSession_ShowValidRecords(_validationPassed); model.DataModel = getExcelDataList; model.ValidationFailed = _validationFailed; model.ValidationPassed = _validationPassed; model.ValidationPassCount = _validationPassed.Count(); model.ValidationErrorCount = _validationFailed.Count(); SessionWrapper.StoreSession_Model(model); //StoreSession_DataModel(model.DataModel); }