public static bool UpdateUser(Users us, string v)
{
using (kindergardenEntities db = new kindergardenEntities())
{
int? i = 0;
string c = db.empGetUserIdSp(v).FirstOrDefault();
i = db.empGetPasswordSp(c).FirstOrDefault();
if (i != 0)
{
Users d = null;
d = db.Users.Find(i);
if (d != null)
{
db.Users.Find(i).Password = us.Password;
db.Users.Find(i).UserName = us.UserName;
Connections so;
so = db.Connections.Find(c, v);
db.Connections.Remove(so);
Connections f = new Connections();
f.ChildId = v;
f.UserId = us.Password;
db.Connections.Add(f);
db.SaveChanges();
}
}
return(true);
}
return(true);
}
public static Children Getallpropertyc(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
Children c = db.Children.Find(Convert.ToInt32(id));
return(c);
}
}
public static string GetUser(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
string name = db.empGetUserSp(id).FirstOrDefault();
return(name);
}
}
public static string GetChild(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
string pass = null;
pass = db.empGetChildSp(id).FirstOrDefault();
return(pass);
}
}
public static Children Getallpropertyc(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
int id_check = Int32.Parse(id);
Children c = db.Children.Find(id_check);
return(c);
}
}
public static bool Register(Users u)
{
using (kindergardenEntities db = new kindergardenEntities())
{
db.Users.Add(u);
db.SaveChanges();
return(true);
}
return(false);
}
public static int AddUser(Users ch)
{
using (kindergardenEntities db = new kindergardenEntities())
{
ch.UserId = (db.Users.Max(i => i.UserId)) + 1;
db.Users.Add(ch);
db.SaveChanges();
return(db.Users.Max(i => i.UserId));
}
return(0);
}
public static bool UpdateChildren(Children ch)
{
using (kindergardenEntities db = new kindergardenEntities())
{
Children f = db.Children.Find(ch.ChildId);
db.Children.Remove(f);
db.Children.Add(ch);
db.SaveChanges();
return(true);
}
return(true);
}
public static Users Getallpropertyd(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
string c = db.empGetUserIdSp(id).FirstOrDefault();
int? i = null;
i = db.empGetPasswordSp(c).FirstOrDefault();
if (i != null)
{
Users d = db.Users.Find(i);
return(d);
}
return(null);
}
}
public static bool Checkifthereislike(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
Children f = db.Children.Find(Convert.ToInt32(id));
if (f == null)
{
return(false);
}
else
{
return(true);
}
}
}
public static bool Checkifthereislike(string id)
{
using (kindergardenEntities db = new kindergardenEntities())
{
int id_check = Int32.Parse(id);
Children f = db.Children.Find(id_check);
if (f == null)
{
return(false);
}
else
{
return(true);
}
}
}
public static List <Class1> GetAllChildren()
{
using (kindergardenEntities db = new kindergardenEntities())
{
List <int?> Children = db.empGetChildIdSp().ToList();
List <string> temp = new List <string>();
foreach (int?c in Children)
{
temp.Add(Convert.ToString(c));
}
List <Class1> podto = new List <Class1>();
foreach (string t in temp)
{
podto.Add(new Class1(t));
}
return(podto);
}
}
public static bool AddChildren(Children ch)
{
using (kindergardenEntities db = new kindergardenEntities())
{
db.Children.Add(ch);
int iduser = db.Users.Max(i => i.UserId);
Users u = db.Users.Find(iduser);
Connections f = new Connections();
f.ChildId = ch.ChildId.ToString();
f.UserId = u.Password;
db.Connections.Add(f);
DailyAlerts d = new DailyAlerts();
d.ChildId = ch.ChildId;
d.AvgTime = TimeSpan.Parse("0");
d.IsComing_ = false;
d.IsMissing_ = false;
db.DailyAlerts.Add(d);
db.SaveChanges();
return(true);
}
}
public static bool AddChildren(Children ch)
{
using (kindergardenEntities db = new kindergardenEntities())
{
//create here the child with the right information
//-----------------------------------------------
db.Children.Add(ch);
int iduser = db.Users.Max(i => i.UserId);
Users u = db.Users.Find(iduser);
Connections f = new Connections();
f.ChildId = Convert.ToString(ch.ChildId);
f.UserId = Convert.ToString(u.UserId);
db.Connections.Add(f);
DailyAlerts d = new DailyAlerts();
d.ChildId = ch.ChildId;
d.AvgTime = TimeSpan.Parse("0");
d.IsComing_ = false;
d.IsMissing_ = false;
db.DailyAlerts.Add(d);
db.SaveChanges();
return(true);
}
}