public void insertLedgerTransaction(string strVoucherCode)
{
JournalVoucherMBL objJournalVoucherMBL = new JournalVoucherMBL();
JournalVoucherTBL objJournalVoucherTBL = new JournalVoucherTBL();
JournalVoucherTBO objJournalVoucherTBO = new JournalVoucherTBO();
ApplicationResult objResultSelect = new ApplicationResult();
ApplicationResult objResultInsert = new ApplicationResult();
DataTable dt = new DataTable();
objResultSelect = objJournalVoucherMBL.JournalVoucherM_Select(strVoucherCode, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
dt = objResultSelect.resultDT;
if (dt.Rows.Count > 0)
{
int intJournalID = Convert.ToInt32(dt.Rows[0][0].ToString());
for (int i = 1; i < dt.Rows.Count; i++)
{
int intOppJpurnaaID = Convert.ToInt32(dt.Rows[i][0].ToString());
objJournalVoucherTBO.JournalID = intJournalID;
objJournalVoucherTBO.OppositeJournalID = intOppJpurnaaID;
objJournalVoucherTBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objJournalVoucherTBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objJournalVoucherTBO.IsDeleted = 0;
objJournalVoucherTBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objJournalVoucherTBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objResultInsert = objJournalVoucherTBL.JournalVoucherT_Insert(objJournalVoucherTBO);
}
}
}
}
/// <summary>
/// To Insert details of JournalVoucherT in tbl_JournalVoucher_T table
/// Created By : Viral, 10/13/2014
/// Modified By :
/// </summary>
/// <param name="objJournalVoucherTBO"></param>
/// <returns></returns>
public ApplicationResult JournalVoucherT_Insert(JournalVoucherTBO objJournalVoucherTBO)
{
try
{
pSqlParameter = new SqlParameter[8];
pSqlParameter[0] = new SqlParameter("@JournalID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objJournalVoucherTBO.JournalID;
pSqlParameter[1] = new SqlParameter("@OppositeJournalID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objJournalVoucherTBO.OppositeJournalID;
pSqlParameter[2] = new SqlParameter("@Amount", SqlDbType.Float);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objJournalVoucherTBO.Amount;
pSqlParameter[3] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objJournalVoucherTBO.CreatedDate;
pSqlParameter[4] = new SqlParameter("@CreatedUserID", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objJournalVoucherTBO.CreatedUserID;
pSqlParameter[5] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objJournalVoucherTBO.IsDeleted;
pSqlParameter[6] = new SqlParameter("@LastModifideUserID", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objJournalVoucherTBO.LastModifideUserID;
pSqlParameter[7] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objJournalVoucherTBO.LastModifideDate;
sSql = "usp_tbl_JournalVoucher_T_Insert";
DataTable dtResult = new DataTable();
dtResult = DatabaseTransaction.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
ApplicationResult objResults = new ApplicationResult(dtResult);
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objJournalVoucherTBO = null;
}
}
/// <summary>
/// To Update details of JournalVoucherT in tbl_JournalVoucher_T table
/// Created By : Viral, 10/13/2014
/// Modified By :
/// </summary>
/// <param name="objJournalVoucherTBO"></param>
/// <returns></returns>
public ApplicationResult JournalVoucherT_Update(JournalVoucherTBO objJournalVoucherTBO)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@JournalTID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objJournalVoucherTBO.JournalTID;
pSqlParameter[1] = new SqlParameter("@JournalID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objJournalVoucherTBO.JournalID;
pSqlParameter[2] = new SqlParameter("@OppositeJournalID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objJournalVoucherTBO.OppositeJournalID;
pSqlParameter[3] = new SqlParameter("@Amount", SqlDbType.Float);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objJournalVoucherTBO.Amount;
pSqlParameter[4] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objJournalVoucherTBO.CreatedDate;
pSqlParameter[5] = new SqlParameter("@CreatedUserID", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objJournalVoucherTBO.CreatedUserID;
pSqlParameter[6] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objJournalVoucherTBO.IsDeleted;
pSqlParameter[7] = new SqlParameter("@LastModifideUserID", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objJournalVoucherTBO.LastModifideUserID;
pSqlParameter[8] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objJournalVoucherTBO.LastModifideDate;
sSql = "usp_tbl_JournalVoucher_T_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objJournalVoucherTBO = null;
}
}
