public List <Consultations> AllConsultations() { List <Consultations> Allconsultattion = new List <Consultations>(); Conn.Open(); SqlCommand Scmm = new SqlCommand("select * from Consultation ", Conn); SqlDataReader dr = Scmm.ExecuteReader(); while (dr.Read()) { Consultations consoult = new Consultations(); consoult.Id = Convert.ToInt32(dr["Id"]); consoult.E_mail = Convert.ToString(dr["E_mail"]); consoult.Name = Convert.ToString(dr["Name"]); consoult.Phone = Convert.ToString(dr["Phone"]); consoult.Question = Convert.ToString(dr["Question"]); consoult.Service = Convert.ToString(dr["Service"]); Allconsultattion.Add(consoult); } Conn.Close(); return(Allconsultattion); }
public void Updateconsultations(int id, Consultations consultation) { Conn.Open(); SqlCommand Sqlcmm = new SqlCommand("UPDATE Consultation set E_mail='" + consultation.E_mail + "',Name='" + consultation.Name + "',Service='" + consultation.Service + "',Phone='" + consultation.Phone + "',Question='" + consultation.Question + "' where Id='" + id + "' ", Conn); Sqlcmm.ExecuteNonQuery(); Conn.Close(); }
public void Addconsultation(Consultations consultation) { Conn.Open(); SqlCommand Scmm = new SqlCommand("insert into Consultation (Name,E_mail,Phone,Question,Service) values( N'" + consultation.Name + "', N'" + consultation.E_mail + "','" + consultation.Phone + "',N'" + consultation.Question + "',N'" + consultation.Service + "')", Conn); Scmm.ExecuteNonQuery(); Conn.Close(); }
public Consultations GetConsultation(int id) { Consultations consoult = new Consultations(); Conn.Open(); SqlCommand Scmm = new SqlCommand("select * from Consultation where Id='" + id + "'", Conn); SqlDataReader dr = Scmm.ExecuteReader(); while (dr.Read()) { consoult.Id = Convert.ToInt32(dr["Id"]); consoult.E_mail = Convert.ToString(dr["E_mail"]); consoult.Name = Convert.ToString(dr["Name"]); consoult.Phone = Convert.ToString(dr["Phone"]); consoult.Question = Convert.ToString(dr["Question"]); consoult.Service = Convert.ToString(dr["Service"]); } Conn.Close(); return(consoult); }