public void InsertCustomerGroup(AdditionalInformationBO additionalInformationBo) { string queryString = ""; CommonBAL oCommonBal = new CommonBAL(); additionalInformationBo.CustomerGroupID = oCommonBal.GenerateID("SBP_Cust_Group", "Cust_Group_ID"); queryString = @"SBPSaveCustomerGroup"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@CustomerGroupID", SqlDbType.Int, additionalInformationBo.CustomerGroupID); _dbConnection.AddParameter("@CustomerGroup", SqlDbType.VarChar, additionalInformationBo.CustomerGroup); _dbConnection.AddParameter("@CustomerGroupDescription", SqlDbType.VarChar, additionalInformationBo.CustomerGroupDescription); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
//public void InsertOrderChannel(AdditionalInformationBO additionalInformationBo) //{ // string queryString = ""; // CommonBAL oCommonBal = new CommonBAL(); // additionalInformationBo.OrderChannelID = oCommonBal.GenerateID("SBP_Order_Channel", "Order_Channel_ID"); // queryString = "INSERT INTO SBP_Order_Channel (Order_Channel_ID,Order_Channel,Status)" + // " Values('" + additionalInformationBo.OrderChannelID + "','" + additionalInformationBo.OrderChannel + "','" + additionalInformationBo.OrderChannelStatus + "')"; // try // { // _dbConnection.ConnectDatabase(); // _dbConnection.StartTransaction(); // _dbConnection.ExecuteNonQuery(queryString); // _dbConnection.Commit(); // } // catch (Exception) // { // _dbConnection.Rollback(); // throw; // } // finally // { // _dbConnection.CloseDatabase(); // } //} public void InsertCompanyCategory(AdditionalInformationBO additionalInformationBo) { string queryString = ""; CommonBAL oCommonBal = new CommonBAL(); additionalInformationBo.CompanyCategoryID = oCommonBal.GenerateID("SBP_Comp_Category", "Comp_Cat_ID"); queryString = @"SBPSaveCompanyCategory"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@CompanyCategoryID", SqlDbType.Int, additionalInformationBo.CompanyCategoryID); _dbConnection.AddParameter("@CompanyCategory", SqlDbType.NVarChar, additionalInformationBo.CompanyCategory); _dbConnection.AddParameter("@CompanyCategoryMinDate", SqlDbType.Int, additionalInformationBo.CompanyCategoryMinDate); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
//public void UpdateReferenceType(AdditionalInformationBO additionalInformationBo) //{ // string queryString = ""; // queryString = "UPDATE SBP_Reference_Type SET Reference='" + additionalInformationBo.ReferenceType + "' WHERE Ref_Type_ID=" + additionalInformationBo.ReferenceTypeID; // try // { // _dbConnection.ConnectDatabase(); // _dbConnection.StartTransaction(); // _dbConnection.ExecuteNonQuery(queryString); // _dbConnection.Commit(); // } // catch (Exception) // { // _dbConnection.Rollback(); // throw; // } // finally // { // _dbConnection.CloseDatabase(); // } //} //public void UpdatePaymentMedia(AdditionalInformationBO additionalInformationBo) //{ // string queryString = ""; // queryString = "UPDATE SBP_Payment_Media SET Payment_Media='" + additionalInformationBo.PaymentMedia + "' WHERE Payment_Media_ID=" + additionalInformationBo.PaymentMediaID; // try // { // _dbConnection.ConnectDatabase(); // _dbConnection.StartTransaction(); // _dbConnection.ExecuteNonQuery(queryString); // _dbConnection.Commit(); // } // catch (Exception) // { // _dbConnection.Rollback(); // throw; // } // finally // { // _dbConnection.CloseDatabase(); // } //} public void UpdateStatementCycle(AdditionalInformationBO additionalInformationBo) { string queryString = ""; queryString = @"SBPUpdateStatementCycle"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@StatementCycleID", SqlDbType.Int, additionalInformationBo.StatementCycleID); _dbConnection.AddParameter("@StatementCycle", SqlDbType.VarChar, additionalInformationBo.StatementCycle); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void UpdateCompanyCategory(AdditionalInformationBO additionalInformationBo) { string queryString = ""; queryString = @"SBPUpdateCompanyCategory"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@CompanyCategoryID", SqlDbType.Int, additionalInformationBo.CompanyCategoryID); _dbConnection.AddParameter("@CompanyCategory", SqlDbType.NVarChar, additionalInformationBo.CompanyCategory); _dbConnection.AddParameter("@CompanyCategoryMinDate", SqlDbType.Int, additionalInformationBo.CompanyCategoryMinDate); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void UpdateCustomerGroup(AdditionalInformationBO additionalInformationBo) { string queryString = ""; queryString = @"SBPUpdateCustomerGroup"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@CustomerGroupID", SqlDbType.Int, additionalInformationBo.CustomerGroupID); _dbConnection.AddParameter("@CustomerGroup", SqlDbType.VarChar, additionalInformationBo.CustomerGroup); _dbConnection.AddParameter("@CustomerGroupDescription", SqlDbType.VarChar, additionalInformationBo.CustomerGroupDescription); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void InsertStatementCycle(AdditionalInformationBO additionalInformationBo) { string queryString = ""; CommonBAL oCommonBal = new CommonBAL(); additionalInformationBo.StatementCycleID = oCommonBal.GenerateID("SBP_Statement_Cycle", "Statement_Cycle_ID"); queryString = @"SBPSaveStatementCycle"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@StatementCycleID", SqlDbType.Int, additionalInformationBo.StatementCycleID); _dbConnection.AddParameter("@StatementCycle", SqlDbType.VarChar, additionalInformationBo.StatementCycle); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }