public int Save(MonthlyTransactionInsert monthlyTransaction)
{
DataTable inputTable = ListtoDataTableConverter.ToDataTable(monthlyTransaction.MonthlyTransactions);
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertMonthlyTransaction";
cmd.Parameters.AddWithValue("@MonthlyTransaction", inputTable);
cmd.Parameters.AddWithValue("@KamethiNumber", monthlyTransaction.KamethiNumber);
cmd.Parameters.AddWithValue("@HostId", monthlyTransaction.HostId);
cmd.Parameters.AddWithValue("@TotalTakenAmount", monthlyTransaction.TotalTakenAmount);
cmd.Parameters.AddWithValue("@TotalDepositAmount", monthlyTransaction.TotalDepositeAmount);
cmd.Parameters.AddWithValue("@RemainingBalance", monthlyTransaction.TotalBalanceAmount);
return(Execute(cmd, ConfigurationHelper.ConnectionString));
}
}
public int Insert(MonthlyTransactionInsert monthlyTransaction)
{
int result = transactionService.Save(monthlyTransaction);
return(result);
}
