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