public void Update(CashBackRegBO cashBackRegBo)
{
string queryString = "";
queryString = @"SBPUpdateCashBackReg";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@custCode", SqlDbType.NVarChar, cashBackRegBo.CustCode);
_dbConnection.AddParameter("@sessionID", SqlDbType.Int, cashBackRegBo.SessionId);
_dbConnection.AddParameter("@planName", SqlDbType.VarChar, cashBackRegBo.PlanName);
_dbConnection.AddParameter("@cashbackamount", SqlDbType.Money, cashBackRegBo.CashBackAmount);
_dbConnection.AddParameter("@remark", SqlDbType.VarChar, cashBackRegBo.Remarks);
_dbConnection.AddParameter("@entryDate", SqlDbType.DateTime, cashBackRegBo.EntryDate);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Insert(CashBackRegBO cashBackRegBo)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
// cashBackRegBo.SlNo = commonBAL.GenerateID("SBP_CashBack_Reg", "CB_ID");
queryString = @"SBPSaveCashBackReg";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
// _dbConnection.AddParameter("@cbID", SqlDbType.Int, cashBackRegBo.SlNo);
_dbConnection.AddParameter("@custCode", SqlDbType.NVarChar, cashBackRegBo.CustCode);
_dbConnection.AddParameter("@sessionID", SqlDbType.Int, cashBackRegBo.SessionId);
_dbConnection.AddParameter("@planName", SqlDbType.VarChar, cashBackRegBo.PlanName);
_dbConnection.AddParameter("@cashbackamount", SqlDbType.Money, cashBackRegBo.CashBackAmount);
_dbConnection.AddParameter("@remark", SqlDbType.VarChar, cashBackRegBo.Remarks);
_dbConnection.AddParameter("@entryDate", SqlDbType.DateTime, cashBackRegBo.EntryDate);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
