public ActionResult Save(BankBookOpeningBalance objBankBookOpeningBalance)
{
if (ModelState.IsValid)
{
BankBookOpeningBalanceBLL objBankBookOpeningBalanceBLL = new BankBookOpeningBalanceBLL();
objBankBookOpeningBalanceBLL.CreateBankBookOpeningBalance(objBankBookOpeningBalance);
List <BankBookOpeningBalance> bankName = objBankBookOpeningBalanceBLL.GetBankNameforOpeningBalnce();
ViewBag.bankName = bankName;
}
return(View());
}
public List <BankBookOpeningBalance> GetBankNameforOpeningBalnce()
{
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
DbDataReader objDbDataReader = null;
List <BankBookOpeningBalance> objBankBookOpeningBalanceList = new List <BankBookOpeningBalance>();
BankBookOpeningBalance objBankBookOpeningBalance = new BankBookOpeningBalance();
try
{
objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspGetBankNameForBankBook]", CommandType.StoredProcedure);
if (objDbDataReader.HasRows)
{
while (objDbDataReader.Read())
{
objBankBookOpeningBalance = new BankBookOpeningBalance();
this.BuildModelForBuildModelForBankBookOpeningBalance(objDbDataReader, objBankBookOpeningBalance);
objBankBookOpeningBalanceList.Add(objBankBookOpeningBalance);
}
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
if (objDbDataReader != null)
{
objDbDataReader.Close();
}
objDataAccess.Dispose(objDbCommand);
}
return(objBankBookOpeningBalanceList);
}
public string CreateBankBookOpeningBalance(BankBookOpeningBalance objBankBookOpeningBalance)
{
int noRowCount = 0;
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
objDbCommand.AddInParameter("BankBookOpeningBalnceDate", objBankBookOpeningBalance.BankBookOpeningBalnceDate);
objDbCommand.AddInParameter("BankName", objBankBookOpeningBalance.BankName);
objDbCommand.AddInParameter("AccountNumber", objBankBookOpeningBalance.AccountNumber);
objDbCommand.AddInParameter("Amount", objBankBookOpeningBalance.Amount);
objDbCommand.AddInParameter("CreatedBy", SessionUtility.STSessionContainer.UserID);
try
{
noRowCount = objDataAccess.ExecuteNonQuery(objDbCommand, "[dbo].uspCreateBankBookOpeningBalance", CommandType.StoredProcedure);
if (noRowCount > 0)
{
objDbCommand.Transaction.Commit();
return("Save Successfully");
}
else
{
objDbCommand.Transaction.Rollback();
return("Save Failed");
}
}
catch (Exception ex)
{
objDbCommand.Transaction.Rollback();
throw new Exception("Database Error Occured", ex);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
}
private void BuildModelForBuildModelForBankBookOpeningBalance(DbDataReader objDataReader, BankBookOpeningBalance objBankBookOpeningBalance)
{
DataTable objDataTable = objDataReader.GetSchemaTable();
foreach (DataRow dr in objDataTable.Rows)
{
String column = dr.ItemArray[0].ToString();
switch (column)
{
case "BankBookOpeningBalnceId":
if (!Convert.IsDBNull(objDataReader["BankBookOpeningBalnceId"]))
{
objBankBookOpeningBalance.BankBookOpeningBalnceId = Convert.ToSByte(objDataReader["BankBookOpeningBalnceId"]);
}
break;
case "BankBookOpeningBalnceDate":
if (!Convert.IsDBNull(objDataReader["BankBookOpeningBalnceDate"]))
{
objBankBookOpeningBalance.BankBookOpeningBalnceDate = Convert.ToDateTime(objDataReader["BankBookOpeningBalnceDate"].ToString());
}
break;
case "BankName":
if (!Convert.IsDBNull(objDataReader["BankName"]))
{
objBankBookOpeningBalance.BankName = objDataReader["BankName"].ToString();
}
break;
case "BankDetailId":
if (!Convert.IsDBNull(objDataReader["BankDetailId"]))
{
objBankBookOpeningBalance.BankDetailId = Convert.ToSByte(objDataReader["BankDetailId"].ToString());
}
break;
case "AccountNumber":
if (!Convert.IsDBNull(objDataReader["AccountNumber"]))
{
objBankBookOpeningBalance.AccountNumber = objDataReader["AccountNumber"].ToString();
}
break;
case "Amount":
if (!Convert.IsDBNull(objDataReader["Amount"]))
{
objBankBookOpeningBalance.Amount = Convert.ToDecimal(objDataReader["Amount"].ToString());
}
break;
case "Remarks":
if (!Convert.IsDBNull(objDataReader["Remarks"]))
{
objBankBookOpeningBalance.Remarks = objDataReader["Remarks"].ToString();
}
break;
default:
break;
}
}
}