public ActionResult About()
{
CareerFairRepository careerFairRepo = new CareerFairRepository();
careerfair selectCareerFair = careerFairRepo.SelectOne(1);
return(View(selectCareerFair));
}
public List <careerfair> Read()
{
List <careerfair> careerFairs = new List <careerfair>();
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT [CareerFairID],[Phone],[Date],[Address],[About]");
sb.Append("FROM [careerfair].[careerfair]");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
careerfair car = new careerfair();
car.CareerFairID = DatabaseHelper.CheckNullInt(reader, 0);
car.Phone = DatabaseHelper.CheckNullString(reader, 1);
car.Date = DatabaseHelper.CheckNullDateTime(reader, 2);
car.Address = DatabaseHelper.CheckNullString(reader, 3);
car.About = DatabaseHelper.CheckNullString(reader, 4);
careerFairs.Add(car);
}
}
}
}
return(careerFairs);
}
public void Update(careerfair careerfair)
{
var oldCareerFair = _careerFairs.Where(c => c.CareerFairID == careerfair.CareerFairID).FirstOrDefault();
if (oldCareerFair != null)
{
_careerFairs.Remove(oldCareerFair);
_careerFairs.Add(careerfair);
_ds.Update(careerfair);
}
}
public ActionResult LandingPageEdit(int id, careerfair LandingPage)
{
try
{
DAL.CareerFairDAL.CareerFairRepository careerFairLandingPage = new DAL.CareerFairDAL.CareerFairRepository();
careerFairLandingPage.Update(LandingPage);
return(RedirectToAction("LandingPage"));
}
catch
{
return(View());
}
}
public void Update(careerfair careerFair)
{
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE [careerfair].[careerfair]");
sb.Append("SET [Phone] = @param1, Date = @param2, Address = @param3, About = @param4 ");
sb.Append("WHERE [CareerFairID] = " + careerFair.CareerFairID);
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.Add("@param1", SqlDbType.NVarChar, 20).Value = (object)careerFair.Phone ?? DBNull.Value;
command.Parameters.Add("@param2", SqlDbType.DateTime).Value = (object)careerFair.Date ?? DBNull.Value;
command.Parameters.Add("@param3", SqlDbType.NVarChar, 50).Value = (object)careerFair.Address ?? DBNull.Value;
command.Parameters.Add("@param4", SqlDbType.NVarChar, int.MaxValue).Value = (object)careerFair.About ?? DBNull.Value;
command.CommandType = System.Data.CommandType.Text;
command.ExecuteNonQuery();
}
}
}
public careerfair SelectOne(int id)
{
careerfair selectedCareerFair = _careerFairs.Where(c => c.CareerFairID == id).FirstOrDefault();
return(selectedCareerFair);
}
public void Insert(careerfair careerfair)
{
throw new NotImplementedException();
}
