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();
}
}
