public static T Resolve <T>(this T candidateViewModel, ApplicationDetail applicationDetail)
where T : CandidateViewModelBase
{
candidateViewModel.Id = applicationDetail.CandidateId;
candidateViewModel.EmailAddress = applicationDetail.CandidateDetails.EmailAddress;
candidateViewModel.FirstName = applicationDetail.CandidateDetails.FirstName;
candidateViewModel.LastName = applicationDetail.CandidateDetails.LastName;
candidateViewModel.DateOfBirth = applicationDetail.CandidateDetails.DateOfBirth;
candidateViewModel.PhoneNumber = applicationDetail.CandidateDetails.PhoneNumber;
candidateViewModel.Address = ApplicationConverter.GetAddressViewModel(applicationDetail.CandidateDetails.Address);
candidateViewModel.Qualifications = ApplicationConverter.GetQualificationsViewModels(applicationDetail.CandidateInformation.Qualifications);
candidateViewModel.HasQualifications = candidateViewModel.Qualifications.Any();
candidateViewModel.WorkExperience = ApplicationConverter.GetWorkExperiencesViewModels(applicationDetail.CandidateInformation.WorkExperience);
candidateViewModel.HasWorkExperience = candidateViewModel.WorkExperience.Any();
candidateViewModel.TrainingCourses = ApplicationConverter.GetTrainingCourseViewModels(applicationDetail.CandidateInformation.TrainingCourses);
candidateViewModel.HasTrainingCourses = candidateViewModel.TrainingCourses.Any();
candidateViewModel.MonitoringInformation = ApplicationConverter.GetMonitoringInformationViewModel(applicationDetail.CandidateInformation.AboutYou, applicationDetail.CandidateInformation.DisabilityStatus);
candidateViewModel.EmployerQuestionAnswers = new EmployerQuestionAnswersViewModel
{
CandidateAnswer1 = applicationDetail.AdditionalQuestion1Answer,
CandidateAnswer2 = applicationDetail.AdditionalQuestion2Answer
};
return(candidateViewModel);
}
public ActionResult Index(ApplicationDetail model, string Search, string Update)
{
//var list = appDBContext.ApplicationDetails.ToList();
Session["AppID"] = null;
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == model.ApplicationId
select m).FirstOrDefault();
Session["AppID"] = model.ApplicationId;
ModelState.Clear();
if (Search == null)
{
appdetails.Channel = model.Channel;
appdetails.LoanCurrency = model.LoanCurrency;
appdetails.ApplicationDate = model.ApplicationDate;
appdetails.Status = model.Status;
appdetails.RequestedAmount = model.RequestedAmount;
appdetails.Product = model.Product;
appdetails.InterestRate = model.InterestRate;
appdetails.Association = model.Association;
appdetails.LoanOfficer = model.LoanOfficer;
appdetails.Tenure = model.Tenure;
appdetails.SalesAgent = model.SalesAgent;
TempData["msg"] = "<script>alert('Collateral Details Updated Sucessfully');</script>";
appDBContext.SaveChanges();
}
return(View(appdetails));
}
public static T Resolve <T>(this T candidateViewModel, ApplicationDetail apprenticeshipApplicationDetail)
where T : CandidateViewModelBase
{
candidateViewModel.Id = apprenticeshipApplicationDetail.CandidateId;
candidateViewModel.EmailAddress = apprenticeshipApplicationDetail.CandidateDetails.EmailAddress;
candidateViewModel.FirstName = apprenticeshipApplicationDetail.CandidateDetails.FirstName;
candidateViewModel.LastName = apprenticeshipApplicationDetail.CandidateDetails.LastName;
candidateViewModel.DateOfBirth = apprenticeshipApplicationDetail.CandidateDetails.DateOfBirth;
candidateViewModel.PhoneNumber = apprenticeshipApplicationDetail.CandidateDetails.PhoneNumber;
candidateViewModel.Address =
ApplicationConverter.GetAddressViewModel(apprenticeshipApplicationDetail.CandidateDetails.Address);
candidateViewModel.Qualifications =
ApplicationConverter.GetQualificationsViewModels(apprenticeshipApplicationDetail.CandidateInformation.Qualifications);
candidateViewModel.HasQualifications =
ApplicationConverter.GetQualificationsViewModels(apprenticeshipApplicationDetail.CandidateInformation.Qualifications)
.Any();
candidateViewModel.WorkExperience =
ApplicationConverter.GetWorkExperiencesViewModels(apprenticeshipApplicationDetail.CandidateInformation.WorkExperience);
candidateViewModel.HasWorkExperience =
ApplicationConverter.GetWorkExperiencesViewModels(apprenticeshipApplicationDetail.CandidateInformation.WorkExperience)
.Any();
candidateViewModel.EmployerQuestionAnswers = new EmployerQuestionAnswersViewModel
{
CandidateAnswer1 = apprenticeshipApplicationDetail.AdditionalQuestion1Answer,
CandidateAnswer2 = apprenticeshipApplicationDetail.AdditionalQuestion2Answer
};
return(candidateViewModel);
}
public async Task <IActionResult> Create([Bind("ID,Concept,ConceptStatusID,SalesGenerated,SalesGeneratedInformation,BusinessStageID,BusinessIdeaDescription,HasPrototypeOrIntellectualProperty,PrototypeDescription,BusinessTypeID,MarketOpportunity,EvidenceOfViableOpportunity,CustomerDescription,MarketingAndSales,BusinessCosts,CompetitionDescription,TeamDescription,SpecificRequest")] ApplicationDetail applicationDetail)
{
if (ModelState.IsValid)
{
// Create the Application
Application application = new Application();
application.DateApplied = DateTime.Now;
var applicationStatus = _context.ApplicationStatuses
.Where(a => a.Description == "Applicantion in work").FirstOrDefault <ApplicationStatus>();
application.ApplicationStatus = applicationStatus;
// Add Date to applicationDetails
applicationDetail.DateChanged = DateTime.Now;
// Add the rows to the database.
_context.Add(application);
await _context.SaveChangesAsync();
applicationDetail.Application = application;
_context.Add(applicationDetail);
// _context.Applications.Add(application);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BusinessStageID"] = new SelectList(_context.BusinessStages, "ID", "BusinessStageDescription", applicationDetail.BusinessStageID);
ViewData["BusinessTypeID"] = new SelectList(_context.BusinessTypes, "ID", "BusinessTypeDescription", applicationDetail.BusinessTypeID);
ViewData["ConceptStatusID"] = new SelectList(_context.ConceptStatuses, "ID", "ConceptStatusDescription", applicationDetail.ConceptStatusID);
return(View(applicationDetail));
}
public ActionResult ApplicanDetails(ApplicationDetail model)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
appdetails.RelationshipType = model.RelationshipType;
appdetails.SSN = model.SSN;
appdetails.City = model.City;
appdetails.State = model.State;
appdetails.Suffix = model.Suffix;
appdetails.FirstName = model.FirstName;
appdetails.MiddleName = model.MiddleName;
appdetails.LastName = model.LastName;
appdetails.DOB = model.DOB;
appdetails.Address1 = model.Address1;
appdetails.Address2 = model.Address2;
appdetails.PinCode = model.PinCode;
appDBContext.SaveChanges();
TempData["msg"] = "<script>alert('Collateral Details Updated Sucessfully');</script>";
return(View(appdetails));
}
public void InsertApplication(BOApplicationDetail BOApplication)
{
ApplicationDetail App = new ApplicationDetail()
{
AppId = BOApplication.AppId,
Answer = BOApplication.Answer,
QueId = BOApplication.QueId,
};
AwardDBEntities.ApplicationDetails.Add(App);
}
public void UpdateApplication(BOApplicationDetail BOApplication)
{
// This Update Method Access by only Admin and Admin can change only Stage part
ApplicationDetail App = new ApplicationDetail()
{
AppId = BOApplication.AppId,
Answer = BOApplication.Answer,
QueId = BOApplication.QueId,
};
AwardDBEntities.Entry(App).State = EntityState.Modified;
}
private void btnOneceRecive_Click(object sender, EventArgs e)
{
if (applicationInfo.CtrlID != null)
{
ApplicationDetail applicationDetail = new ApplicationDetail();
DataTable AddApplicationDT = applicationDetail.SelectDeliverDetailByCtrlID(applicationInfo.CtrlID);
DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID(applicationInfo.CtrlID);
applicationDetail.UpdateReceiptDetail(AddApplicationDT);
applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
applicationInfo.ReceiptConfirm(applicationInfo.CtrlID, "一键自动收货!", Login.LoginUser, 1);
SendEmailtoWuliu();
}
}
public ActionResult ApplicanDetails()
{
if (Session["AppID"] != null)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
return(View(appdetails));
}
return(View());
}
public ActionResult CreditScoring(ApplicationDetail model)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
appdetails.CreditScore = model.CreditScore;
appdetails.AutoDecision = model.AutoDecision;
appDBContext.SaveChanges();
TempData["msg"] = "<script>alert('Credit Scoring Updated Sucessfully');</script>";
return(View(appdetails));
}
// GET: Menu
public ActionResult Index()
{
if (Session["AppID"] != null)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
return(View(appdetails));
}
//var list = appDBContext.ApplicationDetails.ToList();
//return View("~/Views/Menu/Index.cshtml", list[0]);
return(View());
}
// Get by ID
public ApplicationDetail GetApplicationDetail(int id)
{
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.Applications.Single(e => e.Id == id);
var detailedApplication = new ApplicationDetail
{
Id = entity.Id,
HousingId = entity.HousingId,
ApplicantId = entity.ApplicantId,
FirstName = entity.FirstName,
LastName = entity.LastName,
MonthlyIncome = entity.MonthlyIncome
};
return(detailedApplication);
}
}
public ActionResult CollateralDetails(ApplicationDetail model)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
appdetails.AssetType = model.AssetType;
appdetails.AssetID = model.AssetID;
appdetails.CollateralAddress = model.CollateralAddress;
appdetails.Country = model.Country;
appDBContext.SaveChanges();
TempData["msg"] = "<script>alert('Collateral Details Updated Sucessfully');</script>";
return(View(appdetails));
}
public ActionResult RequestDetails(ApplicationDetail model)
{
string AppID = Session["AppID"].ToString();
ApplicationDetail appdetails = (from m in appDBContext.ApplicationDetails
where m.ApplicationId == AppID
select m).FirstOrDefault();
ModelState.Clear();
appdetails.RequestedAmount = model.RequestedAmount;
appdetails.InterestRate = model.InterestRate;
appdetails.Tenure = model.Tenure;
appdetails.Product = model.Product;
appDBContext.SaveChanges();
TempData["msg"] = "<script>alert('Collateral Details Updated Sucessfully');</script>";
return(View(appdetails));
}
private void btnOneceRecive_Click(object sender, EventArgs e)
{
if (applicationInfo.CtrlID != null && (applicationInfo.AppState == 3 || applicationInfo.AppState == 4))
{
ApplicationDetail applicationDetail = new ApplicationDetail();
DataTable AddApplicationDT = applicationDetail.SelectDeliverDetailByCtrlID(applicationInfo.CtrlID);
DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID(applicationInfo.CtrlID);
applicationDetail.DeleteReceiptDetail(AddApplicationDT);
applicationDetail.InsertReceiptDetail(AddApplicationDT);
applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
applicationInfo.ReceiptConfirm(applicationInfo.CtrlID, "一键自动收货!", Login.LoginUser, 1);
SendEmailtoWuliu();
MessageBox.Show("订单号:" + applicationInfo.CtrlID + "一键自动收货成功!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("订单号错误,或订单状态错误!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public async Task <IActionResult> Edit(int id,
[Bind("Concept,ConceptStatusID,SalesGenerated,SalesGeneratedInformation,BusinessStageID,BusinessIdeaDescription,HasPrototypeOrIntellectualProperty,PrototypeDescription,BusinessTypeID,MarketOpportunity,EvidenceOfViableOpportunity,CustomerDescription,MarketingAndSales,BusinessCosts,CompetitionDescription,TeamDescription,SpecificRequest")] ApplicationDetail applicationDetail)
{
/*if (id != applicationDetail.ID)
* {
* return NotFound();
* }*/
if (ModelState.IsValid)
{
try
{
// find the application to connect it to.
var oldApplicationDetails = _context.ApplicationDetails
.Where(ad => ad.ID == id).FirstOrDefault <ApplicationDetail>();
// Connect the new applicationDetail to the existing application.
applicationDetail.Application = oldApplicationDetails.Application;
applicationDetail.ApplicationID = oldApplicationDetails.ApplicationID;
applicationDetail.DateChanged = DateTime.Now;
_context.ApplicationDetails.Update(applicationDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IdeaApplicationExists(applicationDetail.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BusinessStageID"] = new SelectList(_context.BusinessStages, "ID", "BusinessStageDescription", applicationDetail.BusinessStageID);
ViewData["BusinessTypeID"] = new SelectList(_context.BusinessTypes, "ID", "BusinessTypeDescription", applicationDetail.BusinessTypeID);
ViewData["ConceptStatusID"] = new SelectList(_context.ConceptStatuses, "ID", "ConceptStatusDescription", applicationDetail.ConceptStatusID);
return(View(applicationDetail));
}
public SalesBillPrint()
{
PrintDialog pd = new PrintDialog();
string strDefaultPrinter = pd.PrinterSettings.PrinterName;//Code to get default printer name
_pdoc = new PrintDocument();
PrinterSettings ps = new PrinterSettings();
Font font = new Font("Courier New", 15);//set default font for page
//PaperSize psize = new PaperSize("Custom", 212, 130);//set paper size sing code
//PaperSize psize = new PaperSize("Custom", 212, 100);
pd.Document = _pdoc;
//pd.Document.DefaultPageSettings.PaperSize = psize;
_pdoc.PrintPage += new PrintPageEventHandler(PrintPage);
var printFileName = ConfigurationManager.AppSettings["PrintFileName"];
var printerName = ConfigurationManager.AppSettings["BillPrinter"];
if (!string.IsNullOrWhiteSpace(printFileName))
{
pd.PrinterSettings.PrintToFile = true;
pd.PrinterSettings.PrintFileName = printFileName;
}
else if (!string.IsNullOrWhiteSpace(printerName))
{
//string defaultPrinterName = ps.PrinterName; // Code to get default printer
//var printerNamePc1 = "\\\\pc01\\EPSON LX-300+ /II";
//ps.PrinterName = printerName;
pd.PrinterSettings.PrinterName = printerName;
}
else
{
Utilities.Utility.ShowErrorBox("Billing printer name is not configured");
}
RMSEntitiesHelper.Instance.RMSEntities.ApplicationDetails.Count();
_appDetail = RMSEntitiesHelper.Instance.RMSEntities.ApplicationDetails.FirstOrDefault();
}
public IHttpActionResult CreatingApplication(string ApplicationName)
{
try
{
if (ApplicationName != null)
{
var application = new ApplicationDetail();
application.ApplicationName = ApplicationName;
db.ApplicationDetails.Add(application);
db.SaveChanges();
return(Ok(application));
}
else
{
return(Ok("Application Name is required"));
}
}
catch (Exception ex)
{
return(NotFound());
}
}
public Boolean boolCampareOrder(string _ctrlID)
{
Boolean boolResult = false;
DataTable DeliverDetailTable;
DataTable ReceiptDetailTable;
DataTable AppDetailTable;
ApplicationInfo applicationInfo = new ApplicationInfo();
ApplicationDetail applicationDetail = new ApplicationDetail();
//dgvDevilerDetails.AutoGenerateColumns = false;
//dgvReceiptDetails.AutoGenerateColumns = false;
DeliverDetailTable = applicationDetail.SelectDeliverDetailByCtrlID(_ctrlID);
ReceiptDetailTable = applicationDetail.SelectReceiptDetailByCtrlID(_ctrlID);
AppDetailTable = applicationDetail.SelectAppDetailByCtrlID(_ctrlID);
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
foreach (DataRow recdr in ReceiptDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == ReceiptDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done;
}
else
{
boolResult = true;
}
}
done:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow recdr in ReceiptDetailTable.Rows)
{
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == ReceiptDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done2;
}
else
{
boolResult = true;
}
}
done2:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
foreach (DataRow recdr in AppDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == AppDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done3;
}
else
{
boolResult = true;
}
}
done3:
if (boolResult)
{
goto Finish;
}
}
foreach (DataRow recdr in AppDetailTable.Rows)
{
foreach (DataRow deldr in DeliverDetailTable.Rows)
{
if (DeliverDetailTable.Rows.Count == AppDetailTable.Rows.Count && deldr["ItemID2"].ToString() == recdr["ItemID2"].ToString() && deldr["ItemID"].ToString() == recdr["ItemID"].ToString() && deldr["App_Count"].ToString() == recdr["App_Count"].ToString() && deldr["ItemHighlight"].ToString() == recdr["ItemHighlight"].ToString())
{
boolResult = false;
goto done4;
}
else
{
boolResult = true;
}
}
done4:
if (boolResult)
{
goto Finish;
}
}
Finish:
return(boolResult);
}
public FileResult ExportAllApplications()
{
var wildcatMicroFundDatabaseContext = _context.Applications
.Include(i => i.User)
.Include(i => i.ApplicationStatus)
.Include(i => i.ApplicationDetails);
List <Application> Applications = wildcatMicroFundDatabaseContext.ToList();
//Insert the Column Names.
StringBuilder sb = new StringBuilder();
sb.Append("ID, First Name, Last Name, Ethicity, Gender, Business Name ,Idea Description , Costs, Marketing, Concept, Sales Generated,IntellectualProperty, ");
sb.Append("\r\n");
for (int i = 0; i < Applications.Count; i++)
{
//Append data with separator.
sb.Append(Applications[i].ID.ToString() + ',');
if (Applications[i].User != null)
{
sb.Append(Applications[i].User.FirstName + ',');
sb.Append(Applications[i].User.LastName + ',');
sb.Append(Applications[i].User.Ethnicity.EthnicityDescription + ',');
sb.Append(Applications[i].User.Gender.Description + ',');
}
else
{
sb.Append("null ,");
sb.Append("null ,");
sb.Append("null ,");
sb.Append("null ,");
}
if (Applications[i].Business != null)
{
sb.Append(Applications[i].Business.BusinessName + ',');
}
else
{
sb.Append("null ,");
}
ApplicationDetail lastAppDetail = Applications[i].ApplicationDetails.Last();
sb.Append(lastAppDetail.BusinessIdeaDescription + ',');
sb.Append(lastAppDetail.BusinessCosts + ',');
sb.Append(lastAppDetail.MarketingAndSales + ',');
sb.Append(lastAppDetail.Concept + ',');
if (lastAppDetail.SalesGenerated)
{
sb.Append("Yes,");
}
else
{
sb.Append("No,");
}
if (lastAppDetail.HasPrototypeOrIntellectualProperty)
{
sb.Append("Yes,");
}
else
{
sb.Append("No,");
}
//Append new line character.
sb.Append("\r\n");
}
return(File(Encoding.UTF8.GetBytes(sb.ToString()), "text/csv", "Grid.csv"));
}
