public int InsertAccountsDailyTransactions(Accounts_DailyTransactions theAccountsDailyTransactions)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@VoucherNumber", SqlDbType.VarChar, theAccountsDailyTransactions.VoucherNumber));
InsertCommand.Parameters.Add(GetParameter("@TranDate", SqlDbType.VarChar, theAccountsDailyTransactions.TranDate));
InsertCommand.Parameters.Add(GetParameter("@TranNumber", SqlDbType.Int, theAccountsDailyTransactions.TranNumber));
InsertCommand.Parameters.Add(GetParameter("@SerialNumber", SqlDbType.Int, theAccountsDailyTransactions.SerialNumber));
InsertCommand.Parameters.Add(GetParameter("@AccountsID", SqlDbType.Int, theAccountsDailyTransactions.AccountsID));
InsertCommand.Parameters.Add(GetParameter("@AccountsCode", SqlDbType.VarChar, theAccountsDailyTransactions.AccountCode));
InsertCommand.Parameters.Add(GetParameter("@TranType", SqlDbType.VarChar, theAccountsDailyTransactions.TranType));
InsertCommand.Parameters.Add(GetParameter("@TranAmount", SqlDbType.Decimal, theAccountsDailyTransactions.TranAmount));
InsertCommand.Parameters.Add(GetParameter("@BalanceType", SqlDbType.VarChar, theAccountsDailyTransactions.BalanceType));
InsertCommand.Parameters.Add(GetParameter("@Narration", SqlDbType.VarChar, theAccountsDailyTransactions.Narration));
InsertCommand.Parameters.Add(GetParameter("@IsPosted", SqlDbType.VarChar, theAccountsDailyTransactions.IsPosted));
InsertCommand.Parameters.Add(GetParameter("@PostedBy", SqlDbType.Int, theAccountsDailyTransactions.PostedBy));
InsertCommand.Parameters.Add(GetParameter("@PostedDate", SqlDbType.VarChar, theAccountsDailyTransactions.PostedDate));
InsertCommand.Parameters.Add(GetParameter("@PostMode", SqlDbType.VarChar, theAccountsDailyTransactions.PostMode));
InsertCommand.Parameters.Add(GetParameter("@AccountsYearID", SqlDbType.Int, theAccountsDailyTransactions.AccountsYearID));
InsertCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, theAccountsDailyTransactions.OfficeID));
InsertCommand.Parameters.Add(GetParameter("@SocietyID", SqlDbType.Int, theAccountsDailyTransactions.SocietyID));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pAccounts_Transactions_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return ReturnValue;
}
}
public static Accounts_DailyTransactions DataRowToObject(DataRow dr)
{
Accounts_DailyTransactions TheAccounts_DailyTransactions = new Accounts_DailyTransactions();
TheAccounts_DailyTransactions.VoucherNumber = dr["VoucherNumber"].ToString();
TheAccounts_DailyTransactions.TranDate = dr["TranDate"].ToString();
TheAccounts_DailyTransactions.TranNumber = int.Parse(dr["TranNumber"].ToString());
TheAccounts_DailyTransactions.SerialNumber = int.Parse(dr["SerialNumber"].ToString());
TheAccounts_DailyTransactions.AccountsID = int.Parse(dr["AccountsID"].ToString());
TheAccounts_DailyTransactions.AccountCode = dr["AccountCode"].ToString();
TheAccounts_DailyTransactions.TranType = dr["TranType"].ToString();
TheAccounts_DailyTransactions.TranAmount = decimal.Parse(dr["TranAmount"].ToString());
TheAccounts_DailyTransactions.BalanceType = dr["BalanceType"].ToString();
TheAccounts_DailyTransactions.Narration = dr["Narration"].ToString();
TheAccounts_DailyTransactions.IsPosted = dr["IsPosted"].ToString();
TheAccounts_DailyTransactions.PostedBy = int.Parse(dr["PostedBy"].ToString());
TheAccounts_DailyTransactions.PostedDate = dr["PostedDate"].ToString();
TheAccounts_DailyTransactions.PostMode = dr["PostMode"].ToString();
TheAccounts_DailyTransactions.AccountsYearID = int.Parse(dr["AccountsYearID"].ToString());
TheAccounts_DailyTransactions.OfficeID = int.Parse(dr["OfficeID"].ToString());
TheAccounts_DailyTransactions.SocietyID = int.Parse(dr["SocietyID"].ToString());
return(TheAccounts_DailyTransactions);
}
public static int InsertAccountsDailyTransactions(Accounts_DailyTransactions theAccountsDailyTransactions)
{
return(AccountsTransactionsDataAccess.GetInstance.InsertAccountsDailyTransactions(theAccountsDailyTransactions));
}
/// <summary>
///
/// </summary>
/// <param name="theAccountsDailyTransactions"></param>
/// <returns></returns>
public int InsertAccountsDailyTransactions(Accounts_DailyTransactions theAccountsDailyTransactions)
{
return(AccountsTransactionIntegration.InsertAccountsDailyTransactions(theAccountsDailyTransactions));
}