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; }