public int Save(DrRegistration aRegistration)
{
string query = @"INSERT INTO [dbo].[DrRegistration]
([Image]
,[DoctorName]
,[Email]
,[RegistrationNo]
,[NID]
,[PhoneNo]
,[Gender]
,[DOB]
,[Degree]
,[SpecialityId]
,[Password])
VALUES('" + aRegistration.Image + "','" + aRegistration.Name + "','" + aRegistration.Email + "','" + aRegistration.RegistrationNo + "'," +
"'" + aRegistration.NID + "','" + aRegistration.PhoneNo + "','" + aRegistration.Gender + "','" + aRegistration.DOB + "'," +
"'" + aRegistration.Degree + "','" + aRegistration.SpecialityId + "','" + aRegistration.Password + "')";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffected = cmd.ExecuteNonQuery();
con.Close();
return(rowAffected);
}
public List <DrRegistration> GetAll()
{
string query = @"select * from DrRegistration";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <DrRegistration> aList = new List <DrRegistration>();
while (reader.Read())
{
DrRegistration aRegistration = new DrRegistration();
aRegistration.Id = (int)reader["Id"];
aRegistration.Image = reader["Image"].ToString();
aRegistration.Name = reader["DoctorName"].ToString();
aRegistration.Email = reader["Email"].ToString();
aRegistration.RegistrationNo = reader["RegistrationNo"].ToString();
aRegistration.NID = reader["NID"].ToString();
aRegistration.PhoneNo = reader["PhoneNo"].ToString();
aRegistration.Gender = reader["Gender"].ToString();
aRegistration.DOB = Convert.ToDateTime(reader["DOB"].ToString());
aRegistration.Degree = reader["Degree"].ToString();
aRegistration.SpecialityId = (int)reader["SpecialityId"];
aRegistration.Password = reader["Password"].ToString();
aList.Add(aRegistration);
}
reader.Close();
con.Close();
return(aList);
}
public ActionResult Create(DrRegistration aRegistration)
{
ViewBag.Specialyty = aManager.GetAllSpeciality();
try
{
if (ModelState.IsValid)
{
int message = aManager.Save(aRegistration);
if (message > 0)
{
ViewBag.showMsg = "Insert Successfully";
}
else
{
ViewBag.showMsg = "failed to Insert! please try again";
}
}
}
catch (Exception exception)
{
ViewBag.showMsg = exception.Message;
}
return(View());
}
public ActionResult Create(DrRegistration aRegistration)
{
ViewBag.Specialyty = aManager.GetAllSpeciality();
if (aLoginManager.IsDoctorEmailExists(aRegistration.Email))
{
ViewBag.showMsg = "Email already exist";
}
else
{
string fileName = Path.GetFileNameWithoutExtension(aRegistration.ImageFile.FileName);
string extension = Path.GetExtension(aRegistration.ImageFile.FileName);
fileName = aRegistration.NID + extension;
aRegistration.Image = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
aRegistration.ImageFile.SaveAs(fileName);
int message = aManager.Save(aRegistration);
if (message > 0)
{
ViewBag.showMsg = "Insert Successfully";
}
else
{
ViewBag.showMsg = "failed to Insert! please try again";
}
}
return(View());
}
public ActionResult Delete(int?id)
{
if (Session["Id"] == null)
{
return(RedirectToAction("Home", "Home"));
;
}
DrRegistration aRegistration = aManager.Get(id);
return(View(aRegistration));
}
public ActionResult Edit(int?id)
{
if (Session["Id"] == null)
{
return(RedirectToAction("Home", "Home"));
;
}
int userId = (int)Session["Id"];
DrRegistration aRegistration = aManager.Get(userId);
return(View(aRegistration));
}
public int Update(DrRegistration aRegistration)
{
string query = @"UPDATE [dbo].[DrRegistration]
SET [Image]='" + aRegistration.Image + "',[DoctorName] ='" + aRegistration.Name + "',[Email]='" + aRegistration.Email +
"' ,[RegistrationNo]='" + aRegistration.RegistrationNo + "' ,[NID]='" + aRegistration.NID +
"' ,[PhoneNo]='" + aRegistration.PhoneNo + "' ,[Gender]='" + aRegistration.Gender + "' ,[DOB]='" + aRegistration.DOB +
"',[Degree]='" + aRegistration.Degree + "',[SpecialityId]='" + aRegistration.SpecialityId + "',[Password]='" + aRegistration.Password +
"' WHERE Id='" + aRegistration.Id + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffected = cmd.ExecuteNonQuery();
con.Close();
return(rowAffected);
}
public DrRegistration Get(int?id)
{
string query = @"SELECT [Id]
,[Image]
,[DoctorName]
,[Email]
,[RegistrationNo]
,[NID]
,[PhoneNo]
,[Gender]
,[DOB]
,[Degree]
,[SpecialityId]
,[Password]
FROM [dbo].[DrRegistration] where Id='" + id + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
DrRegistration aRegistration = new DrRegistration();
while (reader.Read())
{
aRegistration.Id = (int)reader["Id"];
aRegistration.Image = reader["Image"].ToString();
aRegistration.Name = reader["DoctorName"].ToString();
aRegistration.Email = reader["Email"].ToString();
aRegistration.RegistrationNo = reader["RegistrationNo"].ToString();
aRegistration.NID = reader["NID"].ToString();
aRegistration.PhoneNo = reader["PhoneNo"].ToString();
aRegistration.Gender = reader["Gender"].ToString();
aRegistration.DOB = Convert.ToDateTime(reader["DOB"].ToString());
aRegistration.Degree = reader["Degree"].ToString();
aRegistration.SpecialityId = (int)reader["SpecialityId"];
aRegistration.Password = reader["Password"].ToString();
}
reader.Close();
con.Close();
return(aRegistration);
}
public ActionResult Edit(DrRegistration aRegistration)
{
try
{
if (ModelState.IsValid)
{
int message = aManager.Update(aRegistration);
if (message > 0)
{
ViewBag.showMsg = "Updated Successfully";
}
else
{
ViewBag.showMsg = "failed to Update! please try again";
}
}
}
catch (Exception exception)
{
ViewBag.showMsg = exception.Message;
}
return(View());
}
public int Update(DrRegistration aRegistration)
{
return(aGateway.Update(aRegistration));
}
public int Save(DrRegistration aRegistration)
{
return(aGateway.Save(aRegistration));
}
