public void LeaveGroup(sp_Vol_GroupVol_DM GroupVol) { using (VolTeerEntities context = new VolTeerEntities()) { try { var GroupToRemove = (from n in context.tblGroupVols where n.VolID == GroupVol.VolID && n.GroupID == GroupVol.GroupID select n).FirstOrDefault(); context.tblGroupVols.Remove(GroupToRemove); context.SaveChanges(); } catch (Exception ex) { throw (ex); } } }
public void TestGroupVolCreate() { var group_bll = new sp_Group_BLL(); var vol_bll = new sp_Volunteer_BLL(); var groupVol_bll = new sp_GroupVol_BLL(); var groupVol_dm = new sp_Vol_GroupVol_DM(); var allGroups = group_bll.ListGroups(); var allVols = vol_bll.ListVolunteers(); Assert.IsTrue(allGroups.Count > 0, "ListGroups() is broken or no data in DB"); Assert.IsTrue(allVols.Count > 0, "ListVolunteers() is broken or no data in DB"); groupVol_dm.GroupID = allGroups[0].GroupID; groupVol_dm.VolID = allVols[0].VolID; groupVol_dm.Admin = true; groupVol_dm.PrimaryVolID = true; groupVol_bll.InsertGroupContext(ref groupVol_dm); var groupVol_dm_selected = groupVol_bll.ListGroupVols(groupVol_dm); Assert.AreEqual(1, groupVol_dm_selected.Count); Assert.IsTrue(Equals(groupVol_dm, groupVol_dm_selected[0])); }
protected void rBTNInvite_Click(object sender, EventArgs e) { foreach (GridDataItem item in rGridGroupVol.Items) { if (item.Selected == true) { int GroupID = Convert.ToInt32(item.GetDataKeyValue("GroupID").ToString()); RadButton btnInvite = (RadButton)sender; Guid VolID = new Guid(btnInvite.CommandArgument.ToString()); sp_Vol_GroupVol_DM GroupVol = new sp_Vol_GroupVol_DM(); GroupVol.VolID = VolID; GroupVol.GroupID = GroupID; GroupVolBLL.InsertGroupContext(ref GroupVol); } } rGridVolInvite.Rebind(); }
public sp_Vol_GroupVol_DM InsertGroupContext(ref sp_Vol_GroupVol_DM _cGroup) { using (VolTeerEntities context = new VolTeerEntities()) { var cGroup = new tblGroupVol { GroupID = _cGroup.GroupID, VolID = _cGroup.VolID, PrimaryVolID = _cGroup.PrimaryVolID, Admin = _cGroup.Admin }; context.tblGroupVols.Add(cGroup); context.SaveChanges(); // pass VolID back to BLL _cGroup.GroupID = cGroup.GroupID; return _cGroup; } }
protected void rGridGroupVol_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { try { sp_Vol_GroupVol_DM GroupVol = new sp_Vol_GroupVol_DM(); GroupVol.VolID = (Guid)currentUser.ProviderUserKey; rGridGroupVol.DataSource = GroupVolBLL.ListGroupVols(GroupVol); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
public List<sp_Vol_GroupVol_DM> ListGroupVols(sp_Vol_GroupVol_DM GroupVol) { List<sp_Vol_GroupVol_DM> list = new List<sp_Vol_GroupVol_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_GroupVol_Select(GroupVol.GroupID, GroupVol.VolID) select new sp_Vol_GroupVol_DM { GroupName = result.GroupName, ParticipationLevelID = result.ParticipationLevelID, Admin = result.Admin, GroupActive = result.GroupActive, GroupID = result.GroupID, PrimaryVolID = result.PrimaryVolID, VolActive = result.VolActive, VolFirstName = result.VolFirstName, VolMiddleName = result.VolMiddleName, VolLastName = result.VolLastName, VolID = result.VolID }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }
public void MakePrimaryVolID(sp_Vol_GroupVol_DM _cGroup) { using (VolTeerEntities context = new VolTeerEntities()) { var cGroup = context.tblGroupVols.Find(_cGroup.GroupID); var cVol = context.tblGroupVols.Find(_cGroup.VolID); if (cGroup.GroupID == _cGroup.GroupID && cGroup.VolID == _cGroup.VolID) { cGroup.GroupID = _cGroup.GroupID; cGroup.VolID = _cGroup.VolID; cGroup.PrimaryVolID = false; context.SaveChanges(); } else if (cGroup.GroupID == _cGroup.GroupID && cGroup.VolID != _cGroup.VolID) { cGroup.GroupID = _cGroup.GroupID; cGroup.VolID = _cGroup.VolID; cGroup.PrimaryVolID = true; context.SaveChanges(); } } }
//TODO: Create a MakePrimary method passing in VolID public void MakePrimaryVolID(sp_Vol_GroupVol_DM _cGroup) { DAL.MakeAdminVolID(_cGroup); }
public List<sp_Vol_GroupVol_DM> ListGroupVols(sp_Vol_GroupVol_DM GroupVol) { return DAL.ListGroupVols(GroupVol); }
public void LeaveGroup(sp_Vol_GroupVol_DM GroupVol) { DAL.LeaveGroup(GroupVol); }
//TODO: Create an insert method passing in domain model public sp_Vol_GroupVol_DM InsertGroupContext(ref sp_Vol_GroupVol_DM _cGroup) { return DAL.InsertGroupContext(ref _cGroup); }
//TODO: Create a delete all method passing in VolID public void DeleteGroupContext(sp_Vol_GroupVol_DM _cVolID) { DAL.DeleteGroupContext(_cVolID); }
bool Equals(sp_Vol_GroupVol_DM dm1, sp_Vol_GroupVol_DM dm2) { return (dm1.GroupID == dm2.GroupID && dm1.VolID == dm2.VolID && dm1.PrimaryVolID == dm2.PrimaryVolID && dm1.Admin == dm2.Admin ); }
private static List<sp_Vol_GroupVol_DM> DMsFrom(DataTable dataTable) { var DMs = new List<sp_Vol_GroupVol_DM>(); for (int i = 0; i < dataTable.Rows.Count; i++) { var returnGroupVol = new sp_Vol_GroupVol_DM(); returnGroupVol.GroupID = Convert.ToInt32(dataTable.Rows[i]["GroupID"]); returnGroupVol.VolID = new Guid((string)dataTable.Rows[i]["VolID"]); returnGroupVol.Admin = Convert.ToBoolean(dataTable.Rows[i]["Admin"]); returnGroupVol.PrimaryVolID = Convert.ToBoolean(dataTable.Rows[i]["PrimaryVolID"]); DMs.Add(returnGroupVol); } return DMs; }