public ActionResult Edit(Recruiters rec)
{
int Userid = rec.Userid;
string Company = rec.Company, Focus = rec.Focus, Remail = rec.Remail;
RecruitersRepository.UpdateRecruiter(Userid, Company, Focus, Remail);
return RedirectToAction("Index", "Jobs");
}
public Recruiters FindRid(int Userid)
{
DbCommand command = db.GetStoredProcCommand("Recruiters_FindRid");
db.AddInParameter(command, "@Userid", System.Data.DbType.Int32, Userid);
db.ExecuteScalar(command);
var result = new Recruiters();
using (var reader = db.ExecuteReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("Rid")))
{
result.Rid = reader.GetInt32(reader.GetOrdinal("Rid"));
}
}
return result;
}
}
public ActionResult Create(Recruiters rec)
{
RecruitersRepository.InsertRecruiter(rec.Userid, rec.Company, rec.Focus, rec.Remail);
return RedirectToAction("LogOn", "Account");
}
public Recruiters ViewEditRecruiter(int id)
{
DbCommand command = db.GetStoredProcCommand("Recruiter_BuildList");
db.AddInParameter(command, "@Userid", System.Data.DbType.Int32, id);
db.ExecuteScalar(command);
var result = new Recruiters();
using (var reader = db.ExecuteReader(command))
{
while (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("Rid")))
{
result.Rid = reader.GetInt32(reader.GetOrdinal("Rid"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Userid")))
{
result.Userid = reader.GetInt32(reader.GetOrdinal("Userid"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Company")))
{
result.Company = reader.GetString(reader.GetOrdinal("Company"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Focus")))
{
result.Focus = reader.GetString(reader.GetOrdinal("Focus"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Remail")))
{
result.Remail = reader.GetString(reader.GetOrdinal("Remail"));
}
}
}
return result;
}
