public Response<string> InviteFriends(InviteFriendsModel objReq) { Response<string> response = new Response<string>(); List<string> objResp = new List<string>(); try { if (ModelState.IsValid) { objDbMethodV2 = new wizz.Dal.DbMethodsV2(); int retValue = objDbMethodV2.InviteFriends(objReq); if (retValue > 0) response.Create(true, "done", Messages.AppVersion, objResp); else { response.Create(false, "you are not allowed", Messages.AppVersion, objResp); } } else response.Create(false, ModelState.Values.FirstOrDefault().Errors.FirstOrDefault().ErrorMessage, Messages.AppVersion, objResp); } catch (Exception ex) { object session = new JavaScriptSerializer().Serialize(objReq); LogManager.Error("Error occured while Processing Webservice request :{0}", ex, session, ex.Message); response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp); } finally { } return response; }
internal int InviteFriends(InviteFriendsModel objReq) { try { var response = 0; using (var db = new WizzDataContext()) { List<tblInviteFriend> userList = new List<tblInviteFriend>(); tblInviteFriend myObj = new tblInviteFriend(); List<tblInviteFriend> friendList = new List<tblInviteFriend>(); friendList = db.tblInviteFriends.Where(x => x.uniqueRequestId == objReq.sessionId).ToList(); if (friendList.Count > 0) { db.tblInviteFriends.DeleteAllOnSubmit(friendList); db.SubmitChanges(); } myObj.fkUserId = Convert.ToInt32(objReq.userId); myObj.isConfirm = true; myObj.userName = ""; myObj.phoneNum = ""; myObj.isDelete = false; myObj.uniqueRequestId = objReq.sessionId; myObj.fkFriendId = Convert.ToInt32(objReq.userId); userList.Add(myObj); foreach (var i in objReq.Friends) { tblInviteFriend userObj = new tblInviteFriend(); var isExist = db.tblUsers.FirstOrDefault(e => e.phoneNum.Contains(i.phoneNumber)); if (isExist != null) { userObj.userName = ""; userObj.phoneNum = ""; userObj.uniqueRequestId = objReq.sessionId; userObj.isConfirm = true; userObj.fkUserId = Convert.ToInt32(objReq.userId); userObj.fkFriendId = Convert.ToInt32(isExist.pkUserId); userObj.createdDate = DateTime.UtcNow; userObj.isDelete = false; userObj.updatedDate = DateTime.UtcNow; response = 1; } else { userObj.userName = i.userName; userObj.phoneNum = i.phoneNumber; userObj.uniqueRequestId = objReq.sessionId; userObj.isConfirm = false; userObj.fkUserId = Convert.ToInt32(objReq.userId); userObj.fkFriendId = 0; userObj.createdDate = DateTime.UtcNow; userObj.isDelete = false; userObj.updatedDate = DateTime.UtcNow; response = 2; } userList.Add(userObj); // db.tblInviteFriends.InsertOnSubmit(obj); } db.tblInviteFriends.InsertAllOnSubmit(userList); db.SubmitChanges(); } return response; } catch (Exception ex) { return -1; } }