public void InsertRole(Model.Role oData) { try { scb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = scb.ConnectionString; ddq.CommandText = "INSERT INTO TBL_ROLE (ROLE,STATUS) VALUES ('" + oData.ROLE + "','" + oData.STATUS + "')"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }
public void UpdateRole(Model.Role oData) { try { scb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = scb.ConnectionString; ddq.CommandText = "UPDATE TBL_ROLE SET ROLE = '" + oData.ROLE + "', STATUS = '" + oData.STATUS + "' WHERE [ID] = '" + oData.ID + "'"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }
public Boolean isRecordExists(Model.Role oData) { try { scb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = scb.ConnectionString; string sQuery = ""; sQuery = "SELECT * FROM TBL_ROLE WHERE ROLE = '" + oData.ROLE + "'"; ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? true : false); } catch (Exception ex) { return(true); } }