internal bool DeleteGroup(GetGroupRequest objReq) { using (var db = new WizzDataContext()) { var groupData = db.tblGroups.Where(x => x.groupId == objReq.groupId).FirstOrDefault(); var groupMembers = db.tblGroupMembers.Where(x => x.fkGroupId == groupData.pkId).ToList(); db.tblGroupMembers.DeleteAllOnSubmit(groupMembers); db.tblGroups.DeleteOnSubmit(groupData); db.SubmitChanges(); return true; } }
public Response<GetGroupModel> DeleteGroup(GetGroupRequest objReq) { // GroupModel objReq = new GroupModel(); Response<GetGroupModel> response = new Response<GetGroupModel>(); List<GetGroupModel> objResp = new List<GetGroupModel>(); try { DbMethodsV2 objDBMethodV2 = new DbMethodsV2(); if (CheckRequestIsvalidornot(this.Request)) { if (objDBMethodV2.DeleteGroup(objReq)) { response.Create(true, Messages.FormatMessage(Messages.Success, "Group Deleted"), Messages.AppVersion, objResp); } else { response.Create(false, Messages.InvalidReq, Messages.AppVersion, objResp); } } else { response.Create(false, Messages.FormatMessage(Messages.InvalidReq), Messages.AppVersion, objResp); } } catch (Exception ex) { object session = new JavaScriptSerializer().Serialize(objReq); LogManager.Error(ex.Message, ex, session, ex.Message); response.Create(false, "Error occured while Processing Webservice request", Messages.AppVersion, objResp); } finally { } return response; }
internal GetGroupModel GetGroupDetails(GetGroupRequest objReq) { using (var db = new WizzDataContext()) { var groupData = db.tblGroups.Where(x => x.groupId == objReq.groupId).FirstOrDefault(); GetGroupModel OBjGroup = new GetGroupModel(); OBjGroup.groupId = groupData.groupId; OBjGroup.groupPic = Constants.imagepath + groupData.groupPic; OBjGroup.subjectName = groupData.subjectName; OBjGroup.timeSlot = groupData.timeSlot; OBjGroup.groupName = groupData.groupName; OBjGroup.groupMembers = (from c in db.usp_P2GetGroupMembers(Convert.ToInt32(groupData.pkId)) select new BasicUserModel { userName = c.userName, profilePic = c.profilePic, userId = c.pkUserId.ToString() }).ToList(); return OBjGroup; } }