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 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 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);
}