//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);
}
