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