// 0 - success // 1 - different owner // 2 - tab not exist // 3 - username not exist // 4 - can't share yourselt // 5 - exception public int ShareTab(int tabid, string userName) { int result = -1; try { RSSDBDataContext dt = new RSSDBDataContext(); var tabsToShare = dt.Tabs.Where(_tab => _tab.ID == tabid); if (tabsToShare.Count <Tab>() == 0) { result = 2; } else { var tabToShare = tabsToShare.Single(); if (tabToShare.UserID != GetCurrentUserID()) { result = 1; } else { Share share = new Share(); share.TabID = tabToShare.ID; var UsersToShare = dt.Accounts.Where(account => account.Username.CompareTo(userName) == 0); if (UsersToShare.Count <Account>() == 0) { result = 3; } else { share.AccountID = UsersToShare.Single().ID; if (share.AccountID == GetCurrentUserID()) { result = 4; } else { var shares = dt.Shares.Where(_share => _share.TabID == tabid && (_share.AccountID == GetCurrentUserID() || _share.AccountID == share.AccountID)); if (shares.Count <Share>() == 0) { dt.Shares.InsertOnSubmit(share); dt.SubmitChanges(); } result = 0; } } } } } catch { result = 3; } finally { } return(result); }
partial void UpdateShare(Share instance);
partial void DeleteShare(Share instance);
private void detach_Shares(Share entity) { this.SendPropertyChanging(); entity.Account = null; }
partial void InsertShare(Share instance);
public int ShareTab(int tabid, string userName) { int result = -1; try { RSSDBDataContext dt = new RSSDBDataContext(); var tabsToShare = dt.Tabs.Where(_tab => _tab.ID == tabid); if (tabsToShare.Count<Tab>() == 0) result = 2; else { var tabToShare = tabsToShare.Single(); if (tabToShare.UserID != GetCurrentUserID()) result = 1; else { Share share = new Share(); share.TabID = tabToShare.ID; var UsersToShare = dt.Accounts.Where(account => account.Username.CompareTo(userName) == 0); if (UsersToShare.Count<Account>() == 0) { result = 3; } else { share.AccountID = UsersToShare.Single().ID; if (share.AccountID == GetCurrentUserID()) result = 4; else { var shares = dt.Shares.Where(_share => _share.TabID == tabid && (_share.AccountID == GetCurrentUserID() || _share.AccountID == share.AccountID)); if (shares.Count<Share>() == 0) { dt.Shares.InsertOnSubmit(share); dt.SubmitChanges(); } result = 0; } } } } } catch { result = 3; } finally { } return result; }
private void attach_Shares(Share entity) { this.SendPropertyChanging(); entity.Account = this; }
partial void DeleteShare(Share instance);
partial void UpdateShare(Share instance);
partial void InsertShare(Share instance);
private void detach_Shares(Share entity) { this.SendPropertyChanging(); entity.Account = null; }
private void attach_Shares(Share entity) { this.SendPropertyChanging(); entity.Account = this; }