protected Guid CreateFormItem(Guid formid, string idcode, string label, DformItemType type, int order, bool isRequired, string validationText = "", string validationRegex = "", string section = "", int sectionorder = 0, string helptext = "") { var item1 = _context.FormItems.FirstOrDefault(s => s.IdCode == idcode); if (item1 == null) { item1 = new DformItemEntity { Id = Guid.NewGuid(), }; _context.FormItems.Add(item1); } item1.FormId = formid; item1.Label = label; item1.IsRequired = isRequired; item1.FormItemType = type; item1.Order = order; item1.IdCode = idcode; item1.ValidationRegex = validationRegex; item1.ValidationText = validationText; item1.HelpText = helptext; item1.Section = section; //item1.SectionOrder = sectionorder; _context.SaveChanges(); return item1.Id; }
public void SaveFormItem(DformItemEntity entity) { var item1 = _context.FormItems.FirstOrDefault(s => s.Id == entity.Id); if (item1 == null) { item1 = new DformItemEntity { Id =entity.Id, }; _context.FormItems.Add(item1); } item1.FormId = entity.FormId; item1.Label = entity.Label; item1.IsRequired = entity.IsRequired; item1.FormItemType = entity.FormItemType; item1.Order = entity.Order; item1.IdCode =entity.IdCode; item1.ValidationRegex = entity.ValidationRegex; item1.ValidationText = entity.ValidationText; item1.HelpText = entity.HelpText; item1.Section = entity.Section; //item1.SectionOrder = sectionorder; _context.SaveChanges(); }
private FormItemDTO Map(DformItemEntity s) { return new FormItemDTO { Id = s.Id, IsActive = true, Label = s.Label, Code = s.IdCode, FormId = s.FormId, FormName = s.Form.Name, FormItemTypeId = (int)s.FormItemType, FormItemType = s.FormItemType.ToString(), IsRequired = s.IsRequired, Order = s.Order, ValidationRegex = s.ValidationRegex, ValidationText = s.ValidationText, RespondentTypes = s.FormItemRespondentTypes.Select(b=>b.FormRespondentTypeId).ToList(), PossibleOptions = s.FormItemAnswers.Select(b=> new FormItemOption{Text = b.Text,Value = b.Value}).ToList(), HelpText = s.HelpText, Section = s.Section, }; }
public BasicResponse Save(FormItemDTO dto) { var response = new BasicResponse(); try { var entity = new DformItemEntity() { Id = dto.Id, FormId = dto.FormId, HelpText = dto.HelpText, IdCode = "", IsRequired = dto.IsRequired, Label = dto.Label, Section = dto.Section, ValidationRegex = dto.ValidationRegex, ValidationText = dto.ValidationText, Order = dto.Order, FormItemType = (DformItemType)dto.FormItemTypeId, }; _formRepository.SaveFormItem(entity); // entity = _formRepository.QueryFormItem(new QueryFormItem {Id = entity.Id}).Result.FirstOrDefault(); _formRepository.DeleteFormItemRespondent(entity.Id); foreach(var respondent in dto.RespondentTypes) { var respondentItem = new DformItemRespondentTypeEntity { Id = dto.Id, FormItemId = entity.Id, FormRespondentTypeId = respondent }; _formRepository.SaveFormItemRespondent(respondentItem); } _formRepository.DeleteFormItemAnswers(entity.Id); foreach (var ans in dto.PossibleOptions) { var respondentItem = new DformItemAnswerEntity() { Id = dto.Id, Text =ans.Text, FormItemId = entity.Id, Value = ans.Value, }; _formRepository.SaveFormItemAnswers(respondentItem); } response.Status = true; response.Info = "Success"; } catch (Exception ex) { response.Status = false; if (ex is DomainValidationException) { var dex = ex as DomainValidationException; response.Info = dex.FormatException(); } else { response.Status = false; response.Info = ex.Message; } } return response; }
public void CreateDailyData() { var formid = CreateForm("Safaricom Daily Data", FormCode, GetClient().Id); var delearshop = CreateFormRespondentType(formid, GetRespodentCode(1), "DEALER", "D"); var mpesa = CreateFormRespondentType(formid, GetRespodentCode(2), "M-PESA", "M"); var retailshop = CreateFormRespondentType(formid, GetRespodentCode(3), "RETAIL", "R"); // var digitalvilage = CreateFormRespondentType(formid, GetRespodentCode(4), "CYBER CENTRE", "DV"); var mpesaRetail = CreateFormRespondentType(formid, GetRespodentCode(5), "M-PESA & RETAIL", "MR"); var q1 = new DformItemEntity(); q1.FormId = formid; q1.Label = "What is the name of the outlet ?"; q1.IsRequired = true; q1.FormItemType = DformItemType.Text; q1.Order = 1; q1.IdCode = GetItemCode(1); q1.ValidationRegex = ""; q1.ValidationText = ""; q1.HelpText = "Outlet Name"; q1.Section = "1|-|1|-"; var formitem1 = CreateFormItem(q1); CreateItemRespondentType(formitem1, delearshop); CreateItemRespondentType(formitem1, mpesa); CreateItemRespondentType(formitem1, retailshop); // CreateItemRespondentType(formitem1, digitalvilage); CreateItemRespondentType(formitem1, mpesaRetail); var q2 = new DformItemEntity(); q2.FormId = formid; q2.Label = "What is the Location of the outlet ?"; q2.IsRequired = true; q2.FormItemType = DformItemType.Text; q2.Order = 2; q2.IdCode = GetItemCode(2); q2.ValidationRegex = ""; q2.ValidationText = ""; q2.HelpText = "Location"; q2.Section = "1|-|2|-"; ; var formitem2 = CreateFormItem(q2); //var formitem2 = CreateFormItem(formid, GetItemCode(2), "What is the Location of the outlet ?", // DformItemType.Text, 2, true, "", "", "Outlet", 1); CreateItemRespondentType(formitem2, delearshop); CreateItemRespondentType(formitem2, mpesa); CreateItemRespondentType(formitem2, retailshop); //CreateItemRespondentType(formitem2, digitalvilage); CreateItemRespondentType(formitem2, mpesaRetail); var q3 = new DformItemEntity(); q3.FormId = formid; q3.Label = "What is the M-PESA Agent Number ?"; q3.IsRequired = true; q3.FormItemType = DformItemType.Text; q3.Order = 3; q3.IdCode = GetItemCode(3); q3.ValidationRegex = @"\d{5,6}"; q3.ValidationText ="Enter valid Agent No."; ; q3.HelpText = "M-PESA AGENT NO."; q3.Section = "1|-|3|-"; ; var formitem3 = CreateFormItem(q3); //var formitem3 = CreateFormItem(formid, GetItemCode(3), "What is the M-Pesa Agent Number ?", // DformItemType.Text, 3, true, "Enter valid Agent No.", @"\d{5,6}", "M-PESA"); CreateItemRespondentType(formitem3, delearshop); CreateItemRespondentType(formitem3, mpesa); // CreateItemRespondentType(formitem3, retailshop); // CreateItemRespondentType(formitem3, digitalvilage); CreateItemRespondentType(formitem3, mpesaRetail); var q4 = new DformItemEntity(); q4.FormId = formid; q4.Label = "What is the status of the M-Pesa outlet?"; q4.IsRequired = true; q4.FormItemType = DformItemType.DropdownList; q4.Order = 4; q4.IdCode = GetItemCode(4); q4.ValidationRegex = ""; q4.ValidationText =""; q4.HelpText = "M-PESA OUTLET STATUS"; q4.Section = "2|M-PESA DATA|1|M-PESA OUTLETSTATUS"; var formitem4 = CreateFormItem(q4); //var formitem4 = CreateFormItem(formid, GetItemCode(4), "What is the status of the mpesa outlet?", // DformItemType.DropdownList, 4, true); CreateItemRespondentType(formitem4, delearshop); CreateItemRespondentType(formitem4, mpesa); //CreateItemRespondentType(formitem4, retailshop); //CreateItemRespondentType(formitem4, digitalvilage); CreateItemRespondentType(formitem4, mpesaRetail); CreateAnswers(formitem4, GetItemAnsCode(4, 1), "Active", "Active"); CreateAnswers(formitem4, GetItemAnsCode(4, 2), "Closed", "Closed"); CreateAnswers(formitem4, GetItemAnsCode(4, 3), "Suspended", "Suspended"); CreateAnswers(formitem4, GetItemAnsCode(4, 4), "Relocated", "Relocated"); CreateAnswers(formitem4, GetItemAnsCode(4, 5), "MIT", "MIT"); var q5 = new DformItemEntity(); q5.FormId = formid; q5.Label = "What is the name of the assistant ?"; q5.IsRequired = true; q5.FormItemType = DformItemType.Text; q5.Order = 5; q5.IdCode = GetItemCode(5); q5.ValidationRegex = ""; q5.ValidationText = ""; q5.HelpText = "Assistant(s) (Names)"; q5.Section = "2|M-PESA DATA|2|Assistants on Premise"; ; var formitem5 = CreateFormItem(q5); CreateItemRespondentType(formitem5, delearshop); CreateItemRespondentType(formitem5, mpesa); CreateItemRespondentType(formitem5, retailshop); //CreateItemRespondentType(formitem5, digitalvilage); CreateItemRespondentType(formitem5, mpesaRetail); var q6 = new DformItemEntity(); q6.FormId = formid; q6.Label = "What is the contact details of the assistant ?"; q6.IsRequired = true; q6.FormItemType = DformItemType.Text; q6.Order = 6; q6.IdCode = GetItemCode(6); q6.ValidationRegex = @"^\+?\d{10,12}$"; q6.ValidationText = "Enter valid phone number"; q6.HelpText = "Assistant Tel: Contact"; q6.Section = "2|M-PESA DATA|2|Assistants on Premise"; ; var formitem6 = CreateFormItem(q6); //var formitem6 = CreateFormItem(formid, GetItemCode(6), "What is the contact details of the assistant ?", // DformItemType.Text, 6, true); CreateItemRespondentType(formitem6, delearshop); CreateItemRespondentType(formitem6, mpesa); CreateItemRespondentType(formitem6, retailshop); //CreateItemRespondentType(formitem6, digitalvilage); CreateItemRespondentType(formitem6, mpesaRetail); var q7 = new DformItemEntity(); q7.FormId = formid; q7.Label = "Is the assistant trained and tested on M-PESA/KYC /AML?"; q7.IsRequired = true; q7.FormItemType = DformItemType.DropdownList; q7.Order = 7; q7.IdCode = GetItemCode(7); q7.ValidationRegex = ""; q7.ValidationText = ""; q7.HelpText = "trained and tested on M-PESA/KYC /AML / (yes=1, No=0)"; q7.Section = "2|M-PESA DATA|2|Assistants on Premise"; ; var formitem7 = CreateFormItem(q7); //var formitem7 = CreateFormItem(formid, GetItemCode(7), // "Is the assistant trained and tested on M-PESA/KYC /AML?", // DformItemType.DropdownList, 7, true); CreateItemRespondentType(formitem7, delearshop); CreateItemRespondentType(formitem7, mpesa); CreateItemRespondentType(formitem7, retailshop); //CreateItemRespondentType(formitem7, digitalvilage); // CreateItemRespondentType(formitem7, mpesaRetail); CreateAnswers(formitem7, GetItemAnsCode(7, 1), "YES", "1"); CreateAnswers(formitem7, GetItemAnsCode(7, 2), "NO", "0"); var q8 = new DformItemEntity(); q8.FormId = formid; q8.Label = "Is the target sheet updated?"; q8.IsRequired = true; q8.FormItemType = DformItemType.DropdownList; q8.Order = 8; q8.IdCode = GetItemCode(8); q8.ValidationRegex = ""; q8.ValidationText = ""; q8.HelpText = "Target Sheet Updated Yes=1, No=0"; q8.Section = "2|M-PESA DATA|3|Targets"; var formitem8 = CreateFormItem(q8); //var formitem8 = CreateFormItem(formid, GetItemCode(8), "Is the target sheet updated?", // DformItemType.DropdownList, 8, true); CreateItemRespondentType(formitem8, delearshop); CreateItemRespondentType(formitem8, mpesa); //CreateItemRespondentType(formitem8, retailshop); // CreateItemRespondentType(formitem8, digitalvilage); CreateItemRespondentType(formitem8, mpesaRetail); CreateAnswers(formitem8, GetItemAnsCode(8, 1), "YES", "1"); CreateAnswers(formitem8, GetItemAnsCode(8, 2), "NO", "0"); var q9 = new DformItemEntity(); q9.FormId = formid; q9.Label = "What is the current M-PESA float ?"; q9.IsRequired = true; q9.FormItemType = DformItemType.Text; q9.Order = 9; q9.IdCode = GetItemCode(9); q9.ValidationRegex = @"\d{1,10}(\.\d{0,2})?$"; q9.ValidationText = "Enter valid M-PESA float amount."; q9.HelpText = "E-Float(Ksh.)"; q9.Section = "2|M-PESA DATA|4|Float Availability"; var formitem9 = CreateFormItem(q9); //var formitem9 = CreateFormItem(formid, GetItemCode(9), "What is the current M-Pesa float ?", // DformItemType.Text, 9, true, "Enter valid M-Pesa float amount.", // @"\d{1,10}+(\.*\d{0,2})"); CreateItemRespondentType(formitem9, delearshop); CreateItemRespondentType(formitem9, mpesa); //CreateItemRespondentType(formitem9, retailshop); // CreateItemRespondentType(formitem9, digitalvilage); CreateItemRespondentType(formitem9, mpesaRetail); var q10 = new DformItemEntity(); q10.FormId = formid; q10.Label = "Are SIMEX available?"; q10.IsRequired = true; q10.FormItemType = DformItemType.DropdownList; q10.Order = 10; q10.IdCode = GetItemCode(10); q10.ValidationRegex = ""; q10.ValidationText = ""; q10.HelpText = "Available= 1 Not Available=0"; q10.Section = "4|SAFARICOM PRODUCT AVAILABILITY|1|Simex"; var formitem10 = CreateFormItem(q10); //var formitem10 = CreateFormItem(formid, GetItemCode(10), "Are SIMEX available?", DformItemType.DropdownList, // 10, true); CreateItemRespondentType(formitem10, delearshop); CreateItemRespondentType(formitem10, mpesa); // CreateItemRespondentType(formitem10, retailshop); //CreateItemRespondentType(formitem10, digitalvilage); CreateItemRespondentType(formitem10, mpesaRetail); CreateAnswers(formitem10, GetItemAnsCode(10, 1), "Available", "1"); CreateAnswers(formitem10, GetItemAnsCode(10, 2), "Not Available", "0"); var q11 = new DformItemEntity(); q11.FormId = formid; q11.Label = "Are Lines available?"; q11.IsRequired = true; q11.FormItemType = DformItemType.DropdownList; q11.Order = 11; q11.IdCode = GetItemCode(11); q11.ValidationRegex = ""; q11.ValidationText = ""; q11.HelpText = "Available= 1 Not Available=0"; q11.Section = "4|SAFARICOM PRODUCT AVAILABILITY|2|Lines"; ; var formitem11 = CreateFormItem(q11); //var formitem11 = CreateFormItem(formid, GetItemCode(11), "Are Lines available?", DformItemType.DropdownList, // 11, true); CreateItemRespondentType(formitem11, delearshop); CreateItemRespondentType(formitem11, mpesa); //CreateItemRespondentType(formitem11, retailshop); //CreateItemRespondentType(formitem11, digitalvilage); CreateItemRespondentType(formitem11, mpesaRetail); CreateAnswers(formitem11, GetItemAnsCode(11, 1), "Available", "1"); CreateAnswers(formitem11, GetItemAnsCode(11, 2), "Not Available", "0"); var q12 = new DformItemEntity(); q12.FormId = formid; q12.Label = "How many promotion phones available?"; q12.IsRequired = true; q12.FormItemType = DformItemType.Text; q12.Order = 12; q12.IdCode = GetItemCode(12); q12.ValidationRegex = @"\d{1,10}"; q12.ValidationText = "Enter valid No of Phones."; q12.HelpText = "Available= 1 Not Available=0"; q12.Section = "4|SAFARICOM PRODUCT AVAILABILITY|3| Promotional phones"; ; var formitem12 = CreateFormItem(q12); //var formitem12 = CreateFormItem(formid, GetItemCode(12), "How many promotion phones available?", // DformItemType.Text, 12, true, "Enter valid No of Phones.", @"\d{1,10}"); CreateItemRespondentType(formitem12, delearshop); CreateItemRespondentType(formitem12, mpesa); // CreateItemRespondentType(formitem12, retailshop); //CreateItemRespondentType(formitem12, digitalvilage); CreateItemRespondentType(formitem12, mpesaRetail); //var q13 = new DformItemEntity(); //q13.FormId = formid; //q13.Label = "USSD Service Self Reversal ?"; //q13.IsRequired = true; //q13.FormItemType = DformItemType.DropdownList; //q13.Order = 13; //q13.IdCode = GetItemCode(13); //q13.ValidationRegex = ""; //q13.ValidationText = ""; //q13.HelpText = "Yes=1, No=0"; //q13.Section = "3|USSD|1| Able to do Deposit self reversal (*234*3*1#)"; //var formitem13 = CreateFormItem(q13); ////var formitem13 = CreateFormItem(formid, GetItemCode(13), "USSD Service Self Reversal ?", // // DformItemType.DropdownList, 13, true); //CreateItemRespondentType(formitem13, delearshop); //CreateItemRespondentType(formitem13, mpesa); //CreateItemRespondentType(formitem13, retailshop); //CreateItemRespondentType(formitem13, digitalvilage); //CreateItemRespondentType(formitem13, mpesaRetail); //CreateAnswers(formitem13, GetItemAnsCode(13, 1), "YES", "1"); //CreateAnswers(formitem13, GetItemAnsCode(13, 2), "NO", "0"); //var q14 = new DformItemEntity(); //q14.FormId = formid; //q14.Label = "USSD Service Able to Access *180#: ?"; //q14.IsRequired = true; //q14.FormItemType = DformItemType.DropdownList; //q14.Order = 14; //q14.IdCode = GetItemCode(14); //q14.ValidationRegex = ""; //q14.ValidationText = ""; //q14.HelpText = "Yes=1, No=0"; //q14.Section = "3|USSD|2| Able to do subscriber registration (*180*2#)"; //var formitem14 = CreateFormItem(q14); ////var formitem14 = CreateFormItem(formid, GetItemCode(14), "USSD Service Able to Access *180#: ?", //// DformItemType.DropdownList, 14, true); //CreateItemRespondentType(formitem14, delearshop); //CreateItemRespondentType(formitem14, mpesa); //CreateItemRespondentType(formitem14, retailshop); //CreateItemRespondentType(formitem14, digitalvilage); //CreateItemRespondentType(formitem14, mpesaRetail); //CreateAnswers(formitem14, GetItemAnsCode(14, 1), "YES", "1"); //CreateAnswers(formitem14, GetItemAnsCode(14, 2), "NO", "0"); var q14 = new DformItemEntity(); q14.FormId = formid; q14.Label = "Is Dealer Sales Tracker Updated"; q14.IsRequired = true; q14.FormItemType = DformItemType.DropdownList; q14.Order = 14; q14.IdCode = GetItemCode(14); q14.ValidationRegex = ""; q14.ValidationText = ""; q14.HelpText = "Yes=1, No=0"; q14.Section = "3|DEALER SALES|1| Dealer Sales Tracker"; var formitem14 = CreateFormItem(q14); //var formitem14 = CreateFormItem(formid, GetItemCode(14), "USSD Service Able to Access *180#: ?", // DformItemType.DropdownList, 14, true); CreateItemRespondentType(formitem14, delearshop); //CreateItemRespondentType(formitem14, mpesa); //CreateItemRespondentType(formitem14, retailshop); //CreateItemRespondentType(formitem14, digitalvilage); //CreateItemRespondentType(formitem14, mpesaRetail); CreateAnswers(formitem14, GetItemAnsCode(14, 1), "YES", "1"); CreateAnswers(formitem14, GetItemAnsCode(14, 2), "NO", "0"); var q15 = new DformItemEntity(); q15.FormId = formid; q15.Label = "How many modem available?"; q15.IsRequired = true; q15.FormItemType = DformItemType.Text; q15.Order = 15; q15.IdCode = GetItemCode(15); q15.ValidationRegex = @"\d{1,10}"; q15.ValidationText = "Enter valid No of Modem."; q15.HelpText = "Available= 1 Not Available=0"; q15.Section = "4|SAFARICOM PRODUCT AVAILABILITY|4| Modems"; var formitem15 = CreateFormItem(q15); //var formitem15 = CreateFormItem(formid, GetItemCode(15), "How many modem available?", DformItemType.Text, // 15, true, "Enter valid No of Modem.", @"\d{1,10}"); CreateItemRespondentType(formitem15, delearshop); CreateItemRespondentType(formitem15, mpesa); //CreateItemRespondentType(formitem15, retailshop); //CreateItemRespondentType(formitem15, digitalvilage); CreateItemRespondentType(formitem15, mpesaRetail); var q16 = new DformItemEntity(); q16.FormId = formid; q16.Label = "Is Safaricom 5 Shilling airtime available?"; q16.IsRequired = true; q16.FormItemType = DformItemType.DropdownList; q16.Order = 16; q16.IdCode = GetItemCode(16); q16.ValidationRegex = ""; q16.ValidationText = ""; q16.HelpText = "5"; q16.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem16 = CreateFormItem(q16); //var formitem16 = CreateFormItem(formid, GetItemCode(16), "Is Safaricom 5 Shilling airtime available?", // DformItemType.DropdownList, 16, true); CreateItemRespondentType(formitem16, delearshop); CreateItemRespondentType(formitem16, mpesa); CreateItemRespondentType(formitem16, retailshop); //CreateItemRespondentType(formitem16, digitalvilage); CreateItemRespondentType(formitem16, mpesaRetail); CreateAnswers(formitem16, GetItemAnsCode(16, 1), "YES", "1"); CreateAnswers(formitem16, GetItemAnsCode(16, 2), "NO", "0"); var q17 = new DformItemEntity(); q17.FormId = formid; q17.Label = "Is Safaricom 10 Shilling airtime available?"; q17.IsRequired = true; q17.FormItemType = DformItemType.DropdownList; q17.Order = 17; q17.IdCode = GetItemCode(17); q17.ValidationRegex = ""; q17.ValidationText = ""; q17.HelpText = "10"; q17.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem17 = CreateFormItem(q17); //var formitem17 = CreateFormItem(formid, GetItemCode(17), "Is Safaricom 10 Shilling airtime available?", // DformItemType.DropdownList, 17, true); CreateItemRespondentType(formitem17, delearshop); CreateItemRespondentType(formitem17, mpesa); CreateItemRespondentType(formitem17, retailshop); //CreateItemRespondentType(formitem17, digitalvilage); CreateItemRespondentType(formitem17, mpesaRetail); CreateAnswers(formitem17, GetItemAnsCode(17, 1), "YES", "1"); CreateAnswers(formitem17, GetItemAnsCode(17, 2), "NO", "0"); var q18 = new DformItemEntity(); q18.FormId = formid; q18.Label = "Is Safaricom 20 Shilling airtime available?"; q18.IsRequired = true; q18.FormItemType = DformItemType.DropdownList; q18.Order = 18; q18.IdCode = GetItemCode(18); q18.ValidationRegex = ""; q18.ValidationText = ""; q18.HelpText = "20"; q18.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem18 = CreateFormItem(q18); //var formitem18 = CreateFormItem(formid, GetItemCode(18), "Is Safaricom 20 Shilling airtime available?", // DformItemType.DropdownList, 18, true); CreateItemRespondentType(formitem18, delearshop); CreateItemRespondentType(formitem18, mpesa); CreateItemRespondentType(formitem18, retailshop); //CreateItemRespondentType(formitem18, digitalvilage); CreateItemRespondentType(formitem18, mpesaRetail); CreateAnswers(formitem18, GetItemAnsCode(18, 1), "YES", "1"); CreateAnswers(formitem18, GetItemAnsCode(18, 2), "NO", "0"); var q19 = new DformItemEntity(); q19.FormId = formid; q19.Label = "Is Safaricom 50 Shilling airtime available?"; q19.IsRequired = true; q19.FormItemType = DformItemType.DropdownList; q19.Order = 19; q19.IdCode = GetItemCode(19); q19.ValidationRegex = ""; q19.ValidationText = ""; q19.HelpText = "50"; q19.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem19 = CreateFormItem(q19); //var formitem19 = CreateFormItem(formid, GetItemCode(19), "Is Safaricom 50 Shilling airtime available?", // DformItemType.DropdownList, 19, true); CreateItemRespondentType(formitem19, delearshop); CreateItemRespondentType(formitem19, mpesa); CreateItemRespondentType(formitem19, retailshop); // CreateItemRespondentType(formitem19, digitalvilage); CreateItemRespondentType(formitem19, mpesaRetail); CreateAnswers(formitem19, GetItemAnsCode(19, 1), "YES", "1"); CreateAnswers(formitem19, GetItemAnsCode(19, 2), "NO", "0"); var q20 = new DformItemEntity(); q20.FormId = formid; q20.Label = "Is Safaricom 100 Shilling airtime available?"; q20.IsRequired = true; q20.FormItemType = DformItemType.DropdownList; q20.Order = 20; q20.IdCode = GetItemCode(20); q20.ValidationRegex = ""; q20.ValidationText = ""; q20.HelpText = "100"; q20.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem20 = CreateFormItem(q20); //var formitem20 = CreateFormItem(formid, GetItemCode(20), "Is Safaricom 100 Shilling airtime available?", // DformItemType.DropdownList, 20, true); CreateItemRespondentType(formitem20, delearshop); CreateItemRespondentType(formitem20, mpesa); CreateItemRespondentType(formitem20, retailshop); //CreateItemRespondentType(formitem20, digitalvilage); CreateItemRespondentType(formitem20, mpesaRetail); CreateAnswers(formitem20, GetItemAnsCode(20, 1), "YES", "1"); CreateAnswers(formitem20, GetItemAnsCode(20, 2), "NO", "0"); var q21 = new DformItemEntity(); q21.FormId = formid; q21.Label = "Is Safaricom 250 Shilling airtime available?"; q21.IsRequired = true; q21.FormItemType = DformItemType.DropdownList; q21.Order = 21; q21.IdCode = GetItemCode(21); q21.ValidationRegex = ""; q21.ValidationText = ""; q21.HelpText = "250"; q21.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem21 = CreateFormItem(q21); //var formitem21 = CreateFormItem(formid, GetItemCode(21), "Is Safaricom 250 Shilling airtime available?", // DformItemType.DropdownList, 21, true); CreateItemRespondentType(formitem21, delearshop); CreateItemRespondentType(formitem21, mpesa); CreateItemRespondentType(formitem21, retailshop); // CreateItemRespondentType(formitem21, digitalvilage); CreateItemRespondentType(formitem21, mpesaRetail); CreateAnswers(formitem21, GetItemAnsCode(21, 1), "YES", "1"); CreateAnswers(formitem21, GetItemAnsCode(21, 2), "NO", "0"); var q22 = new DformItemEntity(); q22.FormId = formid; q22.Label = "Is Safaricom Other HDV airtime available?"; q22.IsRequired = true; q22.FormItemType = DformItemType.DropdownList; q22.Order = 22; q22.IdCode = GetItemCode(22); q22.ValidationRegex = ""; q22.ValidationText = ""; q22.HelpText = "Other HDV"; q22.Section = "4|SAFARICOM PRODUCT AVAILABILITY|5| Safaricom airtime availability"; var formitem22 = CreateFormItem(q22); //var formitem22 = CreateFormItem(formid, GetItemCode(22), "Is Safaricom Other HDV airtime available?", // DformItemType.DropdownList, 22, true); CreateItemRespondentType(formitem22, delearshop); CreateItemRespondentType(formitem22, mpesa); CreateItemRespondentType(formitem22, retailshop); //CreateItemRespondentType(formitem22, digitalvilage); CreateItemRespondentType(formitem22, mpesaRetail); CreateAnswers(formitem22, GetItemAnsCode(22, 1), "YES", "1"); CreateAnswers(formitem22, GetItemAnsCode(22, 2), "NO", "0"); var q23 = new DformItemEntity(); q23.FormId = formid; q23.Label = "Is ORANGE aritime available?"; q23.IsRequired = true; q23.FormItemType = DformItemType.DropdownList; q23.Order = 23; q23.IdCode = GetItemCode(23); q23.ValidationRegex = ""; q23.ValidationText = ""; q23.HelpText = "Orange"; q23.Section = "5|COMPETITION|1| Airtime availability"; var formitem23 = CreateFormItem(q23); //var formitem23 = CreateFormItem(formid, GetItemCode(23), "Is ORANGE aritime available?", // DformItemType.DropdownList, 23, true); //CreateItemRespondentType(formitem23, delearshop); // CreateItemRespondentType(formitem23, mpesa); CreateItemRespondentType(formitem23, retailshop); //CreateItemRespondentType(formitem23, digitalvilage); CreateItemRespondentType(formitem23, mpesaRetail); CreateAnswers(formitem23, GetItemAnsCode(23, 1), "YES", "1"); CreateAnswers(formitem23, GetItemAnsCode(23, 2), "NO", "0"); var q24 = new DformItemEntity(); q24.FormId = formid; q24.Label = "Is YU aritime available?"; q24.IsRequired = true; q24.FormItemType = DformItemType.DropdownList; q24.Order = 24; q24.IdCode = GetItemCode(24); q24.ValidationRegex = ""; q24.ValidationText = ""; q24.HelpText = "YU"; q24.Section = "5|COMPETITION|1| Airtime availability"; var formitem24 = CreateFormItem(q24); //var formitem24 = CreateFormItem(formid, GetItemCode(24), "Is YU aritime available?", // DformItemType.DropdownList, 24, true); // CreateItemRespondentType(formitem24, delearshop); //CreateItemRespondentType(formitem24, mpesa); CreateItemRespondentType(formitem24, retailshop); // CreateItemRespondentType(formitem24, digitalvilage); CreateItemRespondentType(formitem24, mpesaRetail); CreateAnswers(formitem24, GetItemAnsCode(24, 1), "YES", "1"); CreateAnswers(formitem24, GetItemAnsCode(24, 2), "NO", "0"); var q25 = new DformItemEntity(); q25.FormId = formid; q25.Label = "Is AIRTEL aritime available?"; q25.IsRequired = true; q25.FormItemType = DformItemType.DropdownList; q25.Order = 25; q25.IdCode = GetItemCode(25); q25.ValidationRegex = ""; q25.ValidationText = ""; q25.HelpText = "AIRTEL"; q25.Section = "5|COMPETITION|1| Airtime availability"; var formitem25 = CreateFormItem(q25); //var formitem25 = CreateFormItem(formid, GetItemCode(25), "Is AIRTEL aritime available?", // DformItemType.DropdownList, 25, true); // CreateItemRespondentType(formitem25, delearshop); // CreateItemRespondentType(formitem25, mpesa); CreateItemRespondentType(formitem25, retailshop); // CreateItemRespondentType(formitem25, digitalvilage); CreateItemRespondentType(formitem25, mpesaRetail); CreateAnswers(formitem25, GetItemAnsCode(25, 1), "YES", "1"); CreateAnswers(formitem25, GetItemAnsCode(25, 2), "NO", "0"); // visibility Vs all other companies' materials (approx %) var q26 = new DformItemEntity(); q26.FormId = formid; q26.Label = "Visibility Vs all other companies' materials (approx %)?"; q26.IsRequired = true; q26.FormItemType = DformItemType.Text; q26.Order = 26; q26.IdCode = GetItemCode(26); q26.ValidationRegex = @"\d{1,2}"; q26.ValidationText = "Enter valid %"; q26.HelpText = "visibility Vs all other companies' materials (approx %)"; q26.Section = "6|BRANDING|1| BRANDING"; var formitem26 = CreateFormItem(q26); //var formitem26 = CreateFormItem(formid, GetItemCode(26), // "Visibility Vs all other companies' materials (approx %)?", // DformItemType.Text, 26, true, "Enter valid %", @"\d{1,2}"); CreateItemRespondentType(formitem26, delearshop); CreateItemRespondentType(formitem26, mpesa); CreateItemRespondentType(formitem26, retailshop); //CreateItemRespondentType(formitem26, digitalvilage); CreateItemRespondentType(formitem26, mpesaRetail); //missing Merchandising materials var q27 = new DformItemEntity(); q27.FormId = formid; q27.Label = "Missing Merchandising materials?"; q27.IsRequired = true; q27.FormItemType = DformItemType.Text; q27.Order = 27; q27.IdCode = GetItemCode(27); q27.ValidationRegex = ""; q27.ValidationText = ""; q27.HelpText = "Missing Merchandising materials"; q27.Section = "6|BRANDING|1| BRANDING"; var formitem27 = CreateFormItem(q27); //var formitem27 = CreateFormItem(formid, GetItemCode(27), "Missing Merchandising materials?", // DformItemType.Text, 27, true); CreateItemRespondentType(formitem27, delearshop); CreateItemRespondentType(formitem27, mpesa); CreateItemRespondentType(formitem27, retailshop); //CreateItemRespondentType(formitem27, digitalvilage); CreateItemRespondentType(formitem27, mpesaRetail); //var formitem3 = CreateFormItem(formid, "Which of the following Product do you use?", DformItemType.MultiChoice, 3, true); //CreateItemRespondentType(formitem3, delearshop); //CreateItemRespondentType(formitem3, mpesa); //CreateItemRespondentType(formitem3, retailshop); //CreateItemRespondentType(formitem3, digitalvilage); //CreateAnswers(formitem3, "BANANA", "B"); //CreateAnswers(formitem3, "MANGO", "M"); //CreateAnswers(formitem3, "ORANGE", "O"); //CreateAnswers(formitem3, "APLE", "A"); }
protected Guid CreateFormItem(DformItemEntity entity) { var item1 = _context.FormItems.FirstOrDefault(s => s.IdCode == entity.IdCode); if (item1 == null) { item1 = new DformItemEntity { Id = Guid.NewGuid(), }; _context.FormItems.Add(item1); } item1.FormId = entity.FormId; item1.Label = entity.Label; item1.IsRequired = entity.IsRequired; item1.FormItemType = entity.FormItemType; item1.Order = entity.Order; item1.IdCode = entity.IdCode; item1.ValidationRegex = entity.ValidationRegex; item1.ValidationText = entity.ValidationText; item1.HelpText = entity.HelpText; item1.Section = entity.Section; // item1.SectionOrder = 0; _context.SaveChanges(); return item1.Id; }