public GenericValidator EditCompany(ImporterObject company) { var gVal = new GenericValidator(); try { var appStatus = new ImporterServices().UpdateImporter(company); if (appStatus < 1) { gVal.Code = -1; gVal.Error = appStatus == -2 ? "Company failed. Please try again." : "Company Information already exists"; return(gVal); } gVal.Code = appStatus; gVal.Error = "Company was successfully updated."; return(gVal); } catch (Exception) { gVal.Error = "Company processing failed. Please try again later"; gVal.Code = -1; return(gVal); } }
public long UpdateImporter(ImporterObject importer) { try { if (importer == null) { return(-2); } var importerEntity = ModelMapper.Map <ImporterObject, Importer>(importer); if (importerEntity == null || importerEntity.Id < 1) { return(-2); } using (var db = new ImportPermitEntities()) { db.Importers.Attach(importerEntity); db.Entry(importerEntity).State = EntityState.Modified; db.SaveChanges(); return(importer.Id); } } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public long UpdateImporter(ImporterObject importer) { try { return(_importerManager.UpdateImporter(importer)); } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public long AddImporterAndPerson(ImporterObject importer, PersonObject person, out long importerId) { try { return(_importerManager.AddImporterAndPerson(importer, person, out importerId)); } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); importerId = 0; return(0); } }
public ActionResult AddBank(BankObject bank) { var gVal = new GenericValidator(); try { var validationResult = ValidateBank(bank); if (validationResult.Code == 1) { return(Json(validationResult, JsonRequestBehavior.AllowGet)); } var company = new ImporterObject { Id = 0, Name = bank.Name, TIN = bank.TIN, RCNumber = bank.RCNumber, IsActive = true, DateAdded = DateTime.Now.ToString("dd/MM/yyyy") }; var cmStatus = AddCompany(company); if (cmStatus.Code < 1) { return(Json(cmStatus, JsonRequestBehavior.AllowGet)); } bank.ImporterId = cmStatus.Code; var appStatus = new BankServices().AddBank(bank); if (appStatus < 1) { validationResult.Code = -1; validationResult.Error = appStatus == -2 ? "Bank processing failed. Please try again." : "Bank Information already exists"; return(Json(validationResult, JsonRequestBehavior.AllowGet)); } gVal.Code = appStatus; gVal.Error = "Bank was successfully added."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Error = "Bank processing failed. Please try again later"; gVal.Code = -1; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public long AddImporter(ImporterObject importer) { try { if (importer == null) { return(-2); } var importerEntity = ModelMapper.Map <ImporterObject, Importer>(importer); if (string.IsNullOrEmpty(importerEntity.Name)) { return(-2); } using (var db = new ImportPermitEntities()) { long importerId = 0; if (db.Importers.Any()) { var existing = db.Importers.OrderByDescending(i => i.Id).Take(1).ToList(); if (!existing.Any()) { importerId = 1; } else { importerId = existing[0].Id + 1; } } else { importerId = 1; } importerEntity.Id = importerId; var returnStatus = db.Importers.Add(importerEntity); db.SaveChanges(); return(returnStatus.Id); } } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); return(0); } }
public ActionResult EditBank(BankObject bank) { var gVal = new GenericValidator(); try { var stat = ValidateBank(bank); if (stat.Code < 1) { return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (Session["_bank"] == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var oldbank = Session["_bank"] as BankObject; if (oldbank == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var company = new ImporterObject { Id = oldbank.ImporterId, Name = bank.Name, TIN = bank.TIN, RCNumber = bank.RCNumber }; var cmStatus = EditCompany(company); if (cmStatus.Code < 1) { return(Json(cmStatus, JsonRequestBehavior.AllowGet)); } oldbank.Name = bank.Name; oldbank.NotificationEmail = bank.NotificationEmail; oldbank.SortCode = bank.SortCode; var docStatus = new BankServices().UpdateBank(oldbank); if (docStatus < 1) { gVal.Code = -1; gVal.Error = docStatus == -3 ? "Bank already exists." : "Bank information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } gVal.Code = oldbank.BankId; gVal.Error = "Bank information was successfully updated"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Code = -1; gVal.Error = "Bank information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public long AddImporterAndPerson(ImporterObject importer, PersonObject person, out long importerId) { try { if (importer == null || person == null) { importerId = 0; return(-2); } long personId; using (var db = new ImportPermitEntities()) { var existings = db.Importers.Where(i => i.Name.ToLower() == importer.Name.ToLower() || i.RCNumber.ToLower().Replace("rc", "") == importer.RCNumber.ToLower().Replace("rc", "") || i.TIN.ToLower().Replace("tin", "") == importer.TIN.ToLower().Replace("tin", "")).ToList(); if (existings.Any()) { importerId = existings[0].Id; } else { importerId = 0; } var impId = importerId; var existingPeople = db.People.Where(i => i.FirstName.ToLower() == person.FirstName.ToLower() && i.LastName.ToLower() == person.LastName.ToLower() && i.ImporterId == impId).ToList(); if (existingPeople.Any()) { personId = existingPeople[0].Id; } else { personId = 0; } if (importerId > 0 && personId > 0) { return(personId); } var importerEntity = ModelMapper.Map <ImporterObject, Importer>(importer); if (importerEntity == null || string.IsNullOrEmpty(importerEntity.Name)) { importerId = 0; return(-2); } var personEntity = ModelMapper.Map <PersonObject, Person>(person); if (personEntity == null || string.IsNullOrEmpty(importerEntity.Name)) { importerId = 0; return(-2); } if (importerId < 1) { var importerInfo = db.Importers.Add(importerEntity); db.SaveChanges(); importerId = importerInfo.Id; } if (personId < 1) { personEntity.ImporterId = importerId; var prs = db.People.Add(personEntity); db.SaveChanges(); personId = prs.Id; } return(personId); } } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); importerId = 0; return(0); } }