public void UpdateProcess_ListData(Process_ListBO objBO)
{
string query =
@"UPDATE SBP_Process_List
SET
[Name] ='" + objBO.Name + "'"
+ ",[Description] = '" + objBO.Description + "'"
+ ",[Entry_Date] = '" + objBO.EntryDate + "'"
+ ",[Entry_By] = '" + GlobalVariableBO._userName + "'"
+ " WHERE ID=" + objBO.Id;
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void SaveProcess_ListData(Process_ListBO objBO)
{
string QueryString = "";
QueryString = @"INSERT INTO SBP_Process_List
(
[Name]
, [Description]
, [Entry_Date]
, [Entry_By]
)
VALUES
("
+ "'" + objBO.Name + "'"
+ ",'" + objBO.Description + "'"
+ ",'" + objBO.EntryDate + "'"
+ ",'" + GlobalVariableBO._userName + "'"
+ ")";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(QueryString);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbConnection.CloseDatabase();
}
}