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