public ActionResult AddWorkspace(FormCollection collection) { VC_Workspace wspobj = new VC_Workspace(); VC_WorkspaceUser wsuser = new VC_WorkspaceUser(); wspobj.Owner_User_Id = Convert.ToInt32(collection[0]); wspobj.Workspace_Name = collection[1].ToString(); wspobj.Created_TS = DateTime.Now; wspobj.Updated_TS = DateTime.Now; dbobj.AddToVC_Workspace(wspobj); dbobj.SaveChanges(); int inserted = wspobj.Workspace_Id; wsuser.Workspace_Id = inserted; wsuser.User_Id = Convert.ToInt32(HttpContext.Session["userid"]); wsuser.Created_TS = DateTime.Now; wsuser.Updated_TS = DateTime.Now; dbobj.AddToVC_WorkspaceUser(wsuser); dbobj.SaveChanges(); return RedirectToAction("AddWorkspace"); }
public ActionResult usertoworkspace(int id, string workspace) { VC_WorkspaceUser tableobj = new VC_WorkspaceUser(); var workspacedetails = (from m in dbobj.VC_Workspace where m.Workspace_Name == workspace select m).FirstOrDefault(); int workspaceid = workspacedetails.Workspace_Id; tableobj.Workspace_Id = workspaceid; tableobj.User_Id = id; tableobj.Created_TS = DateTime.Now; tableobj.Updated_TS = DateTime.Now; dbobj.AddToVC_WorkspaceUser(tableobj); dbobj.SaveChanges(); return RedirectToAction("AddUser", new { workspace = workspace }); }
public ActionResult Register1(FormCollection collection) { VC_User userobj = new VC_User(); userobj.User_Privilage = Convert.ToInt32(collection[0]); userobj.User_Name = collection[1].ToString().Trim(); userobj.User_Password = collection[2].ToString().Trim(); userobj.Created_TS = DateTime.Now; userobj.Updated_TS = DateTime.Now; dbobj.AddToVC_User(userobj); dbobj.SaveChanges(); int inserted = userobj.User_Id; VC_WorkspaceUser wsobj = new VC_WorkspaceUser(); wsobj.User_Id = inserted; wsobj.Workspace_Id = Convert.ToInt16(collection[4]); wsobj.Created_TS = DateTime.Now; wsobj.Updated_TS = DateTime.Now; dbobj.AddToVC_WorkspaceUser(wsobj); dbobj.SaveChanges(); if (userobj.User_Privilage == 4) { return RedirectToAction("Student", new { k = inserted}); } else { return RedirectToAction("RegisterStaff", new { k = inserted }); } }