public int AddUser(int Id, string FirstName, string MiddleName, string LastName, DateTime BirthDate, string Gender, int?Weight, int?Height, string HomeAddress, Int64?HomePhone, string OfficeAddress, Int64 OfficePhone, string EmailAdd, Int64?CellphoneNumber, string Name, string Description)
{
TestDBEntities tstDb = new TestDBEntities();
Physician usrdtl = new Physician();
usrdtl.Id = Id;
usrdtl.FirstName = FirstName;
usrdtl.MiddleName = MiddleName;
usrdtl.LastName = LastName;
usrdtl.BirthDate = BirthDate;
usrdtl.Gender = Gender;
usrdtl.Weight = Weight;
usrdtl.Height = Height;
usrdtl.ContactInfo = new ContactInfo
{
Id = Id,
HomeAddress = HomeAddress,
HomePhone = HomePhone,
OfficeAddress = OfficeAddress,
OfficePhone = OfficePhone,
EmailAdd = EmailAdd,
CellphoneNumber = CellphoneNumber
};
usrdtl.Specialization = new Specialization
{
Id = Id,
Name = Name,
Description = Description
};
tstDb.Physicians.Add(usrdtl);
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int DeleteUserById(int Id)
{
TestDBEntities tstDb = new TestDBEntities();
InfoUser usrdtl = new InfoUser();
usrdtl.ID = Id;
tstDb.Entry(usrdtl).State = EntityState.Deleted;
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int AddSpecialization(string Name, string Description)
{
TestDBEntities tstDb = new TestDBEntities();
Physician usrdtl = new Physician();
usrdtl.Specialization.Name = Name;
usrdtl.Specialization.Description = Description;
tstDb.Physicians.Add(usrdtl);
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int AddUser(string Name, string Email)
{
TestDBEntities tstDb = new TestDBEntities();
InfoUser usrdtl = new InfoUser();
usrdtl.Name = Name;
usrdtl.Email = Email;
tstDb.InfoUsers.Add(usrdtl);
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int AddUser(string Name, string Email)
{
TestDBEntities tstDb = new TestDBEntities();
UserDetail usrdtl = new UserDetail();
usrdtl.Name = Name;
usrdtl.Email = Email;
tstDb.UserDetails.Add(usrdtl);
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int UpdateUser(int Id, string Name, string Email)
{
TestDBEntities tstDb = new TestDBEntities();
UserDetail usrdtl = new UserDetail();
usrdtl.Id = Id;
usrdtl.Name = Name;
usrdtl.Email = Email;
tstDb.Entry(usrdtl).State = EntityState.Modified;
int Retval = tstDb.SaveChanges();
return(Retval);
}
public UserDetail GetAllUserById(int id)
{
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.UserDetails where k.Id == id select k;
UserDetail usr = new UserDetail();
foreach (var item in lstUsr)
{
usr.Id = item.Id;
usr.Name = item.Name;
usr.Email = item.Email;
}
return(usr);
}
public InfoUser GetAllUserById(int id)
{
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.InfoUsers where k.ID == id select k;
InfoUser usr = new InfoUser();
foreach (var item in lstUsr)
{
usr.ID = item.ID;
usr.Name = item.Name;
usr.Email = item.Email;
}
return(usr);
}
public int AddContact(string HomeAddress, Int64 HomePhone, string OfficeAddress, Int64 OfficePhone, string EmailAdd, Int64 CellphoneNumber)
{
TestDBEntities tstDb = new TestDBEntities();
Physician usrdtl = new Physician();
usrdtl.ContactInfo.HomeAddress = HomeAddress;
usrdtl.ContactInfo.HomePhone = HomePhone;
usrdtl.ContactInfo.OfficeAddress = OfficeAddress;
usrdtl.ContactInfo.OfficePhone = OfficePhone;
usrdtl.ContactInfo.EmailAdd = EmailAdd;
usrdtl.ContactInfo.CellphoneNumber = CellphoneNumber;
tstDb.Physicians.Add(usrdtl);
int Retval = tstDb.SaveChanges();
return(Retval);
}
public int DeleteUserById(int Id)
{
TestDBEntities tstDb = new TestDBEntities();
Specialization usrspc = new Specialization();
ContactInfo usrctn = new ContactInfo();
Physician usrdtl = new Physician();
usrspc.Id = Id;
usrctn.Id = Id;
usrdtl.Id = Id;
tstDb.Entry(usrspc).State = EntityState.Deleted;
tstDb.Entry(usrctn).State = EntityState.Deleted;
tstDb.Entry(usrdtl).State = EntityState.Deleted;
int Retval = tstDb.SaveChanges();
return(Retval);
}
public List <InfoUser> GetAllUser()
{
List <InfoUser> userlst = new List <InfoUser>();
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.InfoUsers select k;
foreach (var item in lstUsr)
{
InfoUser usr = new InfoUser();
usr.ID = item.ID;
usr.Name = item.Name;
usr.Email = item.Email;
userlst.Add(usr);
}
return(userlst);
}
public List <UserDetail> GetAllUser()
{
List <UserDetail> userlst = new List <UserDetail>();
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.UserDetails select k;
foreach (var item in lstUsr)
{
UserDetail usr = new UserDetail();
usr.Id = item.Id;
usr.Name = item.Name;
usr.Email = item.Email;
userlst.Add(usr);
}
return(userlst);
}
public List <Physician> GetAllSpecialization()
{
List <Physician> userlst = new List <Physician>();
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.Physicians select k;
foreach (var item in lstUsr)
{
Physician usr = new Physician();
usr.Specialization.Name = item.Specialization.Description;
usr.Specialization.Name = item.Specialization.Description;
userlst.Add(usr);
}
return(userlst);
}
public List <Physician> GetAllContactInfo()
{
List <Physician> userlst = new List <Physician>();
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.Physicians select k;
foreach (var item in lstUsr)
{
Physician usr = new Physician();
usr.ContactInfo.HomeAddress = item.ContactInfo.HomeAddress;
usr.ContactInfo.HomePhone = item.ContactInfo.HomePhone;
usr.ContactInfo.OfficeAddress = item.ContactInfo.OfficeAddress;
usr.ContactInfo.OfficePhone = item.ContactInfo.OfficePhone;
usr.ContactInfo.EmailAdd = item.ContactInfo.EmailAdd;
usr.ContactInfo.CellphoneNumber = item.ContactInfo.CellphoneNumber;
userlst.Add(usr);
}
return(userlst);
}
public List <Physician> GetAllPersonalInfo()
{
List <Physician> userlst = new List <Physician>();
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.Physicians select k;
foreach (var item in lstUsr)
{
Physician usr = new Physician();
usr.Id = item.Id;
usr.FirstName = item.FirstName;
usr.MiddleName = item.MiddleName;
usr.LastName = item.LastName;
usr.BirthDate = item.BirthDate;
usr.Gender = item.Gender;
usr.Weight = item.Weight;
usr.Height = item.Height;
usr.ContactInfo = new ContactInfo
{
Id = item.Id,
HomeAddress = item.ContactInfo.HomeAddress,
HomePhone = item.ContactInfo.HomePhone,
OfficeAddress = item.ContactInfo.OfficeAddress,
OfficePhone = item.ContactInfo.OfficePhone,
EmailAdd = item.ContactInfo.EmailAdd,
CellphoneNumber = item.ContactInfo.CellphoneNumber,
};
usr.Specialization = new Specialization
{
Id = item.Id,
Name = item.Specialization.Name,
Description = item.Specialization.Description,
};
userlst.Add(usr);
}
return(userlst);
}
public Physician GetAllUserById(int id)
{
TestDBEntities tstDb = new TestDBEntities();
var lstUsr = from k in tstDb.Physicians where k.Id == id select k;
Physician usr = new Physician();
foreach (var item in lstUsr)
{
usr.Id = item.Id;
usr.FirstName = item.FirstName;
usr.MiddleName = item.MiddleName;
usr.LastName = item.LastName;
usr.BirthDate = item.BirthDate;
usr.Gender = item.Gender;
usr.Weight = item.Weight;
usr.Height = item.Height;
usr.ContactInfo = new ContactInfo
{
Id = item.Id,
HomeAddress = item.ContactInfo.HomeAddress,
HomePhone = item.ContactInfo.HomePhone,
OfficeAddress = item.ContactInfo.OfficeAddress,
OfficePhone = item.ContactInfo.OfficePhone,
EmailAdd = item.ContactInfo.EmailAdd,
CellphoneNumber = item.ContactInfo.CellphoneNumber
};
usr.Specialization = new Specialization
{
Id = item.Id,
Name = item.Specialization.Name,
Description = item.Specialization.Description
};
}
return(usr);
}
public int UpdateUser(int Id, string FirstName, string MiddleName, string LastName, DateTime BirthDate, string Gender, int?Weight, int?Height, string HomeAddress, Int64?HomePhone, string OfficeAddress, Int64 OfficePhone, string EmailAdd, Int64?CellphoneNumber, string Name, string Description)
{
TestDBEntities tstDb = new TestDBEntities();
Physician usrdtl = new Physician();
usrdtl.Id = Id;
usrdtl.FirstName = FirstName;
usrdtl.MiddleName = MiddleName;
usrdtl.LastName = LastName;
usrdtl.BirthDate = BirthDate;
usrdtl.Gender = Gender;
usrdtl.Weight = Weight;
usrdtl.Height = Height;
ContactInfo usrctn = new ContactInfo();
usrctn.Id = Id;
usrctn.HomeAddress = HomeAddress;
usrctn.HomePhone = HomePhone;
usrctn.OfficeAddress = OfficeAddress;
usrctn.OfficePhone = OfficePhone;
usrctn.EmailAdd = EmailAdd;
usrctn.CellphoneNumber = CellphoneNumber;
Specialization usrspc = new Specialization();
usrspc.Id = Id;
usrspc.Name = Name;
usrspc.Description = Description;
tstDb.Entry(usrdtl).State = EntityState.Modified;
tstDb.Entry(usrctn).State = EntityState.Modified;
tstDb.Entry(usrspc).State = EntityState.Modified;
int Retval = tstDb.SaveChanges();
return(Retval);
}