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