public ActionResult Index() { try { var getAllViewModel = _pendingUpload.GetAllPendingUploadRecord(GlobalConst.Records.Skip, GlobalConst.Records.LandingTake); PendingUploadDetail pendingUploadDetail = new PendingUploadDetail(); pendingUploadDetail.PendingUploads = getAllViewModel.PendingUploadDetails.Select(PendingUploads => new PendingUploadRecord().InjectFrom(PendingUploads)).Cast <PendingUploadRecord>().ToList(); pendingUploadDetail.TotalCount = getAllViewModel.TotalCount; return(View(pendingUploadDetail)); } catch (Exception ex) { _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); return(View()); } }
public ActionResult Login(User user) { try { var data = _userBL.GetUserByUserName(user.Username); if (data != null) { if (data.Username == user.Username && _encryptionService.VerifyHashedPassword(user.Password, data.Password) && data.IsActive) { HttpCookie ck = new HttpCookie(GlobalConst.SessionKeys.userDetailMgmt); ck.Values[GlobalConst.SessionKeys.userID] = data.UserID.ToString(); Session[GlobalConst.SessionKeys.userID] = data.UserID.ToString(); ck.Values[GlobalConst.SessionKeys.userName] = data.Username.ToString(); ck.Values[GlobalConst.SessionKeys.UserFullName] = data.Username.ToString();// +' ' + data.LastName.ToString(); Response.Cookies.Add(ck); return(RedirectToAction(GlobalConst.Actions.FileController.FileLanding, GlobalConst.Controllers.File, new { area = GlobalConst.ConstantChar.Blank })); } else if (!data.IsActive) { user.InvalidMsg = GlobalConst.alertMessages.UserNameInactive; } else { user.InvalidMsg = GlobalConst.alertMessages.UserNamePasswordIncorrect; } } else { user.InvalidMsg = GlobalConst.alertMessages.UserNamePasswordIncorrect; } return(View(GlobalConst.Views.User.Index, user)); } catch (Exception ex) { user.InvalidMsg = GlobalConst.alertMessages.ExceptionOccured; _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); return(View(GlobalConst.Views.User.Index, user)); } }
public ActionResult Index() { OCRFileSearchViewModel ocrFileSearcViewModel = new OCRFileSearchViewModel(); try { var ocr = _ocr.GetAllOCRRecords(GlobalConst.ConstantChar.Percentage, GlobalConst.Records.Skip, GlobalConst.Records.LandingTake); // ie <ocr> ocrFileSearcViewModel.OCRSearchResult = Mapper.Map <IEnumerable <OCRModel> >(ocr.OCRDetails); ocrFileSearcViewModel.OCRCount = ocr.TotalCount; } catch (Exception ex) { _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); } return(View(ocrFileSearcViewModel)); }
public ActionResult ImportExcel(HttpPostedFileBase uploadFile, int DepartmentId) { var guid = GlobalConst.CommonValues.Zero; PendingUpload objpendingUpload = new PendingUpload(); try { //Upload and save the file //For checking purpose HttpPostedFileBase File = Request.Files[GlobalConst.ConstantChar.UploadFile]; string excelPath = Path.Combine(Server.MapPath(ConfigurationManager.AppSettings[GlobalConst.ConstantChar.StoragePath].ToString()), GlobalConst.ConstantChar.ExcelUploads, Path.GetFileNameWithoutExtension(uploadFile.FileName) + Guid.NewGuid().ToString() + Path.GetExtension(uploadFile.FileName)); _excelUploadService.CreateExcelUploadFolder(Server.MapPath(ConfigurationManager.AppSettings[GlobalConst.ConstantChar.StoragePath].ToString()), GlobalConst.ConstantChar.ExcelUploads); File.SaveAs(excelPath); objpendingUpload.PendingUploadName = Path.GetFileName(uploadFile.FileName); objpendingUpload.UserId = Convert.ToInt32(Request.Cookies[GlobalConst.SessionKeys.userDetailMgmt].Values[GlobalConst.SessionKeys.userID]); objpendingUpload.DepartmentId = DepartmentId; objpendingUpload.PendingUploadDate = DateTime.Now; guid = _pendingUpload.AddPendingUploadRecord(Mapper.Map <LMGEDI.Core.Data.Model.PendingUpload>(objpendingUpload)); //for adding Row to Pending Upload table return id objpendingUpload.PendingUploadId = guid; objpendingUpload.IsDeleted = false; DataTable importedData = ImportExcelSheet(excelPath, guid, DepartmentId); if (importedData.Rows.Count > GlobalConst.CommonValues.Zero) { //Read the Header From Excel List <DomainModelExcel.ExcelHeader> listColumn = ImportExcelSheetHeader(excelPath); IEnumerable <ExcelHeader> modelExcelHeaderData = listColumn; //This is use for fetching Temp Data table var ColumnTableName = (objpendingUpload.DepartmentId == GlobalConst.CommonValues.Five ? _file.GetAllColumnNameFromTblUploadTempsContractor() : _file.GetAllColumnNameFromTblUploadTemps()); //Add Database Column Header into Model IEnumerable <TempExcelDataColumns> modelTempExcelData = Mapper.Map <IEnumerable <TempExcelDataColumns> >(ColumnTableName); // Insert Into Database with SQLBulkCopy string consString = ConfigurationManager.ConnectionStrings[GlobalConst.Configuration.ContextClass].ConnectionString; using (SqlConnection con = new SqlConnection(consString)) { using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con)) { //Set the database table name if (objpendingUpload.DepartmentId == GlobalConst.CommonValues.Five) { sqlBulkCopy.DestinationTableName = GlobalConst.ExcelTempTables.ExcelUploadContractorTables; } else { sqlBulkCopy.DestinationTableName = GlobalConst.ExcelTempTables.ExcelUploadTables; } //[OPTIONAL]: Map the Excel columns with that of the database table Dictionary <string, string> mapColumns = MakeMappingColumns(modelExcelHeaderData, modelTempExcelData); foreach (var mapping in mapColumns) { sqlBulkCopy.ColumnMappings.Add(mapping.Key, mapping.Value); } con.Open(); sqlBulkCopy.BatchSize = GlobalConst.CommonValues.SQLBatchSize; sqlBulkCopy.BulkCopyTimeout = GlobalConst.CommonValues.SQLTimeOut; sqlBulkCopy.WriteToServer(importedData); con.Close(); } } if ((System.IO.File.Exists(excelPath))) { System.IO.File.Delete(excelPath); } } else { objpendingUpload.PendingUploadId = guid; objpendingUpload.IsDeleted = true; } } catch (Exception ex) { _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); objpendingUpload.PendingUploadId = guid; objpendingUpload.IsDeleted = true; } return(Json(objpendingUpload, GlobalConst.ContentTypes.TextHtml)); }
public ActionResult Index(int id) { if (id != int.Parse(GlobalConst.ConstantChar.Zero)) { FileDetailViewModel FileDetailViewModel = new FileDetailViewModel(); try { FileDetailViewModel.FileDetail = Mapper.Map <FileDetail>(_fileBL.GetFileDetailByFileId(id)); if (FileDetailViewModel.FileDetail != null) { FileDetailViewModel.FileDetail.Departments = Mapper.Map <IEnumerable <Department> >(_department.GetDepartment()); FileDetailViewModel.FileDetail.States = Mapper.Map <IEnumerable <State> >(_stateBL.GetState()); //else{ // FileDetailViewModel.FileDetail.Departments = Mapper.Map<IEnumerable<Department>>(_department.GetDepartment().Where(x => x.DepartmentId != 5)); //} var getAllInvoices = _invoice.GetInvoiceRecordByFileId(FileDetailViewModel.FileDetail.FileID, GlobalConst.Records.Skip, GlobalConst.Records.Take); if (FileDetailViewModel.FileDetail.IsLienAdjusterID) { FileDetailViewModel.FileDetail.AdjusterDetails = Mapper.Map <AdjusterSearch>(_adjusterBL.GetLienAdjusterByAdjusterID(FileDetailViewModel.FileDetail.AdjusterId)); } else { FileDetailViewModel.FileDetail.AdjusterDetails = Mapper.Map <AdjusterSearch>(_adjusterBL.GetAdjusterByAdjusterID(FileDetailViewModel.FileDetail.AdjusterId)); } InvoiceViewModel InvoiceViewModel = new LMGEDIApp.Domain.Models.InvoiceModel.InvoiceViewModel(); InvoiceViewModel.InvoiceDetails = getAllInvoices.InvoiceDetails.Select(InvoiceResult => new Invoice().InjectFrom(InvoiceResult)).Cast <Invoice>().ToList(); InvoiceViewModel.InvoiceCount = getAllInvoices.TotalCount; FileDetailViewModel.InvoiceViewModel = InvoiceViewModel; return(View(FileDetailViewModel)); } else { return(View()); } } catch (Exception ex) { _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); return(View()); } } else { return(View()); } }