//---------------------------Show Receptionist----------------------------------------------------
public List <ReceptionistModel> ViewReceptionist()
{
List <ReceptionistModel> receptionistList = new List <ReceptionistModel>();
query = "SELECT * FROM ReceptionistTable";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
ReceptionistModel receptionist = new ReceptionistModel();
receptionist.FirstName = Reader["FirstName"].ToString();
receptionist.LastName = Reader["LastName"].ToString();
receptionist.BloodGroup = Reader["BloodGroup"].ToString();
receptionist.Address = Reader["Address"].ToString();
receptionist.Age = Convert.ToInt32(Reader["Age"]);
receptionist.ContactNo = Convert.ToInt32(Reader["ContactNo"]);
receptionistList.Add(receptionist);
}
Connection.Close();
return(receptionistList);
}
public string Save(ReceptionistModel receptionist)
{
int rowEffect = receptionistGateway.Save(receptionist);
if (rowEffect > 0)
{
return("Save Successful");
}
else
{
return("Save Faild");
}
}
public int Save(ReceptionistModel receptionist)
{
query = "INSERT INTO ReceptionistTable " +
"VALUES(@firstName,@lastName,@contactNo,@address," +
"@qalification,@Age,@BloodGroup ) ";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@firstName", receptionist.FirstName);
Command.Parameters.AddWithValue("@lastName", receptionist.LastName);
Command.Parameters.AddWithValue("@Age", receptionist.Age);
Command.Parameters.AddWithValue("@address", receptionist.Address);
Command.Parameters.AddWithValue("@qalification", receptionist.Qualification);
Command.Parameters.AddWithValue("@contactNo", receptionist.ContactNo);
Command.Parameters.AddWithValue("@BloodGroup", receptionist.BloodGroup);
Connection.Open();
int rowEffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffect);
}
public ActionResult SaveReceptionist(ReceptionistModel receptionist)
{
ViewBag.message = receptionistManager.Save(receptionist);
return(View());
}
public IHttpActionResult UpdateReceptionist([FromBody] ReceptionistModel receptionistModel)
{
_userFacade.UpdateReceptionist(Mapper.Map <ReceptionistDto>(receptionistModel), UserId);
return(Ok());
}
