public bool Save() { try { if (ItExists()) { SqlConnectionGenerator.ExecuteStoreProcedure("sp_update_book", new string[] { "@Book_Id", "@Title", "@Description" }, new object[] { this.Id, this.Title, this.Description } ); } else { SqlConnectionGenerator.ExecuteStoreProcedure("sp_create_book", new string[] { "@Title", "@Description", "@User_Id" }, new object[] { this.Title, this.Description, this.User_Id } ); } return(true); } catch (System.Exception) { return(false); } }
public bool Save() { try { if (ItExists()) { SqlConnectionGenerator.ExecuteStoreProcedure("sp_update_micropost", new string[] { "@MicroPost_Id", "@Content" }, new object[] { this.Id, this.Content } ); } else { SqlConnectionGenerator.ExecuteStoreProcedure("sp_create_micropost", new string[] { "@Content", "@User_Id" }, new object[] { this.Content, this.User_Id } ); } return(true); } catch (System.Exception) { return(false); } }
public bool Save() { try { if (ItExists()) { SqlConnectionGenerator.ExecuteStoreProcedure("sp_update_user", new string[] { "@User_Id", "@Name", "@Email", "@Password", "@Gender" }, new object[] { this.Id, this.Name, this.Email, this.Password, this.Gender.ToString() } ); } else { SqlConnectionGenerator.ExecuteStoreProcedure("sp_create_user", new string[] { "@Name", "@Email", "@Password", @"Gender", "@Type" }, new object[] { this.Name, this.Email, this.Password, this.Gender.ToString(), this.Type.ToString() } ); } return(true); } catch (System.Exception) { return(false); } }
public static MicroPost Find(int Id) { DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_micropost", new string[] { "@MicroPost_Id" }, new object[] { Id } ); return(new MicroPost( int.Parse(dataTable.Rows[0][0].ToString()), dataTable.Rows[0][1].ToString(), int.Parse(dataTable.Rows[0][2].ToString()) )); }
public static Book Find(int Id) { DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_book", new string[] { "@Book_Id" }, new object[] { Id } ); return(new Book( int.Parse(dataTable.Rows[0][0].ToString()), dataTable.Rows[0][1].ToString(), dataTable.Rows[0][2].ToString(), int.Parse(dataTable.Rows[0][3].ToString()) )); }
public bool Delete() { try { SqlConnectionGenerator.ExecuteStoreProcedure("sp_delete_micropost", new string[] { "@MicroPost_Id" }, new object[] { this.Id } ); return(true); } catch (System.Exception) { return(false); } }
public static User FindBy(string Email, string Password) { DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_user_by_credentials", new string[] { "@Email", "@Password" }, new object[] { Email, Password } ); return(new User( int.Parse(dataTable.Rows[0][0].ToString()), dataTable.Rows[0][1].ToString(), dataTable.Rows[0][2].ToString(), dataTable.Rows[0][3].ToString(), dataTable.Rows[0][4].ToString(), dataTable.Rows[0][5].ToString() )); }
public static User Find(int Id) { DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_user", new string[] { "@User_Id" }, new object[] { Id } ); return(new User( int.Parse(dataTable.Rows[0][0].ToString()), dataTable.Rows[0][1].ToString(), dataTable.Rows[0][2].ToString(), dataTable.Rows[0][3].ToString(), dataTable.Rows[0][4].ToString(), dataTable.Rows[0][5].ToString() )); }
public static List <MicroPost> All() { List <MicroPost> microposts = new List <MicroPost>(); DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_all_microposts_from_newer"); for (int row = 0; row < dataTable.Rows.Count; row++) { microposts.Add(new MicroPost ( int.Parse(dataTable.Rows[row][0].ToString()), dataTable.Rows[row][1].ToString(), int.Parse(dataTable.Rows[row][2].ToString()) )); } return(microposts); }
private void GetMicroPosts() { if (this.Id != 0) { DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_user_microposts", new string[] { "@User_Id" }, new object[] { Id } ); for (int row = 0; row < dataTable.Rows.Count; row++) { MicroPosts.Add(new MicroPost ( int.Parse(dataTable.Rows[row][2].ToString()), dataTable.Rows[row][3].ToString(), int.Parse(dataTable.Rows[row][0].ToString()) )); } } }
public static List <User> All() { List <User> users = new List <User>(); DataTable dataTable = SqlConnectionGenerator.ExecuteStoreProcedure("sp_show_all_users"); for (int row = 0; row < dataTable.Rows.Count; row++) { users.Add(new User ( int.Parse(dataTable.Rows[row][0].ToString()), dataTable.Rows[row][1].ToString(), dataTable.Rows[row][2].ToString(), dataTable.Rows[row][3].ToString(), dataTable.Rows[row][4].ToString(), dataTable.Rows[row][5].ToString() )); } return(users); }