public void UpdateCashBackSessionData(int sessionId, CashBackSessionBO objBO) { string query = @"UPDATE SBP_Cashback_Session SET [Name] ='" + objBO.Name + "'" + ",[Description] = '" + objBO.Description + "'" + ",[Session_Start_Date] = '" + objBO.SessionStartDate + "'" + ",[Session_End_Date] = '" + objBO.SessionEndDate + "'" + ",[Remarks] = '" + objBO.Remarks + "'" + ",[Entry_Date] = '" + objBO.EntryDate + "'" + ",[Entry_By] = '" + GlobalVariableBO._userName + "'" + " WHERE ID=" + sessionId; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(query); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void SaveCashBackSessionData(CashBackSessionBO objBO) { string QueryString = ""; QueryString = @"INSERT INTO SBP_Cashback_Session ( [Name] , [Description] , [Session_Start_Date] , [Session_End_Date] , [Remarks] , [Entry_Date] , [Entry_By] , [IsProcessed] ) VALUES (" + "'" + objBO.Name + "'" + ",'" + objBO.Description + "'" + ",'" + objBO.SessionStartDate + "'" + ",'" + objBO.SessionEndDate + "'" + ",'" + objBO.Remarks + "'" + ",'" + objBO.EntryDate.ToShortDateString() + "'" + ",'" + GlobalVariableBO._userName + "'" + "," + objBO.IsProcessed + ")"; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(QueryString); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }