private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Author obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldSURNAME, "@p_surname");
command.Parameters.AddWithValue("p_surname", obj.Surname);
builder.AddParameter(tableFieldFIRSTNAME, "@p_firstname");
command.Parameters.AddWithValue("p_firstname", obj.FirstName);
builder.AddParameter(tableFieldSECONDNAME, "@p_secondname");
command.Parameters.AddWithValue("p_secondname", obj.SecondName);
builder.AddParameter(tableFieldSURNAME_ENGLISH, "@p_surname_eng");
command.Parameters.AddWithValue("p_surname_eng", obj.SurnameEnglish);
builder.AddParameter(tableFieldFIRSTNAME_ENGLISH, "@p_firstname_eng");
command.Parameters.AddWithValue("p_firstname_eng", obj.FirstNameEnglish);
builder.AddParameter(tableFieldSECONDNAME_ENGLISH, "@p_secondname_eng");
command.Parameters.AddWithValue("p_secondname_eng", obj.SecondNameEnglish);
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Thought obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldID_THOUGHT_TYPE, "@p_id_type");
{
object value = DBNull.Value;
if (obj.ThoughtType != null)
{
value = obj.ThoughtType.Id;
}
command.Parameters.AddWithValue("p_id_type", value);
}
builder.AddParameter(tableFieldNUMBER, "@p_number");
command.Parameters.AddWithValue("p_number", (object)obj.Number ?? DBNull.Value);
builder.AddParameter(tableFieldIDEA, "@p_idea");
command.Parameters.AddWithValue("p_idea", obj.Idea);
builder.AddParameter(tableFieldDESCRIPTION, "@p_desc");
command.Parameters.AddWithValue("p_desc", obj.Description);
builder.AddParameter(tableFieldNOTE, "@p_note");
command.Parameters.AddWithValue("p_note", obj.Note);
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Tag obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldNAME, "@p_name");
command.Parameters.AddWithValue("p_name", obj.Name);
}
private bool Add(Fact obj, out string message)
{
message = string.Empty;
bool result = false;
if (this.session != null && this.session.Connection != null && this.session.Connection.State == ConnectionState.Open)
{
SqlCommand command = new SqlCommand(string.Empty, this.session.Connection);
SQLCommandBuilder builder = new SQLCommandBuilder(TableNameWithScheme);
builder.AddParameter(tableFieldCREATION_DATE, "@p_create_date");
command.Parameters.AddWithValue("p_create_date", obj.CreationDate);
builder.AddParameter(tableFieldNUMBER, "@p_number");
command.Parameters.AddWithValue("p_number", GetNextNumber());
FillCommandBuilder(builder, command, obj);
builder.FinishString = "SELECT @@IDENTITY AS 'Identity'";
command.CommandText = builder.GenerateInsertText();
try
{
object value = command.ExecuteScalar();
if (value != null && value != DBNull.Value)
{
try
{
int id = Convert.ToInt32(value);
obj.Id = id;
result = true;
}
catch (Exception ex)
{
result = false;
message = ex.Message;
}
}
}
catch (Exception ex)
{
result = false;
message = ex.Message;
}
}
return(result);
}
//private bool Update(City obj, out string message)
//{
// bool result = false;
// message = string.Empty;
// if (this.session != null && this.session.Connection != null && this.session.Connection.State == ConnectionState.Open)
// {
// SqlCommand command = new SqlCommand(string.Empty, this.session.Connection);
// SQLCommandBuilder builder = new SQLCommandBuilder(TableNameWithScheme);
// FillCommandBuilder(builder, command, obj);
// builder.FinishString = string.Format("where {0} = @p_id", tableFieldID);
// command.Parameters.AddWithValue("p_id", obj.Id.Value);
// command.CommandText = builder.GenerateUpdateText();
// try
// {
// int numberOfRowsAffected = command.ExecuteNonQuery();
// if (numberOfRowsAffected == 1)
// {
// result = true;
// }
// }
// catch (Exception ex)
// {
// result = false;
// message = ex.Message;
// }
// }
// return result;
//}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, BookAuthorComposition obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldID_BOOK, "@p_id_book");
command.Parameters.AddWithValue("p_id_book", obj.IdBook);
builder.AddParameter(tableFieldID_AUTHOR, "@p_id_author");
command.Parameters.AddWithValue("p_id_author", obj.IdAuthor);
}
//private bool Update(City obj, out string message)
//{
// bool result = false;
// message = string.Empty;
// if (this.session != null && this.session.Connection != null && this.session.Connection.State == ConnectionState.Open)
// {
// SqlCommand command = new SqlCommand(string.Empty, this.session.Connection);
// SQLCommandBuilder builder = new SQLCommandBuilder(TableNameWithScheme);
// FillCommandBuilder(builder, command, obj);
// builder.FinishString = string.Format("where {0} = @p_id", tableFieldID);
// command.Parameters.AddWithValue("p_id", obj.Id.Value);
// command.CommandText = builder.GenerateUpdateText();
// try
// {
// int numberOfRowsAffected = command.ExecuteNonQuery();
// if (numberOfRowsAffected == 1)
// {
// result = true;
// }
// }
// catch (Exception ex)
// {
// result = false;
// message = ex.Message;
// }
// }
// return result;
//}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, BookTagComposition obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldID_BOOK, "@p_id_book");
command.Parameters.AddWithValue("p_id_book", obj.IdBook);
builder.AddParameter(tableFieldID_TAG, "@p_id_tag");
command.Parameters.AddWithValue("p_id_tag", obj.IdTag);
}
private bool Add(Author obj, out string message)
{
message = string.Empty;
bool result = false;
if (this.session != null && this.session.Connection != null && this.session.Connection.State == ConnectionState.Open)
{
SqlCommand command = new SqlCommand(string.Empty, this.session.Connection);
SQLCommandBuilder builder = new SQLCommandBuilder(TableNameWithScheme);
FillCommandBuilder(builder, command, obj);
builder.FinishString = "SELECT @@IDENTITY AS 'Identity'";
command.CommandText = builder.GenerateInsertText();
try
{
object value = command.ExecuteScalar();
if (value != null && value != DBNull.Value)
{
try
{
int id = Convert.ToInt32(value);
obj.Id = id;
result = true;
}
catch (Exception ex)
{
result = false;
message = ex.Message;
}
}
}
catch (Exception ex)
{
result = false;
message = ex.Message;
}
}
return(result);
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Reading obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldNAME, "@p_name");
command.Parameters.AddWithValue("p_name", obj.Name);
builder.AddParameter(tableFieldID_BOOK, "@p_id_book");
{
object value = DBNull.Value;
if (obj.Book != null)
{
value = obj.Book.Id;
}
command.Parameters.AddWithValue("p_id_book", value);
}
builder.AddParameter(tableFieldNUMBER, "@p_number");
command.Parameters.AddWithValue("p_number", (object)obj.Number ?? DBNull.Value);
builder.AddParameter(tableFieldFIRSTPAGE, "@p_firstpage");
command.Parameters.AddWithValue("p_firstpage", (object)obj.FirstPage ?? DBNull.Value);
builder.AddParameter(tableFieldLASTPAGE, "@p_lastpage");
command.Parameters.AddWithValue("p_lastpage", (object)obj.LastPage ?? DBNull.Value);
builder.AddParameter(tableFieldRETELLING, "@p_retelling");
command.Parameters.AddWithValue("p_retelling", obj.Retelling);
builder.AddParameter(tableFieldSUMMARY, "@p_summary");
command.Parameters.AddWithValue("p_summary", obj.Summary);
builder.AddParameter(tableFieldHINT, "@p_hint");
command.Parameters.AddWithValue("p_hint", obj.Hint);
builder.AddParameter(tableFieldNOTE, "@p_note");
command.Parameters.AddWithValue("p_note", obj.Note);
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Person obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldSURNAME, "@p_surname");
command.Parameters.AddWithValue("p_surname", obj.Surname);
builder.AddParameter(tableFieldFIRSTNAME, "@p_firstname");
command.Parameters.AddWithValue("p_firstname", obj.FirstName);
builder.AddParameter(tableFieldSECONDNAME, "@p_secondname");
command.Parameters.AddWithValue("p_secondname", obj.SecondName);
builder.AddParameter(tableFieldBIRTHDAY, "@p_birthday");
command.Parameters.AddWithValue("p_birthday", (object)obj.BirthDay ?? DBNull.Value);
builder.AddParameter(tableFieldMEETINGPLACE, "@p_meetingplace");
command.Parameters.AddWithValue("p_meetingplace", obj.MeetingPlace);
builder.AddParameter(tableFieldMEETINGDATE, "@p_meetingdate");
command.Parameters.AddWithValue("p_meetingdate", (object)obj.MeetingDate ?? DBNull.Value);
builder.AddParameter(tableFieldADDRESS, "@p_address");
command.Parameters.AddWithValue("p_address", obj.Address);
builder.AddParameter(tableFieldPHONENUMBER, "@p_phonenumber");
command.Parameters.AddWithValue("p_phonenumber", obj.PhoneNumber);
builder.AddParameter(tableFieldDESCRIPTION, "@p_description");
command.Parameters.AddWithValue("p_description", obj.Description);
builder.AddParameter(tableFieldNOTE, "@p_note");
command.Parameters.AddWithValue("p_note", obj.Note);
builder.AddParameter(tableFieldPHOTOFILENAME, "@p_photofilename");
command.Parameters.AddWithValue("p_photofilename", obj.PhotoFileName);
}
private bool Update(Reading obj, out string message)
{
bool result = false;
message = string.Empty;
if (this.session != null && this.session.Connection != null && this.session.Connection.State == ConnectionState.Open)
{
SqlCommand command = new SqlCommand(string.Empty, this.session.Connection);
SQLCommandBuilder builder = new SQLCommandBuilder(TableNameWithScheme);
FillCommandBuilder(builder, command, obj);
builder.FinishString = string.Format("where {0} = @p_id", tableFieldID);
command.Parameters.AddWithValue("p_id", obj.Id.Value);
command.CommandText = builder.GenerateUpdateText();
try
{
int numberOfRowsAffected = command.ExecuteNonQuery();
if (numberOfRowsAffected == 1)
{
result = true;
}
}
catch (Exception ex)
{
result = false;
message = ex.Message;
}
}
return(result);
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Publisher obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldNAME, "@p_name");
command.Parameters.AddWithValue("p_name", obj.Name);
builder.AddParameter(tableFieldSHORTNAME, "@p_shortname");
command.Parameters.AddWithValue("p_shortname", obj.ShortName);
builder.AddParameter(tableFieldID_CITY, "@p_id_city");
{
object value = DBNull.Value;
if (obj.City != null)
{
value = obj.City.Id;
}
command.Parameters.AddWithValue("p_id_city", value);
}
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Fact obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldNAME, "@p_name");
command.Parameters.AddWithValue("p_name", obj.Name);
//builder.AddParameter(tableFieldNUMBER, "@p_number");
//command.Parameters.AddWithValue("p_number", (object)obj.Number ?? DBNull.Value);
builder.AddParameter(tableFieldQUESTION, "@p_question");
command.Parameters.AddWithValue("p_question", obj.Question);
builder.AddParameter(tableFieldANSWER, "@p_answer");
command.Parameters.AddWithValue("p_answer", obj.Answer);
builder.AddParameter(tableFieldHINT, "@p_hint");
command.Parameters.AddWithValue("p_hint", obj.Hint);
builder.AddParameter(tableFieldNOTE, "@p_note");
command.Parameters.AddWithValue("p_note", obj.Note);
builder.AddParameter(tableFieldID_FACT_TYPE, "@p_id_fact_type");
{
object value = DBNull.Value;
if (obj.FactType != null)
{
value = obj.FactType.Id;
}
command.Parameters.AddWithValue("p_id_fact_type", value);
}
}
private void FillCommandBuilder(SQLCommandBuilder builder, SqlCommand command, Book obj)
{
if (builder == null || command == null || obj == null)
{
return;
}
builder.AddParameter(tableFieldNAME, "@p_name");
command.Parameters.AddWithValue("p_name", obj.Name);
builder.AddParameter(tableFieldPUB_YEAR, "@p_pub_year");
command.Parameters.AddWithValue("p_pub_year", (object)obj.PublicationYear ?? DBNull.Value);
builder.AddParameter(tableFieldISBN, "@p_isbn");
command.Parameters.AddWithValue("p_isbn", obj.ISBN);
builder.AddParameter(tableFieldID_PUBLISHER, "@p_id_publisher");
{
object value = DBNull.Value;
if (obj.Publisher != null)
{
value = obj.Publisher.Id;
}
command.Parameters.AddWithValue("p_id_publisher", value);
}
builder.AddParameter(tableFieldNAME_ORG, "@p_name_org");
command.Parameters.AddWithValue("p_name_org", obj.NameOriginal);
builder.AddParameter(tableFieldPUB_YEAR_ORG, "@p_pub_year_org");
command.Parameters.AddWithValue("p_pub_year_org", (object)obj.PublicationYearOriginal ?? DBNull.Value);
builder.AddParameter(tableFieldISBN_ORG, "@p_isbn_org");
command.Parameters.AddWithValue("p_isbn_org", obj.ISBNOriginal);
builder.AddParameter(tableFieldID_PUBLISHER_ORG, "@p_id_publisher_org");
{
object value = DBNull.Value;
if (obj.PublisherOriginal != null)
{
value = obj.PublisherOriginal.Id;
}
command.Parameters.AddWithValue("p_id_publisher_org", value);
}
builder.AddParameter(tableFieldEDITION, "@p_edition");
command.Parameters.AddWithValue("p_edition", obj.Edition);
builder.AddParameter(tableFieldPAGE_COUNT, "@p_page_count");
command.Parameters.AddWithValue("p_page_count", obj.PageCount);
builder.AddParameter(tableFieldREVIEW, "@p_review");
command.Parameters.AddWithValue("p_review", obj.Review);
builder.AddParameter(tableFieldESTIMATION, "@p_estimation");
command.Parameters.AddWithValue("p_estimation", obj.Estimation);
builder.AddParameter(tableFieldNOTE, "@p_note");
command.Parameters.AddWithValue("p_note", obj.Note);
}
