public int AssignRolesToUser(int RoleId, int UserId) { try { var query = from o in obj.UserRolesContainers where o.userId == UserId select o; DB.UserRolesContainer urc = new DB.UserRolesContainer(); if (query.Count() == 0) { urc.RolesId = RoleId; urc.userId = UserId; obj.UserRolesContainers.InsertOnSubmit(urc); obj.SubmitChanges(); } else { foreach (var item in query) { item.RolesId = RoleId; item.userId = UserId; } obj.SubmitChanges(); } return(1); } catch { return(-1); } }
public int Save(Models.MUserRolesContainer model) { Common.Logger l = new Common.Logger(); string ClassName = "CUserRolesContainer"; try { DB.UserRolesContainer bs = new DB.UserRolesContainer(); bs.id = int.Parse(model.id); bs.userId = int.Parse(model.userId); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] userId[" + model.userId + "] RolesId[" + model.Rolesid + "] "); obj.UserRolesContainers.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }