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