public List <PendingCounsellor> retrievePendingCounsellor() // Change to admin model { PendingCounsellor pCounsellor = new PendingCounsellor(); // Change to admin model List <PendingCounsellor> pCounsellorList = new List <PendingCounsellor>(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM PendingCounsellor"; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pCounsellorList.Add( new PendingCounsellor { PCounsellorID = reader.GetInt32(0), Name = reader.GetString(1), Email = reader.GetString(2), PhoneNumber = reader.GetString(3), DateBirth = reader.GetDateTime(4), Image = reader.GetString(5), Certificate = reader.GetString(6) }); } reader.Close(); conn.Close(); return(pCounsellorList); }
public PendingCounsellor retrieveSpecificPendingCounsellor(int id) // Change to admin model { PendingCounsellor pCounsellor = new PendingCounsellor(); // Change to admin model SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM PendingCounsellor WHERE PCounsellorID = @id"; conn.Open(); cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { pCounsellor.PCounsellorID = reader.GetInt32(0); pCounsellor.Name = reader.GetString(1); pCounsellor.Email = reader.GetString(2); pCounsellor.PhoneNumber = reader.GetString(3); pCounsellor.DateBirth = reader.GetDateTime(4); pCounsellor.Image = reader.GetString(5); pCounsellor.Certificate = reader.GetString(6); } } reader.Close(); conn.Close(); return(pCounsellor); }
public void CounsellorForm(PendingCounsellor counsellorForm) { SqlCommand cmd = conn.CreateCommand(); //string status = "Pending"; //DateTime currentDT = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd h:mm:ss tt")); //string defaultPassword = "******"; DateTime temp = Convert.ToDateTime(DateTime.Now.ToString("2020-01-01")); cmd.CommandText = @"INSERT INTO PendingCounsellor(Name, Email, PhoneNo, DateBirth, Image, Certificate) VALUES(@name, @email, @phoneno, @datebirth, @image, @certificate)"; cmd.Parameters.AddWithValue("@name", counsellorForm.Name); //cmd.Parameters.AddWithValue("@password", defaultPassword); cmd.Parameters.AddWithValue("@email", counsellorForm.Email); //cmd.Parameters.AddWithValue("@datecreated", currentDT); cmd.Parameters.AddWithValue("@phoneno", counsellorForm.PhoneNumber); cmd.Parameters.AddWithValue("@datebirth", temp); cmd.Parameters.AddWithValue("@image", counsellorForm.Image); cmd.Parameters.AddWithValue("@certificate", counsellorForm.Certificate); //cmd.Parameters.AddWithValue("@avgrating", counsellorForm.AvgRating); //cmd.Parameters.AddWithValue("@status", status); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public ActionResult Counsellor(IFormCollection formData) { string name = formData["name"].ToString(); string email = formData["email"].ToString(); string phoneno = formData["number"].ToString(); PendingCounsellor counsellor = new PendingCounsellor(); counsellor.Name = name; counsellor.Email = email; counsellor.PhoneNumber = phoneno; counsellor.Image = Request.Form["base64Image"]; counsellor.Certificate = Request.Form["base64Certificate"]; counsellorDAL.CounsellorForm(counsellor); return(View()); }
public void CounsellorForm(PendingCounsellor counsellorForm) { SqlCommand cmd = conn.CreateCommand(); DateTime temp = Convert.ToDateTime(DateTime.Now.ToString("2020-01-01")); cmd.CommandText = @"INSERT INTO PendingCounsellor(Name, Email, PhoneNo, DateBirth, Image, Certificate) VALUES(@name, @email, @phoneno, @datebirth, @image, @certificate)"; cmd.Parameters.AddWithValue("@name", counsellorForm.Name); cmd.Parameters.AddWithValue("@email", counsellorForm.Email); cmd.Parameters.AddWithValue("@phoneno", counsellorForm.PhoneNumber); cmd.Parameters.AddWithValue("@datebirth", temp); cmd.Parameters.AddWithValue("@image", counsellorForm.Image); cmd.Parameters.AddWithValue("@certificate", counsellorForm.Certificate); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public bool ApproveCounsellor(int id) { SqlCommand cmd = conn.CreateCommand(); string password = "******"; DateTime datetime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd h:mm:ss tt")); DateTime tempDate = Convert.ToDateTime(DateTime.Now.ToString("2020-01-01")); string status = "Active"; cmd.CommandText = @"INSERT INTO Counsellor(Name, Password, Email, DateCreated, PhoneNo, Image, Certificate, DateBirth, AvgRating, Status) VALUES(@name, @password, @email, @datecreated, @phoneno, @image, @certificate, @datebirth, @avgrating, @status)"; PendingCounsellor retrieved = retrieveSpecificPendingCounsellor(id); cmd.Parameters.AddWithValue("@name", retrieved.Name); cmd.Parameters.AddWithValue("@password", password); cmd.Parameters.AddWithValue("@email", retrieved.Email); cmd.Parameters.AddWithValue("@datecreated", datetime); cmd.Parameters.AddWithValue("@phoneNo", retrieved.PhoneNumber); cmd.Parameters.AddWithValue("@image", retrieved.Image); cmd.Parameters.AddWithValue("@certificate", retrieved.Certificate); cmd.Parameters.AddWithValue("@datebirth", tempDate.Date); cmd.Parameters.AddWithValue("@avgrating", DBNull.Value); cmd.Parameters.AddWithValue("@status", status); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); cmd.CommandText = @"DELETE FROM PendingCounsellor WHERE PCounsellorID = @id"; cmd.Parameters.AddWithValue("@id", id); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return(true); }