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