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