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