public void Copy(Entities.Form source, Entities.DynamicForm destination)
{
destination.Html = (source?.Html) ?? String.Empty;
destination.Nodes = AutoMapper.Mapper.Map <List <Entities.DynamicForm.Node> >(source.Nodes);
destination.Lines = AutoMapper.Mapper.Map <List <Entities.DynamicForm.Line> >(source.Lines);
destination.Areas = AutoMapper.Mapper.Map <List <Entities.DynamicForm.Area> >(source.Areas);
}
public void UpdateForm(Entities.Form form)
{
var db = new ApplicationDbContext();
if (form.FormId == 0)
{
db.Forms.Add(form);
}
else
{
var dbEntry = db.Forms.Find(form.FormId);
if (dbEntry != null)
{
dbEntry = form;
//dbEntry.ActualSalesFour = form.ActualSalesFour;
//dbEntry.ActualSalesFive = form.ActualSalesFive;
//dbEntry.ActualSalesSix = form.ActualSalesSix;
//dbEntry.ActualSalesSeven = form.ActualSalesSeven;
//dbEntry.ActualSalesEight = form.ActualSalesEight;
//dbEntry.ActualGcFour = form.ActualGcFour;
//dbEntry.ActualGcFive = form.ActualGcFive;
//dbEntry.ActualGcSix = form.ActualGcSix;
//dbEntry.ActualGcSeven = form.ActualGcSeven;
//dbEntry.ActualGcEight = form.ActualGcEight;
//dbEntry.PosiDonations = form.PosiDonations;
//dbEntry.Notes = form.Notes;
}
}
db.SaveChanges();
}
public void UpdateForm(Entities.Form sec3)
{
var db = new CapstoneDbContext();
if (sec3.FormId == 0)
{
db.Forms.Add(sec3);
}
else
{
var dbEntry = db.Forms.Find(sec3.FormId);
if (dbEntry != null)
{
dbEntry.ActualSalesFour = sec3.ActualSalesFour;
dbEntry.ActualSalesFive = sec3.ActualSalesFive;
dbEntry.ActualSalesSix = sec3.ActualSalesSix;
dbEntry.ActualSalesSeven = sec3.ActualSalesSeven;
dbEntry.ActualSalesEight = sec3.ActualSalesEight;
dbEntry.ActualGcFour = sec3.ActualGcFour;
dbEntry.ActualGcFive = sec3.ActualGcFive;
dbEntry.ActualGcSix = sec3.ActualGcSix;
dbEntry.ActualGcSeven = sec3.ActualGcSeven;
dbEntry.ActualGcEight = sec3.ActualGcEight;
dbEntry.PosiDonations = sec3.PosiDonations;
dbEntry.Notes = sec3.Notes;
}
db.SaveChanges();
}
}
public async Task <Entities.Form> Create(Entities.Form form)
{
await _context.Forms.AddAsync(form);
await _context.SaveChangesAsync();
return(form);
}
public async Task <Entities.Form> Update(Entities.Form newForm)
{
var form = await _context.Forms.FindAsync(newForm.Id);
if (form == null)
{
return(null);
}
if (newForm.Id != form.Id)
{
return(null);
}
_context.Forms.Update(newForm);
await _context.SaveChangesAsync();
return(newForm);
}
public static Form ToModel(this Entities.Form entity, IMapper mapper)
{
return(mapper.Map <Form>(entity));
}
public async Task <FormDTO> Handle(AddFormQuery message, CancellationToken cancellationToken)
{
try
{
var newForm = new Entities.Form
{
Code = string.Empty,
CurrentVersion = 1,
Description = message.Form.Description,
FormSections = new List <FormSection>(),
Draft = message.Form.Draft,
Order = 0,
Type = message.Form.Type,
CreatedByUserId = message.UserId,
Date = DateTime.UtcNow
};
foreach (var fs in message.Form.FormSections)
{
var formSection = new FormSection
{
Code = fs.Title,
Description = fs.Description,
Questions = new List <Question>()
};
foreach (var q in fs.Questions)
{
var question = new Question {
QuestionType = q.QuestionType, Hint = q.Hint, Text = q.Text
};
var optionsForQuestion = new List <OptionToQuestion>();
foreach (var o in q.OptionsToQuestions)
{
if (o.IdOption > 0)
{
var existingOption = _context.Options.FirstOrDefault(option => option.OptionId == o.IdOption);
optionsForQuestion.Add(new OptionToQuestion {
Option = existingOption
});
}
else
{
optionsForQuestion.Add(_mapper.Map <OptionToQuestion>(o));
}
}
question.OptionsToQuestions = optionsForQuestion;
formSection.Questions.Add(question);
}
newForm.FormSections.Add(formSection);
}
_context.Forms.Add(newForm);
await _context.SaveChangesAsync();
message.Form.Id = newForm.FormId;
return(message.Form);
}
catch (Exception ex) {
_logger.LogError(ex.Message);
throw ex;
}
}
public void UpdateForm(Entities.Form form)
{
var db = new ApplicationDbContext();
if (form.FormId == 0)
{
db.Forms.Add(form);
}
else
{
var dbEntry = db.Forms.Find(form.FormId);
if (dbEntry != null)
{
dbEntry.FormId = form.FormId;
dbEntry.ActualAverageCheck_45 = form.ActualAverageCheck_45;
dbEntry.ActualAverageCheck_56 = form.ActualAverageCheck_56;
dbEntry.ActualAverageCheck_67 = form.ActualAverageCheck_67;
dbEntry.ActualAverageCheck_78 = form.ActualAverageCheck_78;
dbEntry.ActualAverageCheck_89 = form.ActualAverageCheck_89;
dbEntry.ActualAverageCheckTotal = form.ActualAverageCheckTotal;
dbEntry.ActualGuestCount_45 = form.ActualGuestCount_45;
dbEntry.ActualGuestCount_56 = form.ActualGuestCount_56;
dbEntry.ActualGuestCount_67 = form.ActualGuestCount_67;
dbEntry.ActualGuestCount_78 = form.ActualGuestCount_78;
dbEntry.ActualGuestCount_89 = form.ActualGuestCount_89;
dbEntry.ActualGuestCountTotal = form.ActualGuestCountTotal;
dbEntry.ActualSales_45 = form.ActualSales_45;
dbEntry.ActualSales_56 = form.ActualSales_56;
dbEntry.ActualSales_67 = form.ActualSales_67;
dbEntry.ActualSales_78 = form.ActualSales_78;
dbEntry.ActualSales_89 = form.ActualSales_89;
dbEntry.ActualSalesTotal = form.ActualSalesTotal;
dbEntry.Average_45_GuestCount = form.Average_45_GuestCount;
dbEntry.Average_45_Sales = form.Average_45_Sales;
dbEntry.Average_56_GuestCount = form.Average_56_GuestCount;
dbEntry.Average_56_Sales = form.Average_56_Sales;
dbEntry.Average_67_GuestCount = form.Average_67_GuestCount;
dbEntry.Average_67_Sales = form.Average_67_Sales;
dbEntry.Average_78_GuestCount = form.Average_78_GuestCount;
dbEntry.Average_78_Sales = form.Average_78_Sales;
dbEntry.Average_89_GuestCount = form.Average_89_GuestCount;
dbEntry.Average_89_Sales = form.Average_89_Sales;
dbEntry.Average_GuestCountTotal = form.Average_GuestCountTotal;
dbEntry.Average_SalesTotal = form.Average_SalesTotal;
dbEntry.ContactName = form.ContactName;
dbEntry.DateOfPartnership = form.DateOfPartnership;
dbEntry.Donations10PercentOfSalesToGL7700 = form.Donations10PercentOfSalesToGL7700;
dbEntry.DonationsTakenOnThePosiRegisterCodeToGL2005 = form.DonationsTakenOnThePosiRegisterCodeToGL2005;
dbEntry.FederalTaxID = form.FederalTaxID;
dbEntry.GLCode2005 = form.GLCode2005;
dbEntry.GLCode7700 = form.GLCode7700;
dbEntry.GuestCountContribution_3WeekAverage = form.GuestCountContribution_3WeekAverage;
dbEntry.GuestCountContribution_ActualNumber = form.GuestCountContribution_ActualNumber;
dbEntry.GuestCountContribution_GCCountribution = form.GuestCountContribution_GCCountribution;
dbEntry.HostingRestaurant = form.HostingRestaurant;
dbEntry.IsComplete = form.IsComplete;
dbEntry.LastWeekAverageCheck_45 = form.LastWeekAverageCheck_45;
dbEntry.LastWeekAverageCheck_56 = form.LastWeekAverageCheck_56;
dbEntry.LastWeekAverageCheck_67 = form.LastWeekAverageCheck_67;
dbEntry.LastWeekAverageCheck_78 = form.LastWeekAverageCheck_78;
dbEntry.LastWeekAverageCheck_89 = form.LastWeekAverageCheck_89;
dbEntry.LastWeekAverageCheckTotal = form.LastWeekAverageCheckTotal;
dbEntry.MailPartnershipCheckToBV = form.MailPartnershipCheckToBV;
dbEntry.NameOnCheck = form.NameOnCheck;
dbEntry.NewPartner = form.NewPartner;
dbEntry.Notes = form.Notes;
dbEntry.OrganizationMailingAddress = form.OrganizationMailingAddress;
dbEntry.OrganizationMailingCity = form.OrganizationMailingCity;
dbEntry.OrganizationMailingState = form.OrganizationMailingState;
dbEntry.OrganizationMailingZip = form.OrganizationMailingZip;
dbEntry.OrganizationPhone = form.OrganizationPhone;
dbEntry.PosiDonations = form.PosiDonations;
dbEntry.Purpose = form.Purpose;
dbEntry.SalesContribution_3WeekAverage = form.SalesContribution_3WeekAverage;
dbEntry.SalesContribution_Actual = form.SalesContribution_Actual;
dbEntry.SalesContribution_Difference = form.SalesContribution_Difference;
dbEntry.SalesContribution_Donation = form.SalesContribution_Donation;
dbEntry.SalesContribution_SalesContribution = form.SalesContribution_SalesContribution;
dbEntry.Scenario1_EstimatedDonation = form.Scenario1_EstimatedDonation;
dbEntry.Scenario1_EstimatedGuestCount = form.Scenario1_EstimatedGuestCount;
dbEntry.Scenario1_GuestCountInvited = form.Scenario1_GuestCountInvited;
dbEntry.Scenario1_TargetedGuestCount = form.Scenario1_TargetedGuestCount;
dbEntry.Scenario1_ThreeWeekAverageGuestCount = form.Scenario1_ThreeWeekAverageGuestCount;
dbEntry.Scenario2_EstimatedDonation = form.Scenario2_EstimatedDonation;
dbEntry.Scenario2_EstimatedGuestCount = form.Scenario2_EstimatedGuestCount;
dbEntry.Scenario2_GuestCountInvited = form.Scenario2_GuestCountInvited;
dbEntry.Scenario2_TargetedGuestCount = form.Scenario2_TargetedGuestCount;
dbEntry.Scenario2_ThreeWeekAverageGuestCount = form.Scenario2_ThreeWeekAverageGuestCount;
dbEntry.TenPercentDonation = form.TenPercentDonation;
dbEntry.TotalDonation = form.TotalDonation;
dbEntry.Week1_45_AdjustedSales = form.Week1_45_AdjustedSales;
dbEntry.Week1_45_GuestCount = form.Week1_45_GuestCount;
dbEntry.Week1_56_AdjustedSales = form.Week1_56_AdjustedSales;
dbEntry.Week1_56_GuestCount = form.Week1_56_GuestCount;
dbEntry.Week1_67_AdjustedSales = form.Week1_67_AdjustedSales;
dbEntry.Week1_67_GuestCount = form.Week1_67_GuestCount;
dbEntry.Week1_78_AdjustedSales = form.Week1_78_AdjustedSales;
dbEntry.Week1_78_GuestCount = form.Week1_78_GuestCount;
dbEntry.Week1_89_AdjustedSales = form.Week1_89_AdjustedSales;
dbEntry.Week1_89_GuestCount = form.Week1_89_GuestCount;
dbEntry.Week1_AdjustedSalesTotal = form.Week1_AdjustedSalesTotal;
dbEntry.Week1_GuestCountTotal = form.Week1_GuestCountTotal;
dbEntry.Week1Date = form.Week1Date;
dbEntry.Week2_45_AdjustedSales = form.Week2_45_AdjustedSales;
dbEntry.Week2_45_GuestCount = form.Week2_45_GuestCount;
dbEntry.Week2_56_AdjustedSales = form.Week2_56_AdjustedSales;
dbEntry.Week2_56_GuestCount = form.Week2_56_GuestCount;
dbEntry.Week2_67_AdjustedSales = form.Week2_67_AdjustedSales;
dbEntry.Week2_67_GuestCount = form.Week2_67_GuestCount;
dbEntry.Week2_67_GuestCount = form.Week2_67_GuestCount;
dbEntry.Week2_78_AdjustedSales = form.Week2_78_AdjustedSales;
dbEntry.Week2_78_GuestCount = form.Week2_78_GuestCount;
dbEntry.Week2_89_AdjustedSales = form.Week2_89_AdjustedSales;
dbEntry.Week2_89_GuestCount = form.Week2_89_GuestCount;
dbEntry.Week2_AdjustedSalesTotal = form.Week2_AdjustedSalesTotal;
dbEntry.Week2_GuestCountTotal = form.Week2_GuestCountTotal;
dbEntry.Week2Date = form.Week2Date;
dbEntry.Week3_45_AdjustedSales = form.Week3_45_AdjustedSales;
dbEntry.Week3_45_GuestCount = form.Week3_45_GuestCount;
dbEntry.Week3_56_AdjustedSales = form.Week3_56_GuestCount;
dbEntry.Week3_67_AdjustedSales = form.Week3_67_AdjustedSales;
dbEntry.Week3_67_GuestCount = form.Week3_67_GuestCount;
dbEntry.Week3_78_AdjustedSales = form.Week3_78_AdjustedSales;
dbEntry.Week3_78_GuestCount = form.Week3_78_GuestCount;
dbEntry.Week3_89_AdjustedSales = form.Week3_89_AdjustedSales;
dbEntry.Week3_89_GuestCount = form.Week3_89_GuestCount;
dbEntry.Week3_AdjustedSalesTotal = form.Week3_AdjustedSalesTotal;
dbEntry.Week3_GuestCountTotal = form.Week3_GuestCountTotal;
dbEntry.Week3Date = form.Week3Date;
dbEntry.WeekDayOfPartnership = form.WeekDayOfPartnership;
}
}
db.SaveChanges();
}
public async Task <FormDTO> Handle(AddFormQuery message, CancellationToken cancellationToken)
{
var newForm = new Entities.Form
{
Code = message.Form.Code,
CurrentVersion = message.Form.CurrentVersion,
Description = message.Form.Description,
FormSections = new List <FormSection>(),
Diaspora = message.Form.Diaspora,
Draft = message.Form.Draft,
Order = message.Form.Order
};
foreach (var(form, formIndex) in message.Form.FormSections.Select((form, formIndex) => (form, formIndex + 1)))
{
var formSection = new FormSection
{
Code = form.Code,
Description = form.Description,
OrderNumber = formIndex,
Questions = new List <Question>()
};
foreach (var(question, questionIndex) in form.Questions.Select((question, questionIndex) => (question, questionIndex + 1)))
{
var questionEntity = new Question
{
QuestionType = question.QuestionType,
Hint = question.Hint,
Text = question.Text,
Code = question.Code,
OrderNumber = questionIndex
};
var optionsForQuestion = new List <OptionToQuestion>();
foreach (var(option, optionIndex) in question.OptionsToQuestions.Select((option, optionIndex) => (option, optionIndex + 1)))
{
if (option.IdOption > 0)
{
var existingOption = _context.Options.FirstOrDefault(o => o.Id == option.IdOption);
existingOption.OrderNumber = optionIndex;
optionsForQuestion.Add(new OptionToQuestion
{
Option = existingOption,
Flagged = option.Flagged
});
}
else
{
OptionToQuestion newOptionToQuestion = _mapper.Map <OptionToQuestion>(option);
newOptionToQuestion.Option.OrderNumber = optionIndex;
optionsForQuestion.Add(newOptionToQuestion);
}
}
questionEntity.OptionsToQuestions = optionsForQuestion;
formSection.Questions.Add(questionEntity);
}
newForm.FormSections.Add(formSection);
}
_context.Forms.Add(newForm);
await _context.SaveChangesAsync();
message.Form.Id = newForm.Id;
return(message.Form);
}
