public int Insert(RolesModle modle) { String sql = "INSERT INTO ROLES VALUES(@TITLE)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@TITLE", SqlDbType = SqlDbType.NVarChar, Value = modle.Title } })); }
public int UpdateById(RolesModle modle) { String sql = "UPDATE ROLES SET TITLE=@TITLE WHERE(ID=@ID)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@ID", SqlDbType = SqlDbType.Int, Value = modle.Id, }, new SqlParameter() { ParameterName = "@TITLE", SqlDbType = SqlDbType.Int, Value = modle.Id, }, })); }
public int Insert(RolesModle modle) { return(dal.Insert(modle)); }
public int UpdateById(RolesModle modle) { return(dal.UpdateById(modle)); }