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