public ActionResult AssignResoursePerson(int selectProject, int selectUser) { AssignPerson assignPerson = new AssignPerson(); assignPerson.ProjectId = selectProject; assignPerson.UserId = selectUser; AssignPersonManager assignPersonManager = new AssignPersonManager(); try { int rowCount = assignPersonManager.SaveAssignPerson(assignPerson); if (rowCount > 0) { ViewBag.mgs = "Person Assign has been successfully ."; } else { ViewBag.mg = "User already assign this Project ."; } } catch (Exception e) { ViewBag.mg = e.Message; } ViewBag.listofUsesr = GetUser(); ViewBag.listOfProject = GetProject(); ViewBag.listOfShowAssignPerson = ShowAssignPerson(); return(View()); }
public IHttpActionResult PutAssignPerson(int id, AssignPerson assignPerson) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != assignPerson.ID) { return(BadRequest()); } db.Entry(assignPerson).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AssignPersonExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { AssignPerson assignPerson = db.AssignPersons.Find(id); db.AssignPersons.Remove(assignPerson); db.SaveChanges(); return(RedirectToAction("Index")); }
public int SaveAssignPerson(AssignPerson assignPerson) { assignPersonGatway = new AssignPersonGatway(); if (assignPersonGatway.IsExistUserName(assignPerson.ProjectId, assignPerson.UserId).Rows.Count > 0) { return(0); } return(assignPersonGatway.SaveAssignPerson(assignPerson)); }
public IHttpActionResult GetAssignPerson(int id) { AssignPerson assignPerson = db.AssignPersons.Find(id); if (assignPerson == null) { return(NotFound()); } return(Ok(assignPerson)); }
public IHttpActionResult PostAssignPerson(AssignPerson assignPerson) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.AssignPersons.Add(assignPerson); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = assignPerson.ID }, assignPerson)); }
public ActionResult Edit([Bind(Include = "Id,UserId,ProjctId,AssignBy")] AssignPerson assignPerson) { if (ModelState.IsValid) { db.Entry(assignPerson).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProjctId = new SelectList(db.Projcts, "Id", "Name", assignPerson.ProjctId); ViewBag.UserId = new SelectList(db.Users, "Id", "Name", assignPerson.UserId); return(View(assignPerson)); }
public int SaveAssignPerson(AssignPerson assignPerson) { int rowCount = 0; string sql = "Insert into AssignPerson_tb (ProjectId,UserId) Values(@ProjectId,@UserId)"; cmd = new SqlCommand(sql, oConnectionClass.GetConnection()); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("ProjectId", assignPerson.ProjectId); cmd.Parameters.AddWithValue("UserId", assignPerson.UserId); rowCount = cmd.ExecuteNonQuery(); oConnectionClass.GetColse(); return(rowCount); }
public IHttpActionResult DeleteAssignPerson(int id) { AssignPerson assignPerson = db.AssignPersons.Find(id); if (assignPerson == null) { return(NotFound()); } db.AssignPersons.Remove(assignPerson); db.SaveChanges(); return(Ok(assignPerson)); }
public ActionResult Create([Bind(Include = "Id,UserId,ProjctId,AssignBy")] AssignPerson assignPerson) { if (ModelState.IsValid) { assignPerson.AssignBy = User.Identity.Name; db.AssignPersons.Add(assignPerson); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProjctId = new SelectList(db.Projcts, "Id", "Name", assignPerson.ProjctId); ViewBag.UserId = new SelectList(db.Users, "Id", "Name", assignPerson.UserId); return(View(assignPerson)); }
// GET: AssignPersons/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AssignPerson assignPerson = db.AssignPersons.Find(id); if (assignPerson == null) { return(HttpNotFound()); } return(View(assignPerson)); }
// GET: AssignPersons/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AssignPerson assignPerson = db.AssignPersons.Find(id); if (assignPerson == null) { return(HttpNotFound()); } ViewBag.ProjctId = new SelectList(db.Projcts, "Id", "Name", assignPerson.ProjctId); ViewBag.UserId = new SelectList(db.Users, "Id", "Name", assignPerson.UserId); return(View(assignPerson)); }