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