/// <summary> /// Put datarow raw values to entity object /// </summary> /// <param name="dr"></param> /// <returns></returns> protected CmsZoneUserRole fromDataRow(DataRow dr) { CmsZoneUserRole entity = new CmsZoneUserRole(); entity.ZoneId = Convert.ToInt32(dr["ZoneId"]); entity.UserRoleId = Convert.ToInt32(dr["UserRoleId"]); entity.ReadAccess = Convert.ToBoolean(dr["ReadAccess"]); entity.WriteAccess = Convert.ToBoolean(dr["WriteAccess"]); return(entity); }
/// <summary> /// Insert into `ZoneUserRole` /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool insert(CmsZoneUserRole entity) { StringBuilder sql = new StringBuilder("INSERT INTO "); sql.Append(TABLE_NAME); sql.Append(" (ZoneId,UserRoleId,ReadAccess,WriteAccess) VALUES ("); sql.Append(entity.ZoneId.ToString() + ","); sql.Append(entity.UserRoleId.ToString() + ","); sql.Append(entity.ReadAccessAsInt.ToString() + ","); sql.Append(entity.WriteAccessAsInt.ToString() + ");"); int affected = this.RunUpdateQuery(sql.ToString()); if (affected > 0) { return(true); } else { return(false); } }
/// <summary> /// Bulk insert into `ZoneUserRole` /// </summary> /// <param name="entityList"></param> /// <returns></returns> public bool insert(List <CmsZoneUserRole> entityList) { if (entityList.Count == 0) { return(true); } StringBuilder sql = new StringBuilder("INSERT INTO "); sql.Append(TABLE_NAME); sql.Append(" (ZoneId,UserRoleId,ReadAccess,WriteAccess) VALUES "); for (int x = 0; x < entityList.Count; x++) { CmsZoneUserRole g = entityList[x]; sql.Append("(" + g.ZoneId.ToString() + "," + g.UserRoleId.ToString() + "," + g.ReadAccessAsInt.ToString() + "," + g.WriteAccessAsInt.ToString() + ")"); if (x + 1 < entityList.Count) { sql.Append(","); } else { sql.Append(";"); } } int affected = this.RunUpdateQuery(sql.ToString()); if (affected == entityList.Count) { return(true); } else { return(false); } }