public HomeController(TDRContext context, ISafaricomFormService safaricomFormService,IUserRepository userRepository)
{
_context = context;
_safaricomFormService = safaricomFormService;
_userRepository = userRepository;
if(!_context.Users.Any(s=>s.Username.ToLower()=="admin"))
{
var user1 = new User
{
CreatedOn = DateTime.Now,
Email = "",
Fullname = "admin",
Id = Guid.NewGuid(),
IsActive = false,
Password = Md5Hash.GetMd5Hash("1234"),
PhoneNumber = "00000000",
UserType = UserType.Admin,
UpdatedOn = DateTime.Now,
Username = "******"
};
_context.Users.Add(user1);
_context.SaveChanges();
}
}
public ActionResult seed()
{
TDRContext context = new TDRContext();
if(context.Forms.Any(s=>s.Name=="Safaricom"))
{
return View();
}
//var formid = CreateForm("Safaricom");
//var formRespondentid1 = CreateFormRespondentType(formid,"Dealer","D");
//var formRespondentid2 = CreateFormRespondentType(formid, "M-Pesa", "M");
//var formitem1 = CreateFormItem(formid,"What is your name ?",DformItemType.Text,1,true);
//CreateItemRespondentType(formitem1,formRespondentid1);
//CreateItemRespondentType(formitem1, formRespondentid2);
//var formitem2 = CreateFormItem(formid, "What is your Gender?", DformItemType.DropdownList, 2, true);
//CreateItemRespondentType(formitem2, formRespondentid1);
//CreateItemRespondentType(formitem2, formRespondentid2);
//CreateAnswers(formitem2, "MALE", "M");
//CreateAnswers(formitem2, "FEMALE", "F");
//var formitem3 = CreateFormItem(formid, "Which of the following Product do you use?", DformItemType.MultiChoice, 3, true);
//CreateItemRespondentType(formitem3, formRespondentid1);
//CreateItemRespondentType(formitem3, formRespondentid2);
//CreateAnswers(formitem3, "BANANA", "B");
//CreateAnswers(formitem3, "MANGO", "M");
//CreateAnswers(formitem3, "ORANGE", "O");
//CreateAnswers(formitem3, "APLE", "A");
return View();
}
public string Index()
{
List<ActiveOutlet> list = new List<ActiveOutlet>();
TDRContext db = new TDRContext();
var statuses = new List<string> {"Active", "Closed", "Suspended", "Relocated", "MIT"};
foreach (var resp in db.FormRespondentTypes.Where(s => s.Form.IdCode == "SAF_D_D_F" & s.Name == "M-PESA").ToList())
{
foreach (var status in statuses)
{
var active = new ActiveOutlet();
active.RespondentType = resp.Name;
active.Status = status;
active.Count = db.FormResultItem.Count(s => s.FormItem.Order == 4 && s.FormItemAnswer == status && s.FormResult.RespondentTypeId==resp.Id);
list.Add(active);
}
}
var data=list.ToList().ToDataTable();
var data2 = PivotHelper.Pivot(data, "RespondentType", "Status", "Count");
return new GoogleDataTable(data2).GetJson();
}
public FormRepository(TDRContext context)
{
_context = context;
}
public ClientRepository(TDRContext context)
{
_context = context;
}
public LocationRepository(TDRContext context)
{
_context = context;
}
public SafaricomFormService(TDRContext context)
: base(context)
{
}
public ReportGroupRepository(TDRContext context)
{
_context = context;
}
public ConfigRepository(TDRContext context)
{
_context = context;
}
public FormController(TDRContext context, IFormService formService)
{
_context = context;
_formService = formService;
}
public UserRepository(TDRContext context)
{
_context = context;
}
public FormServiceBase(TDRContext context)
{
_context = context;
}