public void UpdateCashBackPlan(CashbackCriteriaBO objBO) { string query = @"UPDATE SBP_Cashback_Plan SET " + "[Plan_Name] ='" + objBO.PlanName + "'" + ",[Description] = '" + objBO.PlanDescription + "'" + ",[Plan_Date] = '" + objBO.PlanDate + "'" + ",[Min_Trade_Amount] = " + objBO.MinTradeAmount + ",[Rate] = " + objBO.Rate + ",[Effective_Date] = '" + objBO.EffectiveDate + "'" + ",[Entry_Date] = CONVERT(Datetime,CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME))" + ",[Entry_By] = '" + GlobalVariableBO._userName + "'" + " WHERE ID=" + objBO.ID; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(query); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void InsertCriteria(CashbackCriteriaBO cashBackCriteriaBo) { string queryString = ""; // CommonBAL commonBAL = new CommonBAL(); // cashBackCriteriaBo.ID = commonBAL.GenerateID("SBP_Cashback_Plan", "ID");̢ queryString = @"SBPSaveCashBackPlan"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@planName", SqlDbType.VarChar, cashBackCriteriaBo.PlanName); _dbConnection.AddParameter("@planDescription", SqlDbType.VarChar, cashBackCriteriaBo.PlanDescription); _dbConnection.AddParameter("@planDate", SqlDbType.DateTime, cashBackCriteriaBo.PlanDate.ToShortDateString()); _dbConnection.AddParameter("@minTradeAmount", SqlDbType.Money, cashBackCriteriaBo.MinTradeAmount); _dbConnection.AddParameter("@Rate", SqlDbType.Float, cashBackCriteriaBo.Rate); _dbConnection.AddParameter("@effectiveDate", SqlDbType.DateTime, cashBackCriteriaBo.EffectiveDate.ToShortDateString()); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }