public int InsertBillingDetails(BillingDetails billingDetailsObject)
{
return (billingDetailsDALObject.InsertBillingDetails(billingDetailsObject));
}
public int InsertBillingDetails(BillingDetails billingDetailsObject)
{
int queryStatus = 0;
databaseObject.CommandToExecute = new SqlCommand();
databaseObject.CommandToExecute.CommandText = @"uspInsertBillingDetails";
databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure;
databaseObject.DBDataTable = new DataTable();
databaseObject.DBDataTable.Columns.Add("BillId", typeof(int));
databaseObject.DBDataTable.Columns.Add("BillAmount", typeof(int));
databaseObject.DBDataTable.Columns.Add("CardNumber", typeof(string));
databaseObject.DBDataTable.Columns.Add("ModeOfPayment", typeof(string));
databaseObject.DBDataTable.Rows.Add(billingDetailsObject.BillId,billingDetailsObject.BillAmount,
billingDetailsObject.CardNumber,billingDetailsObject.ModeOfPayment);
param1 = new SqlParameter();
param1.ParameterName = "@userBillingData";
param1.Value = databaseObject.DBDataTable;
param1.SqlDbType = SqlDbType.Structured;
try
{
databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection;
databaseObject.DatabaseConnection.Open();
databaseObject.CommandToExecute.Parameters.Add(param1);
queryStatus = databaseObject.CommandToExecute.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
return sqlEx.ErrorCode;
}
finally
{
databaseObject.DatabaseConnection.Close();
}
return queryStatus;
}