public void signUp(UserRegister a)
{
Connection gcon = new Connection();
// gcon.getConnection();
gcon.ExecuteQuery("insert into UserReg values ('" + a.UName + "','" + a.UGender + "','" + a.UEmail + "','" + a.UPass + "','" + a.role + "','" + a.UContact + "')");
gcon.ExecuteQuery("insert into login values('" + a.UEmail + "','" + a.UPass + "','" + a.role + "')");
}
public void signUp(AdminRegister a)
{
Connection gcon = new Connection();
// gcon.getConnection();
gcon.ExecuteQuery("insert into AdminReg values ('" + a.Name + "','" + a.Email + "','" + a.Password + "','" + a.role + "')");
gcon.ExecuteQuery("insert into login values('" + a.Email + "','" + a.Password + "','" + a.role + "')");
}
public void Add(Blog s)
{
Models.Connection con = new Connection();
con.ExecuteQuery("insert into Blog values ('" + s.BlogName + "','" + s.Description + "','" + s.BlogPath + "','" + s.DateTime + "')");
}
public void Add(Time s)
{
Models.Connection con = new Connection();
con.ExecuteQuery("insert into ConsultationTime values('" + s.AppointmentTime + "')");
}
public void Add(Question s)
{
Models.Connection con = new Connection();
con.ExecuteQuery("insert into Question values('" + s.Quest + "','" + s.DateQuest + "','" + s.Uid + "')");
}
public void Add(Doctor s)
{
Models.Connection con1 = new Connection();
con1.ExecuteQuery("insert into Doctor values('" + s.Name + "','" + s.Email + "','" + s.Gender + "','" + s.Qualification + "','" + s.PicPath + "','" + s.Contact + "')");
}
public void Add(Appointment s)
{
Models.Connection con = new Connection();
con.ExecuteQuery("insert into Consultation values('" + s.Date + "','" + s.Time + "','" + s.Type + "','" + s.Reason + "','" + s.Did + "','" + s.PateintName + "','" + s.Uid + "')");
}