static void Main(string[] args)
{
var ccAdmin = new CouchClient("localhost", 5984, null, null, false, AuthenticationType.Cookie);
var dbName = "firsttry";
if (!ccAdmin.HasDatabase(dbName))
{
ccAdmin.CreateDatabase(dbName);
}
var table = new Table {
Id = "5"
};
table.Families.AddRange(Family.CreateFamilies());
table.FamilyGroups.AddRange(FamilyGroup.CreateFamilyGroups());
var doc = new Document <Table>(table);
var db = ccAdmin.GetDatabase(dbName);
db.SetDefaultDesignDoc("docs");
db.SaveDocument(doc);
}
public IHttpActionResult GetFamilyGroup(int id)
{
FamilyGroup familyGroup = famGroupRP.Find(id);
if (familyGroup == null)
{
return(NotFound());
}
return(Ok(familyGroup));
}
public ActionResult Create(FamilyGroup familygroup)
{
if (ModelState.IsValid)
{
db.FamiliesGroups.Add(familygroup);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(familygroup);
}
public async Task <ActionResult <IEnumerable <FamilyGroup> > > GetfamilyGroup()
{
List <FamilyGroup> familyList = new List <FamilyGroup>();
familyList = await context.FamilyGroups.ToListAsync();
FamilyGroup familygroup = new FamilyGroup
{
Id = 0,
Name = "Select Family Group",
IsActive = false
};
familyList.Insert(0, familygroup);
return(familyList);
}
public ActionResult FindFamilyGroups(int?groupId)
{
if (groupId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//FamilyGroup group = context.FamilyGroups.Find(groupId);
FamilyGroup group = famGroupRP.Find(groupId);
if (group == null)
{
return(HttpNotFound());
}
return(View("FamilyGroupDisplay", group));
}
public async Task <int> Create(FamilyRequest request)
{
if (Users.Contains(request.User) && !FG.Contains(request.Id))
{
FamilyGroup fg = new FamilyGroup()
{
Address = request.Address,
Birthday = request.Birthday,
FirstName = request.FirstName,
Id = request.Id,
Identification = request.Identification,
LastName = request.LastName,
PhoneNumber = request.PhoneNumber,
Sex = request.Sex,
User = request.User,
};
_context.Families.Add(fg);
return(await _context.SaveChangesAsync());
}
return(0);
}
private async void Get()
{
var jData = await DataService.Get($"Family/{Preferences.Get("TeamId", "")}");
if (jData == "ConnectionError")
{
StandardMessagesDisplay.NoConnectionToast();
}
else if (jData == "null")
{
StandardMessagesDisplay.NoDataDisplayMessage();
}
else if (jData == "Error")
{
StandardMessagesDisplay.Error();
}
else if (jData == "ErrorTracked")
{
StandardMessagesDisplay.ErrorTracked();
}
else
{
try
{
var data = JsonConvert.DeserializeObject <Dictionary <string, FamilyModel> >(jData);
if (data != null)
{
foreach (KeyValuePair <string, FamilyModel> item in data)
{
var nestedJData = await DataService.Get($"Child/{item.Value.Id}");
if (nestedJData == "ConnectionError")
{
StandardMessagesDisplay.NoConnectionToast();
}
else if (nestedJData == "null")
{
StandardMessagesDisplay.NoDataDisplayMessage();
}
else if (nestedJData == "Error")
{
StandardMessagesDisplay.Error();
}
else if (nestedJData == "ErrorTracked")
{
StandardMessagesDisplay.ErrorTracked();
}
else
{
var nestedData = JsonConvert.DeserializeObject <Dictionary <string, ChildModel> >(nestedJData);
List <ChildModel> lp = new List <ChildModel>();
if (nestedData != null)
{
foreach (KeyValuePair <string, ChildModel> item2 in nestedData)
{
lp.Add(
new ChildModel
{
Id = item2.Value.Id,
FullName = item2.Value.FullName,
Gender = item2.Value.Gender,
DOB = item2.Value.DOB,
OPV0 = item2.Value.OPV0,
RINo = item2.Value.RINo
});
}
}
FamilyGroup?.Add(new ChildGroupbyFamilyModel(item.Value.HouseNo, lp));
}
}
}
}
catch (Exception ex)
{
Crashes.TrackError(ex);
StandardMessagesDisplay.InputToast(ex.Message);
}
}
}
public void Clear()
{
FamilyGroup?.Clear();
}
public ActionResult CreateFamilyGroup(FamilyGroupViewModel model)
{
if (ModelState.IsValid)
{
//var store = new UserStore<ApplicationUser>(context);
//var manager = new UserManager<ApplicationUser>(store);
var manager = famGroupRP.CreateUserStore();
ApplicationUser child2 = null;
ApplicationUser child3 = null;
ApplicationUser child4 = null;
ApplicationUser child5 = null;
List <ApplicationUser> swimmerList = new List <ApplicationUser>();
if (model.ParentEmail == null || model.Child1Email == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var parent = manager.FindByEmail(model.ParentEmail);
if (parent == null)
{
return(HttpNotFound());
}
var child1 = manager.FindByEmail(model.Child1Email);
if (child1 == null)
{
return(HttpNotFound());
}
FamilyGroup group = new FamilyGroup
{
GroupName = model.GroupName,
Email = model.ParentEmail,
PhoneNumber = model.PhoneNumber,
Parent = parent,
Swimmers = swimmerList
};
group.Swimmers.Add(child1);
if (model.Child2Email != null)
{
child2 = manager.FindByEmail(model.Child2Email);
if (child2 != null)
{
group.Swimmers.Add(child2);
}
}
if (model.Child3Email != null)
{
child3 = manager.FindByEmail(model.Child3Email);
if (child3 != null)
{
group.Swimmers.Add(child3);
}
}
if (model.Child4Email != null)
{
child4 = manager.FindByEmail(model.Child4Email);
if (child4 != null)
{
group.Swimmers.Add(child4);
}
}
if (model.Child5Email != null)
{
child5 = manager.FindByEmail(model.Child5Email);
if (child5 != null)
{
group.Swimmers.Add(child5);
}
}
//context.FamilyGroups.Add(group);
famGroupRP.Add(group);
parent.FamilyGroupId = group.GroupId;
manager.Update(parent);
child1.FamilyGroupId = group.GroupId;
manager.Update(child1);
if (child2 != null)
{
child2.FamilyGroupId = group.GroupId;
manager.Update(child2);
}
if (child3 != null)
{
child3.FamilyGroupId = group.GroupId;
manager.Update(child3);
}
if (child4 != null)
{
child2.FamilyGroupId = group.GroupId;
manager.Update(child4);
}
if (child5 != null)
{
child2.FamilyGroupId = group.GroupId;
manager.Update(child5);
}
return(View("FamilyGroupDisplay", group));
}
return(View("CreateFamilyGroup"));
}
public IHttpActionResult PostFamilyGroup(FamilyGroupViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
List <ApplicationUser> swimmerList = new List <ApplicationUser>();
ApplicationUser child1 = null;
ApplicationUser child2 = null;
ApplicationUser child3 = null;
ApplicationUser child4 = null;
ApplicationUser child5 = null;
var manager = famGroupRP.CreateUserStore();
var parent = manager.FindByEmail(model.ParentEmail);
if (parent == null)
{
return(NotFound());
}
child1 = manager.FindByEmail(model.Child1Email);
if (child1 == null)
{
return(NotFound());
}
else
{
swimmerList.Add(child1);
}
child2 = IsChildValid(manager, model.Child2Email);
if (child2 != null)
{
swimmerList.Add(child2);
}
child3 = IsChildValid(manager, model.Child3Email);
if (child3 != null)
{
swimmerList.Add(child3);
}
child4 = IsChildValid(manager, model.Child4Email);
if (child4 != null)
{
swimmerList.Add(child4);
}
child5 = IsChildValid(manager, model.Child5Email);
if (child5 != null)
{
swimmerList.Add(child5);
}
FamilyGroup group = new FamilyGroup
{
GroupName = model.GroupName,
Email = model.ParentEmail,
PhoneNumber = model.PhoneNumber,
Parent = parent,
Swimmers = swimmerList
};
famGroupRP.Add(group);
group.Parent.FamilyGroupId = group.GroupId;
manager.Update(group.Parent);
foreach (var child in group.Swimmers)
{
child.FamilyGroupId = group.GroupId;
manager.Update(child);
}
return(CreatedAtRoute("DefaultApi", new { id = group.GroupId }, group));
}
public ActionResult Edit(FamilyGroup familygroup)
{
if (ModelState.IsValid)
{
db.Entry(familygroup).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(familygroup);
}
protected override void Seed(DWA_Assignment1.Models.ApplicationDbContext context)
{
//Create roles
var roleStore = new RoleStore <IdentityRole>(context);
var rManager = new RoleManager <IdentityRole>(roleStore);
if (!context.Roles.Any(r => r.Name == "Club Official"))
{
var role = new IdentityRole {
Id = "1", Name = "Club Official"
};
rManager.Create(role);
}
if (!context.Roles.Any(r => r.Name == "Swimmer"))
{
var role = new IdentityRole {
Id = "2", Name = "Swimmer"
};
rManager.Create(role);
}
if (!context.Roles.Any(r => r.Name == "Parent"))
{
var role = new IdentityRole {
Id = "3", Name = "Parent"
};
rManager.Create(role);
}
//Create and add users to roles
var store = new UserStore <ApplicationUser>(context);
var manager = new UserManager <ApplicationUser>(store);
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var user = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
FirstName = "Admin",
LastName = "Admin",
Gender = "Male",
Address = "London",
PhoneNumber = "0800750224",
DateOfBirth = new DateTime(1980, 5, 21)
};
manager.Create(user, "Password123!");
manager.AddToRole(user.Id, "Club Official");
}
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var parent = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
FirstName = "Shiela",
LastName = "Colins",
Gender = "Female",
PhoneNumber = "0800001066",
Address = "Birmingham",
DateOfBirth = new DateTime(1980, 10, 10)
};
manager.Create(parent, "Shiela1!");
manager.AddToRole(parent.Id, "Parent");
}
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var u1 = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
FirstName = "Colin",
LastName = "Colins",
Gender = "Male",
Address = "Birmingham",
DateOfBirth = new DateTime(1980, 10, 10)
};
manager.Create(u1, "Colin1!");
manager.AddToRole(u1.Id, "Swimmer");
}
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var u2 = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
FirstName = "David",
LastName = "Colins",
Gender = "Male",
Address = "Birmingham",
DateOfBirth = new DateTime(1980, 10, 10)
};
manager.Create(u2, "David1!");
manager.AddToRole(u2.Id, "Swimmer");
}
if (!context.Users.Any(u => u.UserName == "*****@*****.**"))
{
var u3 = new ApplicationUser
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
FirstName = "Alex",
LastName = "Colins",
Gender = "Male",
Address = "Birmingham",
DateOfBirth = new DateTime(1980, 10, 10)
};
manager.Create(u3, "Alex1!");
manager.AddToRole(u3.Id, "Swimmer");
}
//Create Family Group
if (!context.FamilyGroups.Any())
{
var p = manager.FindByEmail("*****@*****.**");
var c1 = manager.FindByEmail("*****@*****.**");
var c2 = manager.FindByEmail("*****@*****.**");
var c3 = manager.FindByEmail("*****@*****.**");
List <ApplicationUser> children = new List <ApplicationUser>();
children.Add(c1);
children.Add(c2);
children.Add(c3);
var group = new FamilyGroup
{
GroupName = "Colins",
Parent = p,
Swimmers = children,
Email = p.Email,
PhoneNumber = p.PhoneNumber
};
context.FamilyGroups.AddOrUpdate(group);
}
var eve = new Event
{
AgeRange = "Junior",
Distance = "100m",
Gender = "Male",
};
}
// GET: JsonFormat
public ActionResult Index()
{
FamilyGroup fg = new FamilyGroup
{
FamilyName = "MyFamily",
Users = new List <User>
{
new User
{
Id = 1,
UserName = "******"
},
new User {
Id = 2, UserName = "******"
}
}
};
string jsonStr1 = JsonConvert.SerializeObject(fg);
//
FinanceRatio fr = new FinanceRatio
{
FamilyName = "MyFamily",
ratio = new List <KeyValueClass <double> >()
{
}
};
fr.ratio.Add(new KeyValueClass <double>
{
Key = "存储",
Value = 0.4
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "投资",
Value = 0.2
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "梦想基金",
Value = 0.1
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "零花-杨",
Value = 0.15
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "零花-汪",
Value = 0.15
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "^生活基金",
Value = 600
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "^十二",
Value = 250
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "^吃和交通-杨",
Value = 900
});
fr.ratio.Add(new KeyValueClass <double>
{
Key = "^吃和交通-汪",
Value = 800
});
string jsonStr2 = JsonConvert.SerializeObject(fr);
//入账
MoneyStream ms = new MoneyStream
{
CreateTime = Convert.ToDateTime("2017-10-1"),
Type = 1,
Money = 7400 + 3000,
UserId = 1,
UserName = "******"
};
MoneyStream ms2 = new MoneyStream
{
CreateTime = Convert.ToDateTime("2017-10-1"),
Type = 1,
Money = 4500,
UserId = 2,
UserName = "******"
};
string jsonStr3 = JsonConvert.SerializeObject(fr);
//new MongoDbService().Add<MoneyStream>("FinanceDB","MoneyStream",ms);
//new MongoDbService().Add<MoneyStream>("FinanceDB", "MoneyStream", ms2);
return(View());
}
